The 10 Best Excel Keyboard Shortcuts

The 10 Best Excel Keyboard Shortcuts
To sign up for our daily newsletter covering the latest news, hacks and reviews, head HERE. For a running feed of all our stories, follow us on Twitter HERE. Or you can bookmark the Lifehacker Australia homepage to visit whenever you need a fix.

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

  • 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)

  • 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

Show more comments

Comments are closed.

Log in to comment on this story!