Essential keyboard shortcuts
Keyboard shortcuts are the best way to navigate cells or enter formulas more quickly. We’ve listed our favorites below.
- Ctrl +[Down|Up Arrow]: Moves to the top or bottom cell of the current column and combination of Ctrl with Left|Right Arrow key, moves to the cell furthest left or right in the current row
- Ctrl + Shift + Down/Up Arrow: Selects all the cells above or below the current cell
- Ctrl+ Home: Navigates to cell A1
- Ctrl+End: Navigates to the last cell that contains data
- Alt+F1: Creates a chart based on selected data set.
- Ctrl+Shift+L: Activate auto filter to data table
- Alt+Down Arrow: To open the drop down menu of autofilter. To use this shortcut:
- Alt+D+S: To sort the data set
- Ctrl+O: Open a new workbook
- Ctrl+N: Create a new workbook
- F4: Select the range and press F4 key, it will change the reference to absolute, mixed and relative.
Note: This isn’t an exhaustive list. Feel free to share your favorite keyboard shortcuts in Excel in the comments section below. Literally, I do 80% of excel tasks using shortcuts.
No comments:
Post a Comment