Excel Keyboard Shortcuts

Adds other nonadjacent cells or ranges to the selection

Adds to the selection (toggle)

Cancels the editing

Deletes all characters from the cursor to the end of the line

Deletes the character to the left of the cursor

Deletes the character to the right of the cursor

Open the shortcut menu

Edits a cell comment

Edits the active cell

Same as clicking the Edit Menu and selecting Copy

Same as clicking the Edit Menu and selecting Copy

Same as clicking the Edit Menu and selecting Cut

Same as clicking the Edit Menu and selecting Fill Down

Same as clicking the Edit Menu and selecting Fill Right

Same as clicking the Edit Menu and selecting Find

Same as clicking the Edit Menu and selecting Paste

Same as clicking the Edit Menu and selecting Paste

Same as clicking the Edit Menu and selecting Replace

Same as clicking the Edit Menu and selecting Undo

Same as clicking the Edit Menu and selecting Undo

Same as clicking the Edit Menu and selecting New

Same as clicking the Edit Menu and selecting Open

Same as clicking the Edit Menu and selecting Print

Same as clicking the Edit Menu and selecting Save

Same as clicking the Format Menu and selecting Style

Same as clicking the Insert Menu and selecting Hyperlink

Exits the program

Expands the selection in the direction indicated

Expands the selection to the beginning of the current row

Extends the selection as navigation keys are used

Repeats the last Find (Find Next)

Adds border to outline

Adds the comma format with two decimal places

Adds the currency format with two decimal places

Adds the date format (day, month, year)

Adds the general number format

Adds the percent format with no decimal places

Adds the time format (hour, minute, a.m./p.m.)

Sets or removes boldface

Sets or removes italic

Sets or removes strikethrough

Sets or removes underlining

Removes all borders

Closes the window

Cycles through the ways to display objects

Defines a name

Global calculation

Hides columns

Hides rows

Inserts a chart sheet

Inserts a new worksheet

Inserts a new worksheet

Opens and Displays the Creates Names dialog box

Opens and Displays the Find dialog box

Opens and Displays the Format dialog box for the selected object

Opens and Displays the Go To dialog box

Opens and Displays the Macro dialog box

Opens and Displays the What's This cursor

Opens and Displays Visual Basic Editor

Prompts Open command

Prompts Print command

Prompts Save As command

Prompts Save As command

Prompts Save command

Prompts Spelling command

Makes the menu bar active

Maximizes or restores the workbook window

Minimizes the workbook

Moves down one screen

Moves one screen to the left

Moves one screen to the right

Moves the cell pointer left to the preceding cell in the selection

Moves the cell pointer right to the next cell

Moves the cell pointer to the next corner of the current cell range

Moves the cell pointer up to the preceding cell in the selection

Moves the cursor one character in the direction of the arrow

Moves the cursor one word to the left

Moves the cursor one word to the right

Moves the cursor to the end of the line

Opens and Displays Help or the Office Assistant

Begins editing the active cell

Pastes a name into a formula

Repeats the last action

Moves to the next pane

Extends the selection as navigation keys are used

Calculates all sheets in all open workbooks

Makes the menu bar active

Creates a chart

Issues Save As command

Moves to the beginning of the row

Moves to the edge of a data block

Moves to the first cell in the worksheet (A1)

Moves to the last active cell of the worksheet

Moves to the lower-left cell displayed in the window

Moves to the next sheet

Moves to the next window

Moves to the next window

Moves to the previous pane of a window that has been split

Moves to the previous sheet

Moves to the previous window

Moves to the previous workbook window

Moves to the upper-left cell displayed in the window

Moves up one screen

Resizes the window

Restores the window size

Scrolls left, right, up or down one cell

Scrolls to display the active cell

Selects all

Selects the active cell in a range selection

Selects the block of data surrounding the active cell

Selects the entire column(s) in the selected range

Selects the entire row(s) in the selected range

Selects the entire worksheet

Starts a new line in the current cell

Toggles the display of outline symbols

Toggles the display of the standard toolbar

Unhides columns

Unhides rows

Enters the current date

Enters the current time

Inserts the AutoSum formula in an empty cell

Pastes a function into a formula

Prompts for a range or range name to select

Automatically SUM a column