Friday, 28 March 2014

Excel Worksheet Shortcuts - Very useful


ActionKey
Moving Forward to next worksheetCtrl + pagedown
Moving Backward to next worksheetCtrl+ Pageup
Selecting Multiple worksheets- ForwardCtrl + Shift + pagedown
Selecting Multiple worksheets- BackwardCtrl + 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.