What are your favorite keyboard short cuts?

[Long Nose]

OK besides the standard Ctrl-x, Ctrl-c, Ctrl-v, Ctrl-o, Ctrl-w, Ctrl-n, Alt-F11 what are your favorite excel keyboard short cuts?

Mine are;

1) Ctrl-[ -This takes you to the referenced cell, even when it's in another
workbook that is unopened.

2) F9 -High light part of a formula in a cell and hit F9 to see the result,
then esc to keep the formula. WARNING hitting enter will hard
code the result.

 

[Long Nose]

I forgot one.

3) Shift-F11 To add a new sheet to an existing workbook.


These are just a few I really like, but at one point had never used.

 

[al_b_cnu]

How about

Ctrl-Alt-Del to get out of Excel PDQ?

 

[Stormseed]

How about

Ctrl-Alt-Del to get out of Excel PDQ?

I would prefer Alt+F4. Atleast I can keep playing my games

 

[RoryA]

My most frequent are probably:
Alt+f8
Alt+;
Ctrl+Shift+#
and the Ctrl(+Shift)+Arrow keys

 

[schielrn]

Pretty much any shortcut for my macros are used most often, followed by:

Alt+;
Alt+=
Alt+Down Arrow
Control+d
Control+Shift+8
Control+Shift+9 and Control+Shift+0 becasue everyone in my office loves to hide columns when others need them.

And always Alt+Tab to go off this website and make it look like I am working in excel.

There probably some more, but those stick out to me at the moment.

 

[Long Nose]

rorya,

Very cool, I have not used some of those.

Ctrl+Shift+Arrows -is very handy when there is continuous data.

 

[RoryA]

Now how did I forget Alt+Tab...

 

[lenze]

I like to use SHIFT + Click on item on Toolbar. So, "Open" becomes "Save", "Print" becomes "Print Preview", "Sort Ascending" becomes "Sort Descending", "Single Underline" becomes "Double Underline", .etc
Allows me to dump (remove) several buttons from the toolbar.
lenze

 

[Long Nose]

I have to add a comment on my favorite Ctrl+[ shortcut.

If you are like me and work with spreadsheets that are linked to other spreadsheets and those are linked, etc. and all are buried in several levels of folders, then this is a real time saver.

To to look at those linked files I used to Ctrl+O and navigate over several folders to find one of the spreadsheets I needed. This task was repeated for each of our business sectors and took mucho time. I actually dreaded wading through all those folders just to refresh my memory, or double check a source. That's not the worst of it. Then once I found the source spreadsheet and opened it, I had to return to the original formula to see what sheet within the linked workbook was referenced and then what cell(s) were being referenced. These spreadsheets I'm linked to are massive and that alone took what seemed to be forever.

The beauty with this two stroke short cut is it does all that wading for me and almost instantly finds the workbook and opens to the sheet and cells referenced. Brill!