Excel Keyboard Shortcuts

If you spend a small amount of time learning the Excel keyboard shortcuts for the tasks that you perform most often, you will soon find that the shortcuts are a great time-saver, that can help you to work much more efficiently.

This page lists some of the most popular Excel keyboard shortcuts. The shortcuts have been organised into categories, to help you to find those that are of particular interest to you. It is recommended that you try to remember a few at a time, and make use of these in your day-to-day work, until they become second nature to you.


Copying and Pasting

CTRL-C-Copies the current selected cell or range of cells.
CTRL-V-Pastes from the clipboard, into the current selected cell or range of cells.
CTRL-D-

Fills down:

If a single cell or cells in a single row are selected:

  • copies the contents from the row above the selected range, into the selected range.

if cells in more than one row are selected:

  • copies the contents from the top row of the selected range, into all other rows of the selected range.
For examples, see the Excel Copy & Paste page.
CTRL-R-

Fills to the right:

If a single cell or cells in a single column are selected:

  • copies the contents from the column to the left of the selected range, into the selected range.

If cells in more than one column are selected:

  • copies the contents from the first column of the selected range, into all other columns of the selected range.
For examples, see the Excel Copy & Paste page.
CTRL-Z-Undo the last action.

Selecting Cells

CTRL - Left Mouse Button-

Selects multiple cells.

I.e. to select more than one cell (or range), first use the mouse to select on the first cell (or range), then press the CTRL key and use the mouse to select further cells or ranges.
SHIFT - Left Mouse Button-

Selects all cells from the last selected cell to the current cell.

I.e. to select a range, first use the left mouse key to click on a cell (or row or column) at the start of the range, then press the Shift key and select the cell at the end of the range.
SHIFT   ↓-Moves the current selected range down a row.
SHIFT   ↑-Moves the current selected range up a row.
SHIFT   →-Moves the current selected range right by one column.
SHIFT   ←-Moves the current selected range left by one column.
CTRL-SHIFT   ↓-Selects all cells below the current selection, up to the edge of the current data region.
CTRL-SHIFT   ↑-Selects all cells above the current selection, up to the edge of the current data region.
CTRL-SHIFT   →-Selects all cells to the right of the current selection, up to the edge of the current data region.
CTRL-SHIFT   ←-Selects all cells to the left of the current selection, up to the edge of the current data region.
CTRL-Spacebar-Selects the whole of the current column(s).
SHIFT-Spacebar-Selects the whole of the current row(s).
CTRL-A-Selects all cells in the current worksheet.

Find and Replace

CTRL-F-Find (i.e. opens the find and replace dialog box with the 'Find' Tab selected).
CTRL-H-Find & Replace(i.e. opens the find and replace dialog box with the 'Replace' Tab selected).
SHIFT-F4-Repeat the last Find request.

Selecting & Inserting Worksheets

SHIFT-F11-Insert a new worksheet into the current workbook.
ALT-SHIFT-F1-Insert a new worksheet into the current workbook.
CTRL-PageDown-Move to the next worksheet in the current workbook.
CTRL-PageUp-Move to the previous worksheet in the current workbook.
SHIFT-CTRL-PageDown-Select the current worksheet and the next worksheet
(if repeated, causes further sheets to be selected also).
SHIFT-CTRL-PageUp-Select the current worksheet and the previous worksheet
(if repeated, causes further sheets to be selected also).

Workbook Actions

CTRL-S-Save the Current workbook (under its current name).
F12-Save the Current workbook as a different name.
CTRL-O-Open an existing workbook.
CTRL-N-Open a new workbook.
CTRL-W-Close the current workbook.

Inputting Data

CTRL - ;-Inserts the current date into a cell.
CTRL - :-Inserts the current time into a cell.
F4-While in edit mode within a cell, cycles through the 4 different combinations of absolute and relative references:
A1
$A$1
A$1
$A1

Formatting Data

CTRL-B-Toggles bold on/off.
CTRL-U-Toggles underline on/off.
CTRL-I-Toggles italic on/off.

Excel Zoom

ALT-V Z-Brings up the Excel Zoom dialog box.


A more extensive list of Excel keyboard shortcuts is provided on the Microsoft Office website.