Excel is a powerful spreadsheet, but you can’t call yourself a power user until you’ve mastered the essential keyboard shortcuts. Here are the 10 everyone needs to know.
Longtime readers may recognise this as an expansion of a smaller list we ran back in 2011. I’ve mostly avoided obvious shortcuts that also work in other apps (such as Ctrl-Z for undo), but a couple are so important they have been singled out.
Excel has hundreds of keyboard shortcuts — look up ‘keyboard shortcuts’ in Excel help (accessed via the F1 key) for a full list or check out our comprehensive guide— but these are the ones you’ll keep returning to.
[clear]
Arrow keys: Navigate and select cells
This might seem ridiculously obvious, but I often see inexperienced Excel users clicking from cell to cell using their mouse. That’s very inefficient. Navigating from cell to cell with the arrow keys is much faster.
The real power of the arrow keys becomes apparent when you need to select multiple cells. Hold down the shift key and you can select multiple cells by moving up, down, left or right. (Shift also works with other navigation keys, such as PgUp, PgDn, Home and End.)
[clear]
Ctrl/Shift+Space: Select an entire row or column
For even more selection power, Ctrl+Space selects an entire column. Shift+Space selects an entire row. You can then use the shift keys plus the arrow keys as appropriate to select additional rows or columns.
[clear]
Ctrl+C/V/X: Copy/paste/cut
These aren’t Excel-specific, but they’re worth singling out because of the intelligent way Excel handles them. If you copy a cell with a formula and then paste it into another cell, the references will be automatically adjusted.
[clear]
F2: Edit the current cell
Don’t waste time double-clicking a cell or moving to the formula bar: hit F2 and edit the current cell immediately.
[clear]
Ctrl+1: Access cell properties
The cell properties dialog lets you set formatting, alignment, fill, protection and other options. Many of these are available in the Ribbon as well, but if you’re a veteran Excel user, this is a more familiar option.
[clear]
Ctrl+PgUp/PgDn: Navigate between worksheets
Complex Excel spreadsheets often have multiple worksheets. Rather than clicking on the bottom-of-screen tabs, use Ctrl-PgUp and Ctrl-PgDn to navigate.
[clear]
Ctrl+;: Enter the current date
Using Ctrl+; saves time checking and entering the date; I find myself using this a lot.
[clear]
F9: Calculates all worksheets
If you’re running a particularly complex spreadsheet, this is a fast way to make sure all formulas are up-to-date.
[clear]
Ctrl+`: Show or hide formulas
Note sure which formulas are running in your spreadsheet? Use Ctrl-` (the accent key, near the number 1) to see the formulas in the cells rather than their results.
[clear]
Alt: Access the ribbon
Every single Ribbon command in Excel can be accessed via the keyboard. Hit Alt and you’ll see a letter (or a two-letter combination) above each ribbon tab. Type that letter or combo and you’ll see letters over each feature of the ribbon. So typing Alt, then H (Home), then AL (Align Left) will align the current cell left.
Any additions to this list? Share them in the comments.
Comments
9 responses to “The 10 Best Excel Keyboard Shortcuts”
Do these work with OpenOffice by chance?
Ctrl + Shift + ;: Enter the current time.
To get an excel-compliant current date time, hit Ctrl + ; followed by a space followed by Ctrl + Shift + ;
Ctrl + Tab: Switch between open workbooks
Ctrl + num *: select the current region (current cell and all adjoining cells with data)
Select column/row then hit Ctrl + Shift + =: Insert column/row. Also inserts cut column/row.
Formatting shortcuts:
Ctrl + Shift + `: Apply general formatting (aka no specific formatting)
Ctrl + Shift + 1: Apply numeric formatting (0.00)
Ctrl + Shift + 2: Apply time formatting (h:mm AM/PM)
Ctrl + Shift + 3: Apply date formatting (dd-mmm-yyyy, depends on region)
Ctrl + Shift + 4: Apply currency formatting ($0.00, depends on region)
Ctrl + Shift + 5: Apply percentage formatting (0%, no decimal places, 1 = 100%)
Ctrl + Shift + 6: Apply scientific formatting (0.00E+00)
Ctrl/Alt/Del works a treat too.
Technically Alt for the ribbon/menu and the cut/copy/paste commands are Windows shortcuts.
I feel ripped off by two shortcuts.
I have a Mac these days and it feels like Microsoft deliberately made a dogs breakfast of the keyboard shortcuts to discourage switching.
Anyway, alternatives can be found somewhere but the one that seems to be missing is F4 in formulas to hard-fix cell references. Such a golden shortcut.
cmd+t is the mac alternative to F4. not the easiest or most convenient shortcut, but it still beats the hell out of manually entering $ signs
Alt e s t – Paste formatting
Or just download keyrocket – it’ll hammer shortcuts into you until you don’t use the mouse anymore
Ctrl + d to duplicate the cell immediately above.
F11 for instant chart
F4 to repeat last action, like formatting or insert, etc
Alt + = to auto sum the above set of data.