
Jump to:
Formatting Shortcuts | Navigation and Display Shortcuts | Formulas and Functions Shortcuts
Selection and Editing
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)
Formatting
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
Navigation and Display
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
Formulas and Functions
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