Friday, 28 March 2014

Action	Key
Moving Forward to next worksheet	Ctrl + pagedown
Moving Backward to next worksheet	Ctrl+ Pageup
Selecting Multiple worksheets- Forward	Ctrl + Shift + pagedown
Selecting Multiple worksheets- Backward	Ctrl + Shift + pageup

Excel Shortcuts: Selecting

These shortcuts help you to quickly select items in your Excel file in various ways.

Shift+Spacebar: Select the current Row
Ctrl+Spacebar: Select the current column
Ctrl+A: Select All, will select everything on the current worksheet. This is most often used in conjunction with the copy shortcut.

MacroMatician