Access Keys:
Skip to content (Access Key - 0)

Excel Keyboard Shortcuts

Added by LAURA NICOLE MASSARO KAUFFMAN , last edited by LAURA NICOLE MASSARO KAUFFMAN on Dec 19, 2008 23:11


Excel Keyboard Shortcuts

Keyboard shortcuts can save time and the effort of switching from the keyboard to the mouse to execute simple commands. Print this list of Excel keyboard shortcuts and keep it by your computer for a quick reference.

Icon

Note: A plus sign indicates that the keys need to be pressed at the same time.

Excel Shortcut Keys

Description

F2

Edit the selected cell.

F5

Go to a specific cell. For example, C6.

F7

Spell check the selected text and/or document.

F11

Create chart.

CTRL+SHIFT+;

Enter the current time.

CTRL+;

Enter the current date.

ALT+SHIFT+F1

Insert a New Worksheet.

SHIFT+F3

Open the Excel Formula window.

SHIFT+F5

Bring up search box.

CTRL+A

Select all contents of the worksheet.

CTRL+B

Bold highlighted selection.

CTRL+I

Italicize highlighted selection.

CTRL+K

Insert link.

CTRL+U

Underline highlighted selection.

CTRL+5

Strikethrough highlighted selection.

CTRL+P

Bring up the Print dialog box to begin printing.

CTRL+Z

Undo last action.

CTRL+F9

Minimize current window.

CTRL+F10

Maximize current window.

CTRL+F6

Switch between open workbooks/windows.

CTRL+PAGE UP

Move between Excel worksheets in the same Excel document.

CTRL+PAGE DOWN

Move between Excel worksheets in the same Excel document.

CTRL+TAB

Move between Excel open Excel files.

ALT+=

Create a formula to sum all of the above cells.

CTRL+'

Insert the value of the above cell into the currently selected cell.

CTRL+SHIFT+!

Format number in comma format.

CTRL+SHIFT+$

Format number in currency format.

CTRL+SHIFT+#

Format number in date format.

CTRL+SHIFT+%

Format number in percentage format.

CTRL+SHIFT+^

Format number in scientific format.

CTRL+SHIFT+@

Format number in time format.

CTRL+ARROW KEY

Move to next section of text.

CTRL+SPACE BAR

Select entire column.

SHIFT+SPACE BAR

Select entire row.

#top