Charlie’s List, or “214 Keyboard Shortcuts”

re: Charlie’s List, or “214 Keyboard Shortcuts”

Biff — Fri, 24 Feb 2006 08:20:08 GMT

Who can possibly remember them all?

<headache>

Shift + Ctrl + A - Insert arguments in formula

That comes in handy for functions in the ATP.

re: Charlie’s List, or “214 Keyboard Shortcuts”

Harlan Grove — Fri, 24 Feb 2006 09:02:43 GMT

You're conflating keyboard users with users of keyboard shortcuts. Many (most?) keyboard users tend to use the menus rather than the (obscure) keyboard shortcuts.

There are a few things that can be done using keyboard shortcuts but not the menu, e.g., switching from Ready mode to Edit mode. [Aside: will the Status Bar now show Select rather than Ready?] As for [F4], will it still cycle through relative/absolute variations in Edit and Enter modes when the cursor is at a range reference?

re: Charlie’s List, or “214 Keyboard Shortcuts”

Charlie Ellis — Fri, 24 Feb 2006 10:55:14 GMT

Harlan,

On the product team, we differentiate between accelerators, which are keyboard ways to access the Ribbon, menus and toolbars, and shortcuts which are essentially everything else. This list isn't meant to include accelerators, not because they aren't a big part of what keyboard users use (ALT+E+S+V+Enter and ALT+E+A+A come immediately to mind), but rather because shortcuts, unlike accelerators, are much more difficult to discover; the UI only lists a handful of them and good and reasonably complete documentation is often difficult to find.

"Select mode" is my own name for what Excel is in when it isn't in Edit, Enter, or Point modes. I always thought of it as "the mode you use to do cell selection." This list started out as my own personal spreadsheet of keyboard shortcuts that I aggregated from a bunch of sources (mostly the code - thanks in large part to Dan Cory who got a dump of parts of the code and cleaned it up a lot), so that's a hold-over of the way that I think of that mode. As a result you won't be seeing "Select" or "Select cells" on a status bar near you. That is, unless it catches on :)

F4 will absolutely still cycle through the verious modes of relative vs. absolute referencing. One of the things where this list isn't complete is in formula editing keyboard shortcuts. You'll also notice that F9 with text selected within a formula (which replaces the selection with the calculated result) doesn't show up here either. These were victims of a tradeoff I made for readability.

Thanks,

Charlie

re: Charlie’s List, or “214 Keyboard Shortcuts”

Jon Peltier — Fri, 24 Feb 2006 16:13:15 GMT

Ctrl + 1 is one of my favorite shortcuts. It's not just Format Cell, as listed above; it's Foramt {Selected Item}. This makes it very versatile.

I wonder why you list the following as among your own favorites:

Shift + F12 – Save
Ctrl + F12 – Open

They've always seemed redundant to me. Aren't Ctrl + S and Ctrl + O even easier to remember? And just as quick to type? I've been using these since before there was Windows.

- Jon

re: Charlie’s List, or “214 Keyboard Shortcuts”

Jim Rech — Fri, 24 Feb 2006 17:43:51 GMT

Charlie-

>>F4 will absolutely still cycle through the verious modes of relative vs. absolute referencing.

What I'd love to see is for this to work when pointing to a named range. Say A1 is named "Rg". Now F4 has no effect (=Rg). Really useful would be =Rg, =A1, =$A$1,=A$1,=$A1, =Rg. I raised this way back in the XL97 beta when the pointing method was changed to pick up a range's name rather than address.

Jim

An Unintentional Week of Keyboard

Jensen Harris: An Office User Interface Blog — Fri, 24 Feb 2006 18:01:00 GMT

For some reason (entirely unintentional) I've spent a bunch of this
week babbling about keyboard issues....

re: Charlie’s List, or “214 Keyboard Shortcuts”

Biff — Fri, 24 Feb 2006 23:28:14 GMT

Just in case we all forget, thanks for compiling that list. I'm sure it'll help having all (most) shortcuts readily available at-hand to be studied and memorized.

re: Charlie’s List, or “214 Keyboard Shortcuts”

Bill Jelen — Sun, 26 Feb 2006 23:19:52 GMT

Jensen Harris had mentioned that there were be a keyboard shortcut (Alt+Zero) that would allow you to quickly switch between the legacy keyboard accelerators and the new keyboard accelerators.
This way, you could live in "new mode" for most of the time, but using this hot key, you could quickly drop back to using a legacy accelerator if necessary.
This keystroke works in Excel Beta 1, but it is not in your table. Are there plans to keep this great shortcut in the final product?

and for us Mac users?

Simon Pride — Tue, 28 Feb 2006 00:59:35 GMT

As a Mac user who worked for almost 20 years on Windows Excel (who'd ever have thought we'd be able to say that, eh?) I really dislike the random remapping and absence of critical shortcut functionality in all recent Mac versions of Excel. I miss F2 for 'edit cell' and the Mac already has a perfectly good and traditionally-reinforced key binding for copy, paste or whatever the hell F2 does in Mac Excel. It's time to heave this baggage over the side and give Excel users the keystrokes our muscles know, where they don't conflict with the OS or its applications' dialects. Not all Mac user are mousebound Illustrator experts.

re: Charlie’s List, or “214 Keyboard Shortcuts”

David Gainer — Wed, 01 Mar 2006 01:20:36 GMT

Bill, the keyboard model is evolving, but we share the goal of being able to efficiently use both old and new keyboard shortcuts. Alt+Zero or something better will be in the final product. Stay tuned.

re: Charlie’s List, or “214 Keyboard Shortcuts”

David Gainer — Wed, 01 Mar 2006 01:22:36 GMT

Simon, I have passed your comments along to the Mac Excel folks.

Blogbob » Blog Archive » Excel keyboard shortcuts

Blogbob » Blog Archive » Excel keyboard shortcuts — Fri, 10 Mar 2006 00:00:32 GMT

PingBack from http://www.rohdeonline.com/?p=106

Are You Ready for EXCEL 2007???!!!!! | BankersBall

Are You Ready for EXCEL 2007???!!!!! | BankersBall — Sat, 06 Jan 2007 00:34:57 GMT

PingBack from http://www.bankersball.com/2007/01/05/are-you-ready-for-excel-2007/

What Keyboard Shortcuts Do You Want To See In Excel?

Microsoft Excel — Mon, 24 Sep 2007 23:01:14 GMT

About 18 months ago, I wrote a post on keyboard shortcuts: http://blogs.msdn.com/excel/archive/2006/02/23/538311.aspx

MSDN Blog Postings » What Keyboard Shortcuts Do You Want To See In Excel?

MSDN Blog Postings » What Keyboard Shortcuts Do You Want To See In Excel? — Tue, 25 Sep 2007 00:14:31 GMT

PingBack from http://msdnrss.thecoderblogs.com/2007/09/24/what-keyboard-shortcuts-do-you-want-to-see-in-excel/

Ghillie Suits » Microsoft Excel : Charlie’s List, or "214 Keyboard Shortcuts"

Ghillie Suits » Microsoft Excel : Charlie’s List, or "214 Keyboard Shortcuts" — Mon, 22 Oct 2007 22:02:21 GMT

PingBack from http://ghillie-suits.info/?p=18001

What Keyboard Shortcuts Do You Want To See In Excel?

Excel Team Blog (Mirror) — Sun, 06 Jan 2008 23:04:08 GMT

About 18 months ago, I wrote a post on keyboard shortcuts: http://blogs.msdn.com/excel/archive/2006/02

PC Office Compatibility mode for Mac Office | Tongfamily.com

PC Office Compatibility mode for Mac Office | Tongfamily.com — Sat, 13 Sep 2008 02:46:14 GMT

PingBack from http://www.tongfamily.com/2008/09/pc-office-compatibility-mode-for-mac-office/

antnotex: Link Vari

antnotex: Link Vari — Thu, 26 Feb 2009 03:40:54 GMT

PingBack from http://antnotex.wikidot.com/link-vari

Microsoft Excel Charlie s List or 214 Keyboard Shortcuts | internet marketing tools

Tue, 16 Jun 2009 08:02:15 GMT

PingBack from http://einternetmarketingtools.info/story.php?id=15724