What are your favorite keyboard short cuts?

[PA HS Teacher]

In reading through the previous posts, I don't remember seeing F4 used to repeat formatting.

If you change the cell formatting on one cell, click on another, and press F4, it will repeat the formatting changes you have just made. I find this especially helpful when I am doing custom number formatting combined with cell color, font etc.

I find this much faster than paste special formats

 

[Michael M]

F4 will repeat anything you have just done....type text, formatting, etc.

 

[Excelestial]

CTRL+ALT+Arrow Down
Let's me quickly populate thousands of cells.

 

[erik.van.geit]

some time ago it was
CTRL+ALT+DELETE
(got some problems with debugging code: now solved )

 

[excuse]

Ctrl+Shift+#

 

[jsjsrsjs]

Is there a way to jump back and forth between worksheets like ALT+TAB moves between workbooks?

 

[tbeards]

Ctrl PageDown to go to the tab to the right of the one you are in and Ctrl PageUp to go to the tab to the left

 

[jsjsrsjs]

Ctrl PageDown to go to the tab to the right of the one you are in and Ctrl PageUp to go to the tab to the left

Thanks tbeards! That's exactly what I needed.

 

[RobMatthews]

Ctrl PageDown to go to the tab to the right of the one you are in and Ctrl PageUp to go to the tab to the left

Or CTRL-Tab to scroll through open workbooks.

 

[Anil_samay]

ALT+H+L+H+D To highlight the duplicate entiries...


:D