Day to Day Shortcuts for Excel

Excel Tips and Tricks

I have compiled a list of shortcuts that I use regularly on a day to day basis.

These handy shortcuts should have you navigating and formatting your worksheets in no time at all. They require a bit of practice, but it’s definitely worth it.

Highlighting Shortcuts

Shortcut Key CombinationsDescription
Control + AThis will highlight the current region/table.
Control + A (x2)This will highlight the entire sheet.
Control + Shift + Down Arrow keyThis will highlight a column within a table, starting from the top of the column.

Note: watch out for blank cells, simply press the arrow again

Control + Shift + Right Arrow keyThis will highlight a row within a table, starting on the far left of the row.

Note: watch out for blank cells, simply press the arrow key again

Control + Shift + Right Arrow Key and
Control + Shift + Down Arrow Key
Combining these keys will highlight a large range of cells/table quickly.
Control key used in conjunction with the mouseThis will allow you to highlight non-adjacent cells within your worksheet.
Shift Key used in conjunction with the mouseThis will select a cell range

Navigation Shortcuts

Shortcut Key CombinationsDescription
Control + G or Press F5Go To

This will take you another cell on the worksheet

Control + Page Up
Control + Page Down
Switches between worksheet tabs
Navigation buttons use the Right Mouse Click

Navigation buttons bottom right of the screen.

Right mouse clicking on these buttons will display a list of worksheets in the workbook; use this menu to navigate to another sheet.

Control + HomeMove back to cell A1 (the top of the sheet)
Home KeyMove to the beginning of the row

Formatting Shortcuts

Shortcut Key CombinationsDescription
Control + Shit + ~This will apply General Number formatting to selected cells
Control + Shift + $This will apply currency formatting with 2 decimal places to selected cells
Control + Shift + %This will apply percentage formatting with 2 decimal places to selected cells
Control + # This will apply medium date formatting
Control + Shift + !This will apply the thousand separator with 2 decimal places to selected cells
Control + BThis will apply bold to selected cells
Control + IThis will apply Italics to selected cells
Control + Alt + VThis will display the Paste Special dialog box
Control + YRepeats the last command or action

Worksheet: Row and Column Shortcuts

Shortcut Key CombinationsDescription
Control + Plus Sign (+)This inserts a new blank row or column

Note: Highlight a row or column first before using the shortcut to insert the new row/column

Control + Shift + Plus Sign (+)
(using a laptop)
This inserts a new blank row or column

Note: Highlight a row or column first before using the shortcut to insert the new row/column

Control + Minus Sign (-)This deletes a column or a row depending on what is highlighted
Control + Shift + “Copies the value from the cell above the active cell into the cell
Control + NCreate a new blank workbook
Control + WCloses the current open workbook window
Control + ODisplays the Open dialog box to open a file
Control + NCreates a new workbook
Control + 9Allows you to hide the highlighted rows
Control + Shift + (This will unhide any hidden rows within the selection
Control + 0Allows you to hide the highlighted columns
Control + )This will unhide any hidden columns within the selection

Formula Shortcuts

Shortcut Key CombinationsDescription
Alt key + =This inserts the AutoSum formula
F4 Function KeyMakes a cell reference absolute e.g. =$F$10
Control Key + `Shows the formula in the cell rather then the value
F3 Function KeyThis will paste a defined name into a formula

Happy Practicing!