What are your favorite keyboard short cuts?

[SydneyGeek]

A number of goodies in this thread that I will have to try. Others I always use are:
Ctrl+PageUp
Ctrl+PageDown
Ctrl+End
Ctrl+Home

A

On wide sheets,
Alt+PgUp
Alt+PgDn

I also use Go To special a lot, so
ALT+E+G+S+O (for constants)
ALT+E+G+S+F (for formulas)

F3 to bring up the Name list when writing formulas

Alt+F8 to run a macro

Ctrl+* to select a region on the worksheet

There are others, but many have already been quoted earlier...

Denis

 

[Andrew Fergus]

And Ctrl+R to copy right and Ctrl+D to copy down. I also do this for a single cell when the active cell is immediately below or to the right of the cell I want to copy.

A

 

[SydneyGeek]

Copying formats from one column to the next:

Select the source column
Click the paintbrush
Click the right arrow (to copy formats right) etc.

Multiple entry:

Select some cells
Enter a value or formula
Ctrl+Enter

Denis

 

[al_b_cnu]

DOH! Yup, use those all the time too. Also Ctrl+. after having done Ctrl+* or Ctrl-A.

BTW, what is that sig of yours about? Disk storage flowchart symbol or something?

I think Andrew was trying out some shortcuts

 

[Expiry]

One of my recent favourites is ALT+;

This selects visible cells only. I've used this to great effect on a huge list of product codes I have. I had to enter a name for each product code, so I filtered on the code, typed in the name in one cell, CTRL + C, then ALT+ ;, then CTRL + V

 

[RoryA]

Double-clicking the format painter so you can repeatedly paste formats is another good shortcut (even though it's not keyboard)

 

[Domski]

Shift+Space & Ctrl+Space for selecting entire columns and rows is something I use a lot and F4 for cycling through relative/absolute/mixed range references is invaluable.

Dom

 

[Boller]

alt 0163

 

[xenou]

alt 0163

also, alt 0128

------------------------
Surprised, but did I miss ALT + F11 ? Since my keyboard has one key with the letter worn off, it is clearly my favorite -- c -- but I suspect this is because I have it customized for control-shift-c (hard copy a cell value) as well as good old copy a cell - I really smash it hard when I hit those three keys at once. Goodbye formulas. For the record, I've also customized shortcuts for turn on/off gridlines, turn off/on automatic calculation, and moving down or right on enter...

 

[RobMatthews]

If it exists, i reckon i've used it...
other not yet mentioned:
Ctrl+1 cell format
Ctrl+` (Tilde) Toggle Formula view (or whatever its proper name is)
Ctrl+W Close file
Alt Space x maximise window if nec

Oh, and Alt 0222 :-Þ