Excel keyboard shortcuts
Microsoft Excel shortcuts are one of the best ways to increase your efficiency when modelling. Some modellers even place their mouse out of reach to force themselves to learn shortcuts, and many end up shunning the mouse completely. We believe there is merit to both methods.
Here are some of our favourite shortcuts used by our consultants.
Microsoft Excel shortcuts are one of the best ways to increase your efficiency when modelling. Some modellers even place their mouse out of reach to force themselves to learn shortcuts, and many end up shunning the mouse completely. We believe there is merit to both methods.
Here are some of our favourite shortcuts used by our consultants.
- Apply absolute referencing ($)
- AutoFilter
- Clear All
- Copy
- Cut
- Edit the active cell
- Extend the selection of cells by one cell
- Fill Down
- Group Selected Rows/Columns
- Highlight precedent cells
- Insert AutoSum
- Move to the beginning of a Worksheet
- Move to the edge of selected row/column
- Move up, down, left or right respectively
- New Sheet
- New Workbook
- Open Go To dialog
- Paste
- Paste Special
- Redo
- Select an entire column
- Select an entire row
- Select continues range to the last non-blank cell
- Switch Workbooks
- Undo
- Ungroup Selected Rows/Columns