Navigating and Selecting Cells – Microsoft Excel Shortcuts
200 Excel Shortcuts for PC and Mac
So you think you’re fancy, huh? Just because you know how to copy and paste without the click of the mouse in Excel. Well, get ready to be even fancier (and more productive) because we’ve curated 200 of the best Excel keyboard shortcuts.
Navigating and Selecting Cells
Use your keyboard to navigate to any cell you wish. These shortcuts will enable you to select everything from words to individual data points and characters.
| Shortcut | Windows | Mac |
|---|---|---|
| Move one cell right Navigate to the cell to the right of that which you currently have selected. | → | ► |
| Move one cell left Navigate to the cell to the left of that which you currently have selected. | ← | ◄ |
| Move one cell up Navigate to the cell above that which you currently have selected. | ↑ | ▲ |
| Move one cell down Navigate to the cell below that which you currently have selected. | ↓ | ▼ |
| Move one screen right Move one screen length to the right from the view you currently have on your spreadsheet. This is a great shortcut for jumping around your data quickly. | Alt PgDn | Fn Option ▼ |
| Move one screen left Move one screen length to the left from the view you currently have on your spreadsheet. This is a great shortcut for jumping around your data quickly. | Alt PgUp | Fn Option ▲ |
| Move one screen up Move one screen length up from the view you currently have on your spreadsheet. This is a great shortcut for jumping around your data quickly. | PgDn | Fn ▲ |
| Move one screen down Move one screen length down from the view you currently have on your spreadsheet. This is a great shortcut for jumping around your data quickly. | PgUp | Fn ▼ |
| Move to the right edge of data range Navigate your Excel view to the right most edge of the data you have entered. | Ctrl → | Control ► |
| Move to the left edge of data range Navigate your Excel view to the left most edge of the data you have entered. | Ctrl ← | Control ◄ |
| Move to the top edge of data range Navigate your Excel view to the upper most edge of the data you have entered. | Ctrl ↑ | Control ▲ |
| Move to the bottom edge of data range Navigate your Excel view to the bottom most edge of the data you have entered. | Ctrl ↓ | Control ▼ |
| Navigate to the cell in the left most column of the current row Move to the beginning of the row of the current selection. | Home | Fn ◄ |
| Navigate to the last cell in a data range Move to the cell of the last row and column of the data range of the current selection. | Ctrl End | Fn Control ► |
| Move to first cell of data range This shortcut will get you back to the very beginning of your data range (the most upper-left data entry or edit). | Ctrl Home | Fn Control ◄ |
| Activate "end" mode This shortcut changes the function of your arrow keys. Once on, "end" mode brings you to the next available (empty) cell when using the right arrow key. | End | Fn ► |
| Select active cell only This shortcut allows you to select only the cell you have currently clicked on, when you previously were controlling multiple cells. | Shift Backspace | Shift Delete |
| Show active cell If you happen to scroll off the screen from your selection, use this shortcut to return to its loctation on your spreadsheet. | Ctrl Backspace | ⌘ Delete |
| Move selection down Begin controlling the cell below that which you currently have selected. The arrow keys can also be used, but this is an alterative and a preference of many Excel users. | Return | Enter |
| Move selection up Begin controlling the cell above that which you currently have selected. The arrow keys can also be used, but this is an alterative and a preference of many Excel users. | Shift Return | Shift Return |
| Move selection right Begin controlling the cell to the right of that which you currently have selected. The arrow keys can also be used, but this is an alterative and a preference of many Excel users. | Tab | Tab |
| Move selection left Begin controlling the cell to the left of that which you currently have selected. The arrow keys can also be used, but this is an alterative and a preference of many Excel users. | Shift Tab | Shift Tab |