Monday, November 30, 2009

Worksheet Shortcuts - Very useful


 
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.

No comments:

Post a Comment