Excel 2007 shortcut keys Windows

Basic

Useful Description Keys
Upvote4 0 Alternate between cell values and formulas CTRL+`
Upvote4 0 Unhide any hidden rows within a selection CTRL+SHFT+(
Upvote4 0 Unhide any hidden columns within a selection CTRL+SHFT+)
Upvote4 0 Apply a border to selected cells CTRL+SHFT+&
Upvote4 0 Remove outline border from selected cells CTRL+SHIFT+_
Upvote4 0 Apply the general number format CTRL+SHFT+~
Upvote4 0 Apply currency format with two decimal places CTRL+SHFT+$
Upvote4 0 Apply percentage format with no decimal places CTRL+SHFT+%
Upvote4 0 lies the Exponential number format with two decimal places. CTRL+SHIFT+^
Upvote4 0 Applies the Date format with the day, month, and year. CTRL+SHIFT+#
Upvote4 0 pplies the Time format with the hour and minute, and AM or PM. CTRL+SHIFT+@
Upvote4 0 Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values. CTRL+SHIFT+!
Upvote4 0 Selects the current region around the active cell (the data area enclosed by blank rows and blank columns). In a PivotTable, it selects the entire PivotTable report. CTRL+SHIFT+*
Upvote4 0 Enters the current time. CTRL+SHIFT+:
Upvote4 0 Copies the value from the cell above the active cell into the cell or the Formula Bar. CTRL+SHIFT+"
Upvote4 0 Displays the Insert dialog box to insert blank cells. CTRL+SHIFT+PLUS
Upvote4 0 Displays the Delete dialog box to delete the selected cells. CTRL+MINUS
Upvote4 0 Enters the current date. CTRL+;
Upvote4 0 Move one cell up, down, left, or right in a worksheet ARROW KEYS
Upvote4 0 Moves to the edge of the current data region in a worksheet CTRL+ARROW KEY
Upvote4 0 Moves one cell to the right or moves between unlocked cells in a protected worksheet TAB
Upvote4 0 Moves to the previous cell in a worksheet or the previous option in a dialog box SHIFT+TAB
Upvote4 0 Moves to cell in lower-right corner of window when SCROLL LOCK is turned on END
Upvote4 0 Moves to the last cell on a worksheet, in the lowest used row of the rightmost used column CTRL+END
Upvote4 0 Deletes one character to the left in the Formula Bar or clears the content of the active cell BACKSPACE
Upvote4 0 Completes a cell entry from cell or Formula Bar, and selects cell below ENTER
Upvote4 0 Cancels an entry in the cell or Formula Bar or closes an open menu, submenu or dialog box ESC
Upvote4 0 Move to beginning of a row or move to cell in upper-left when SCROLL LOCK is turned on HOME
Upvote4 0 Moves to the beginning of a worksheet CTRL+HOME
Upvote4 0 Extends the selection of cells to the beginning of the worksheet CTRL+SHIFT+HOME
Upvote4 0 Uses Undo to reverse the last command or delete the last entry typed CTRL+Z
Upvote4 0 Repeats the last command or action, if possible CTRL+Y
Upvote4 0 Uses Undo or Redo to reverse or restore the last automatic correction CTRL+SHIFT+Z
Upvote4 0 Repeats the last command or action, if possible F4
Upvote4 0 In a dialog box, performs the action for the selected button, or selects or clears a check box SPACEBAR
Upvote4 0 Opens a selected drop-down list ALT+DOWN ARROW
Back to top

File

Useful Description Keys
Upvote4 0 Creates a new, blank file CTRL+N
Upvote4 0 Saves the active file with its current file name, location, and file format CTRL+S
Back to top

Cell

Useful Description Keys
Upvote4 0 Enters the current time CTRL+:
Upvote4 0 Enters the current date CTRL+;
Upvote4 0 Edits active cell and moves insertion point in to Formula Bar when editing in a cell is turned off F2
Upvote4 0 Removes cell contents from selected cells without affecting cell formats or comments DELETE
Upvote4 0 Starts a new line in the same cell ALT+ENTER
Upvote4 0 Completes a cell entry and selects the cell above SHIFT+ENTER
Upvote4 0 Hides the selected rows CTRL+9
Upvote4 0 Hides the selected columns CTRL+0
Upvote4 0 Unhides any hidden rows within the selection CTRL+(
Upvote4 0 Unhides any hidden columns within the selection CTRL+)
Upvote4 0 Alternates between hiding objects, displaying objects, and displaying placeholders for objects CTRL+6
Upvote4 0 Edits a cell comment SHIFT+F2
Upvote4 0 Displays or hides the outline symbols CTRL+8
Back to top

Chart

Useful Description Keys
Upvote4 0 Creates a chart of the data in the current range ALT+F1
Upvote4 0 Creates a chart of the data in the current range F11
Back to top

Fill

Useful Description Keys
Upvote4 0 Uses Fill Down command to copy contents and format of topmost cell into the cells below CTRL+D
Upvote4 0 Uses Fill Right command to copy contents and format of leftmost cell into the cells to the right CTRL+R
Upvote4 0 Fills the selected cell range with the current entry CTRL+ENTER
Back to top

Formatting

Useful Description Keys
Upvote4 0 Applies the outline border to the selected cells CTRL+&
Upvote4 0 Removes the outline border from the selected cells CTRL+_
Upvote4 0 Applies the General number format CTRL+~
Upvote4 0 Applies the Currency format with two decimal places (negative numbers in parentheses) CTRL+$
Upvote4 0 Applies the Percentage format with no decimal places CTRL+%
Upvote4 0 Applies the Exponential number format with two decimal places CTRL+^
Upvote4 0 Applies the Date format with the day, month, and year CTRL+#
Upvote4 0 Applies the Time format with the hour and minute, and AM or PM CTRL+@
Upvote4 0 Applies Number format with two decimal places, commas, and minus sign for negative values CTRL+!
Upvote4 0 Alternates between displaying cell values and displaying formulas in the worksheet CTRL+`
Upvote4 0 Displays the Format Cells dialog box CTRL+1
Upvote4 0 Applies or removes bold formatting CTRL+2
Upvote4 0 Applies or removes italic formatting CTRL+3
Upvote4 0 Applies or removes underlining CTRL+4
Upvote4 0 Applies or removes strikethrough CTRL+5
Upvote4 0 Applies or removes bold formatting CTRL+B
Upvote4 0 Applies or removes italic formatting CTRL+I
Upvote4 0 Applies or removes underlining CTRL+U
Back to top

Formula

Useful Description Keys
Upvote4 0 Copies a formula from the cell above the active cell into the cell or the Formula Bar CTRL+'
Upvote4 0 Insert argument names and parentheses in a formula CTRL+SHIFT+A
Upvote4 0 Pastes a defined name into a formula F3
Back to top

Search

Useful Description Keys
Upvote4 0 Displays the Find and Replace dialog box CTRL+H
Upvote4 0 Repeats the last Find action SHIFT+F4
Back to top

Select

Useful Description Keys
Upvote4 0 Displays the Delete dialog box to delete the selected cells CTRL+-
Upvote4 0 Selects current region around the active cell and in a PivotTable, selects entire PivotTable report CTRL+*
Upvote4 0 Copies the value from the cell above the active cell into the cell or the Formula Bar CTRL+"
Upvote4 0 Displays the Insert dialog box to insert blank cells CTRL++
Upvote4 0 Select entire worksheet. If sheet contains data CTRL+A selects region, pressing again selects entire sheet CTRL+A
Upvote4 0 Copies the selected cells CTRL+C
Upvote4 0 Selects all cells that contain comments CTRL+SHIFT+O
Upvote4 0 Inserts contents of Clipboard at insertion point CTRL+V
Upvote4 0 Cuts the selected cells CTRL+X
Upvote4 0 Extends the selection of cells by one cell SHIFT+ARROW KEY
Upvote4 0 Extends the selection of cells to the last nonblank cell in the same column or row as the active cell CTRL+SHIFT+ARROW KEY
Upvote4 0 Selects menu to left or right when a menu is visible LEFT ARROW OR RIGHT ARROW
Upvote4 0 Selects the next or previous command when a menu or submenu is open DOWN ARROW OR UP ARROW
Upvote4 0 Extends the selection of cells to the last used cell on the worksheet (lower-right corner) CTRL+SHIFT+END
Upvote4 0 Selects the current and previous sheet in a workbook CTRL+SHIFT+PAGE UP
Upvote4 0 Selects an entire column in a worksheet CTRL+SPACEBAR
Upvote4 0 Selects an entire row in a worksheet SHIFT+SPACEBAR
Upvote4 0 Selects entire worksheet CTRL+SHIFT+SPACEBAR
Back to top

Task

Useful Description Keys
Upvote4 0 Displays the Help task pane F1
Upvote4 0 Closes and reopens the current task pane CTRL+F1
Back to top

Window

Useful Description Keys
Upvote4 0 Displays or hides the Standard toolbar CTRL+7
Upvote4 0 Displays the Find dialog box CTRL+F OR SHIFT+F5
Upvote4 0 Displays the Go To dialog box CTRL+G
Upvote4 0 Displays Insert Hyperlink dialog box CTRL+K
Upvote4 0 Displays the Create List dialog box CTRL+L
Upvote4 0 Displays the Open dialog box to open or find a file CTRL+O
Upvote4 0 Displays the Print dialog box CTRL+P
Upvote4 0 Closes the selected workbook window CTRL+W
Upvote4 0 Inserts a new worksheet ALT+SHIFT+F1
Upvote4 0 Displays the Insert Function dialog box SHIFT+F3
Upvote4 0 Closes the selected workbook window CTRL+F4
Upvote4 0 Displays the Go To dialog box F5
Upvote4 0 Restores the window size of the selected workbook window CTRL+F5
Upvote4 0 Switches to the next pane in a worksheet that has been split (Window menu, Split command) F6
Upvote4 0 Switches to the previous pane in a worksheet that has been split SHIFT+F6
Upvote4 0 Switches to the next workbook window when more than one workbook window is open CTRL+F6
Upvote4 0 Displays the Spelling dialog box to check spelling in the active worksheet or selected range F7
Upvote4 0 Performs Move command on workbook window. Use arrow keys to move the window, press ESC to finish CTRL+F7
Upvote4 0 Turns extend mode on or off. Use arrow keys to extend the selection F8
Upvote4 0 Enables you to add a non-adjacent cell or range to a selection of cells by using the arrow keys SHIFT+F8
Upvote4 0 Performs Size command when a workbook is not maximized CTRL+F8
Upvote4 0 Displays the Macro dialog box to run, edit, or delete a macro ALT+F8
Upvote4 0 Calculates all worksheets in all open workbooks F9
Upvote4 0 Calculates the selected a portion of a formula and replaces the selected portion with the calculated value F9 FOLLOWED BY ENTER (OR FOLLOWED BY CTRL+SHIFT+ENTER FOR ARRAY
Upvote4 0 Calculates the active worksheet SHIFT+F9
Upvote4 0 Calculates all worksheets in all open workbooks CTRL+ALT+F9
Upvote4 0 Rechecks dependent formulas, and calculates all cells in open workbooks CTRL+ALT+SHIFT+F9
Upvote4 0 Minimizes a workbook window to an icon CTRL+F9
Upvote4 0 Selects the menu bar or closes an open menu and submenu at the same time F10
Upvote4 0 Displays the shortcut menu for a selected item SHIFT+F10
Upvote4 0 Displays menu or message for a smart tag. If multiple smart tags present, switches to next smart tag ALT+SHIFT+F10
Upvote4 0 Maximizes or restores the selected workbook window CTRL+F10
Upvote4 0 Inserts a new worksheet SHIFT+F11
Upvote4 0 Opens the Visual Basic Editor ALT+F11
Upvote4 0 Opens the Microsoft Script Editor ALT+SHIFT+F11
Upvote4 0 Displays the Save As dialog box F12
Upvote4 0 Moves one screen down in a worksheet PAGE DOWN
Upvote4 0 Moves one screen to the right in a worksheet ALT+PAGE DOWN
Upvote4 0 Moves to the next sheet in a workbook CTRL+PAGE DOWN
Upvote4 0 Selects the current and next sheet in a workbook CTRL+SHIFT+PAGE DOWN
Upvote4 0 Moves one screen up in a worksheet PAGE UP
Upvote4 0 Moves one screen to the left in a worksheet ALT+PAGE UP
Upvote4 0 Moves to the previous sheet in a workbook CTRL+PAGE UP
Upvote4 0 Displays the Control menu for the Excel window ALT+SPACEBAR
Upvote4 0 Switches to the next tab in dialog box CTRL+TAB
Upvote4 0 Switches to the previous tab in a dialog box CTRL+SHIFT+TAB
Back to top

We aim to provide a service which helps you get more from your software. If you spot that our information is incorrect in any way, please contact us and we will update it accordingly.

This website is not in any way connected to Excel.