Switch between the EXCEL Sheets without Mouse

Switch between the EXCEL Sheets without Mouse

To change to the next worksheet to the right press CTRL & page down button from keyboard. And change to the worksheet to the left press CTRL & page up button from keyboard.

MS EXCEL keyboard shortcuts

Keyboard shortcuts are the best way to navigate cells or enter formulas more quickly. We’ve listed our favorites below.

  1. Ctrl +[Down/Up Arrow]:Moves to the top or bottom cell of the current column and combination of  rows
  2. Ctrl with Left/Right Arrowkey, moves to the cell furthest left or right in the current row
  3. Ctrl + Shift + Down/Up Arrow:Selects all the cells above or below the current cell
  4. Ctrl+ Home:Navigates to cell A1
  5. Ctrl+End:Navigates to the last cell that contains data
  6. Alt+F1:Creates a chart based on selected data set.
  7. Ctrl+Shift+L: Activate auto filter to data table
  8. Alt+Down Arrow:To open the drop down menu of auto filter.  To use this shortcut:
  9. Alt+D+S: To sort the data set
  10. Ctrl+O:Open a new workbook
  11. Ctrl+N:Create a new workbook
  1. F4:Select the range and press F4

Leave a Reply

Your email address will not be published. Required fields are marked *