Microsoft Excel Shortcut Keys

Move one cell up, down, left, or right: ARROW keys

Move to the edge of the current data region: CONTROL+ARROW key

Move to the beginning of the row: HOME

Move to the beginning of the worksheet: CONTROL+HOME

Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottom-most used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1: CONTROL+END

Move down one screen: PAGE DOWN

Move up one screen: PAGE UP

Move one screen to the right: ALT+PAGE DOWN

Move one screen to the left: ALT+PAGE UP

Move to the next sheet in the workbook: CONTROL+PAGE DOWN

Move to the previous sheet in the workbook: CONTROL+PAGE UP

Move to the next workbook or window: CONTROL+F6 or CONTROL+TAB

Move to the previous workbook or window: CONTROL+SHIFT+F6 or CONTROL+SHIFT+TAB

Move to the next pane in a workbook that has been split: F6

Move to the previous pane in a workbook that has been split: SHIFT+F6

Scroll to display the active cell: CONTROL+BACKSPACE

Display the Go To dialog box: F5

Display the Find dialog box: SHIFT+F5

Repeat the last Find action (same as Find Next): SHIFT+F4

Move between unlocked cells on a protected worksheet: TAB

Turn End mode on or off: END

Move by one block of data within a row or column: END, arrow key

Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottom-most used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1: END, HOME

Move to the last cell to the right in the current row that is not blank; unavailable if you have selected the Transition navigation keys check box on the Transition tab (Tools menu, Options command): END, ENTER

Turn SCROLL LOCK on or off: SCROLL LOCK

Move to the cell in the upper-left corner of the window: HOME

Move to the cell in the lower-right corner of the window: END

Scroll one row up or down: UP ARROW or DOWN ARROW

Scroll one column left or right: LEFT ARROW or RIGHT ARROW

Tip When you use scrolling keys (such as PAGE UP and PAGE DOWN) with SCROLL LOCK turned off, your selection moves the distance you scroll. If you want to preserve your selection while you scroll through the worksheet, turn on SCROLL LOCK first.

Display the Print dialog box: CONTROL+P or CONTROL+SHIFT+F12

Move around the page when zoomed in: Arrow keys

Move by one page when zoomed out: PAGE UP or PAGE DOWN

Move to the first page when zoomed out: CONTROL+UP ARROW or CONTROL+LEFT ARROW

Move to the last page when zoomed out: CONTROL+DOWN ARROW or CONTROL+RIGHT ARROW

Insert a new worksheet: SHIFT+F11 or ALT+SHIFT+F1

Create a chart that uses the current range: F11 or ALT+F1

Display the Macro dialog box: ALT+F8

Display the Visual Basic Editor: ALT+F11

Insert a Microsoft Excel 4.0 macro sheet: CONTROL+F11

Move to the next sheet in the workbook: CONTROL+PAGE DOWN

Move to the previous sheet in the workbook: CONTROL+PAGE UP

Select the current and next sheet in the workbook: SHIFT+CONTROL+PAGE DOWN

Select the current and previous sheet in the workbook: SHIFT+CONTROL+PAGE UP

Complete a cell entry and move down in the selection: ENTER

Start a new line in the same cell: ALT+ENTER

Fill the selected cell range with the current entry: CONTROL+ENTER

Complete a cell entry and move up in the selection: SHIFT+ENTER

Complete a cell entry and move to the right in the selection: TAB

Complete a cell entry and move to the left in the selection: SHIFT+TAB

Cancel a cell entry: ESCAPE

Delete the character to the left of the insertion point, or delete the selection: BACKSPACE

Delete the character to the right of the insertion point, or delete the selection: DELETE

Delete text to the end of the line: CONTROL+DELETE

Move one character up, down, left, or right: Arrow keys

Move to the beginning of the line: HOME

Repeat the last action: F4 or CONTROL+Y

Edit a cell comment: SHIFT+F2

Create names from row and column labels: CONTROL+SHIFT+F3

Fill down: CONTROL+D

Fill to the right: CONTROL+R

Define a name: CONTROL+F3

Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contents: BACKSPACE

Complete a cell entry: ENTER

Enter a formula as an array formula: CONTROL+SHIFT+ENTER

Cancel an entry in the cell or formula bar: ESCAPE

Display the Formula Palette after you type a function name in a formula: CONTROL+A

Insert the argument names and parentheses for a function after you type a function name in a formula: CONTROL+SHIFT+A

Insert a hyperlink: CONTROL+K

Activate a hyperlink: ENTER (in a cell with a hyperlink)

Edit the active cell and position the insertion point at the end of the line: F2

Paste a defined name into a formula: F3

Paste a function into a formula: SHIFT+F3

Calculate all sheets in all open workbooks: F9

Calculate all sheets in the active workbook: CONTROL+ALT+F9

Calculate the active worksheet: SHIFT+F9

Start a formula: = (equal sign)

Insert the AutoSum formula: ALT+= (equal sign)

Enter the date: CONTROL+; (semicolon)

Enter the time: CONTROL+SHIFT+: (colon)

Copy the value from the cell above the active cell into the cell or the formula bar: CONTROL+SHIFT+" (quotation mark)

Alternate between displaying cell values and displaying cell formulas: CONTROL+` (single left quotation mark)

Copy a formula from the cell above the active cell into the cell or the formula bar: CONTROL+' (apostrophe)

Display the AutoComplete list: ALT+DOWN ARROW

Display the Style dialog box: ALT+' (apostrophe)

Display the Format Cells dialog box: CONTROL+1

Apply the General number format: CONTROL+SHIFT+~

Apply the Currency format with two decimal places (negative numbers appear in parentheses): CONTROL+SHIFT+$

Apply the Percentage format with no decimal places: CONTROL+SHIFT+%

Apply the Exponential number format with two decimal places: CONTROL+SHIFT+^

Apply the Date format with the day, month, and year: CONTROL+SHIFT+#

Apply the Time format with the hour and minute, and indicate A.M. or P.M.: CONTROL+SHIFT+@

Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values: CONTROL+SHIFT+!

Apply the outline border: CONTROL+SHIFT+&

Remove outline borders: CONTROL+SHIFT+_

Apply or remove bold formatting: CONTROL+B

Apply or remove italic formatting: CONTROL+I

Apply or remove an underline: CONTROL+U

Apply or remove strikethrough formatting: CONTROL+5

Hide rows: CONTROL+9

Unhide rows: CONTROL+SHIFT+( (opening parenthesis)

Hide columns: CONTROL+0 (zero)

Unhide columns: CONTROL+SHIFT+) (closing parenthesis)

Edit the active cell and put the insertion point at the end of the line: F2

Cancel an entry in the cell or formula bar: ESCAPE

Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents: BACKSPACE

Paste a defined name into a formula: F3

Complete a cell entry: ENTER

Enter a formula as an array formula: CONTROL+SHIFT+ENTER

Display the Formula Palette after you type a function name in a formula: CONTROL+A

Insert the argument names and parentheses for a function, after you type a function name in a formula: CONTROL+SHIFT+A

Display the Spelling dialog box: F7

Copy the selection: CONTROL+C

Cut the selection: CONTROL+X

Paste the selection: CONTROL+V

Clear the contents of the selection: DELETE

Delete the selection: CONTROL+HYPHEN

Undo the last action: CONTROL+Z

Insert blank cells: CONTROL+SHIFT+PLUS SIGN

Move from top to bottom within the selection (down), or move in the direction that is selected on the Edit tab (Tools menu, Options command): ENTER

Move from bottom to top within the selection (up), or move opposite to the direction that is selected on the Edit tab (Tools menu, Options command): SHIFT+ENTER

Move from left to right within the selection, or move down one cell if only one column is selected: TAB

Move from right to left within the selection, or move up one cell if only one column is selected: SHIFT+TAB

Move clockwise to the next corner of the selection: CONTROL+PERIOD

Move to the right between nonadjacent selections: CONTROL+ALT+RIGHT ARROW

Move to the left between nonadjacent selections: CONTROL+ALT+LEFT ARROW

Select the current region around the active cell (the current region is a data area enclosed by blank rows and blank columns): CONTROL+SHIFT+* (asterisk)

Extend the selection by one cell: SHIFT+ARROW key

Extend the selection to the last nonblank cell in the same column or row as the active cell: CONTROL+SHIFT+ARROW key

Extend the selection to the beginning of the row: SHIFT+HOME

Extend the selection to the beginning of the worksheet: CONTROL+SHIFT+HOME

Extend the selection to the last used cell on the worksheet (lower-right corner): CONTROL+SHIFT+END

Select the entire column: CONTROL+SPACEBAR

Select the entire row: SHIFT+SPACEBAR

Select the entire worksheet: CONTROL+A

Select only the active cell when multiple cells are selected: SHIFT+BACKSPACE

Extend the selection down one screen: SHIFT+PAGE DOWN

Extend the selection up one screen: SHIFT+PAGE UP

With an object selected, select all objects on a sheet: CONTROL+SHIFT+SPACEBAR

Alternate between hiding objects, displaying objects, and displaying placeholders for objects: CONTROL+6

Show or hide the Standard toolbar: CONTROL+7

Turn on extending a selection by using the arrow keys: F8

Add another range of cells to the selection; or use the arrow keys to move to the start of the range you want to add, and then press F8 and the arrow keys to select the next range: SHIFT+F8

Extend the selection to the cell in the upper-left corner of the window: SCROLL LOCK, SHIFT+HOME

Extend the selection to the cell in the lower-right corner of the window: SCROLL LOCK, SHIFT+END

Tip When you use the scrolling keys (such as PAGE UP and PAGE DOWN) with SCROLL LOCK turned off, your selection moves the distance you scroll. If you want to keep the same selection as you scroll, turn on SCROLL LOCK first.

Turn End mode on or off: END

Extend the selection to the last nonblank cell in the same column or row as the active cell: END, SHIFT+ARROW key

Extend the selection to the last cell used on the worksheet (lower-right corner): END, SHIFT+HOME

Extend the selection to the last cell in the current row. This keystroke is unavailable if you selected the Transition navigation keys check box on the Transition tab (Tools menu, Options command).: END, SHIFT+ENTER

Select the current region around the active cell (the current region is a data area enclosed by blank rows and blank columns): CONTROL+SHIFT+* (asterisk)

Select the current array, which is the array that the active cell belongs to: CONTROL+/

Select all cells with comments: CONTROL+SHIFT+O (the letter O)

Select cells in a row that don't match the value in the active cell in that row. You must select the row starting with the active cell.: CONTROL+\

Select cells in a column that don't match the value in the active cell in that column. You must select the column starting with the active cell.: CONTROL+SHIFT+|

Select only cells that are directly referred to by formulas in the selection: CONTROL+[ (opening bracket)

Select all cells that are directly or indirectly referred to by formulas in the selection: CONTROL+SHIFT+{ (opening brace)

Select only cells with formulas that refer directly to the active cell: CONTROL+] (closing bracket)

Select all cells with formulas that refer directly or indirectly to the active cell: CONTROL+SHIFT+} (closing brace)

Select only visible cells in the current selection: ALT+; (semicolon)

Select the next sheet in the workbook, until the chart sheet you want is selected: CONTROL+PAGE DOWN

Select the previous sheet in the workbook, until the chart sheet you want is selected: CONTROL+PAGE UP

select the Drawing toolbar: CONTROL+TAB or CONTROL+SHIFT+TAB

select the Select Objects button on the Drawing toolbar: RIGHT ARROW

select the first object: CONTROL+ENTER

cycle forward through the objects: TAB

cycle backward through the objects: SHIFT+TAB

make the chart active: CONTROL+ENTER

Select the previous group of items: DOWN ARROW

Select the next group of items: UP ARROW

Select the next item within the group: RIGHT ARROW

Select the previous item within the group: LEFT ARROW

Select a field or a command button: ALT+key, where key is the underlined letter in the field or command name

Move to the same field in the next record: DOWN ARROW

Move to the same field in the previous record: UP ARROW

Move to the next field you can edit in the record: TAB

Move to the previous field you can edit in the record: SHIFT+TAB

Move to the first field in the next record: ENTER

Move to the first field in the previous record: SHIFT+ENTER

Move to the same field 10 records forward: PAGE DOWN

Move to a new record: CONTROL+PAGE DOWN

Move to the same field 10 records back: PAGE UP

Move to the first record: CONTROL+PAGE UP

Move to the beginning or end of a field: HOME or END

Extend a selection to the end of a field: SHIFT+END

Extend a selection to the beginning of a field: SHIFT+HOME

Move one character left or right within a field: LEFT ARROW or RIGHT ARROW

Select the character to the left: SHIFT+LEFT ARROW

Select the character to the right: SHIFT+RIGHT ARROW

Display the AutoFilter list for the current column: Arrow keys to select the cell that contains the column label, and then press ALT+DOWN ARROW

Select the next item in the AutoFilter list: DOWN ARROW

Select the previous item in the AutoFilter list: UP ARROW

Close the AutoFilter list for the current column: ALT+UP ARROW

Select the first item (All) in the AutoFilter list: HOME

Select the last item in the AutoFilter list: END

Filter the list by using the selected item in the AutoFilter list: ENTER

Group rows or columns: ALT+SHIFT+RIGHT ARROW

Ungroup rows or columns: ALT+SHIFT+LEFT ARROW

Display or hide outline symbols: CONTROL+8

Hide selected rows: CONTROL+9

Unhide selected rows: CONTROL+SHIFT+( (opening parenthesis)

Hide selected columns: CONTROL+0 (zero)

Unhide selected columns: CONTROL+SHIFT+) (closing parenthesis)

Select the previous or next field button in the list: UP ARROW or DOWN ARROW

Select the field button to the left or right in a multicolumn field button list: LEFT ARROW or RIGHT ARROW

Move the selected field into the Column area: ALT+C

Move the selected field into the Data area: ALT+D

Display the PivotTable Field dialog box: ALT+L

Move the selected field into the Page area: ALT+P

Move the selected field into the Row area: ALT+R

Select the entire PivotTable report: CONTROL+SHIFT+* (asterisk)

Display the list for the current field in a PivotTable report: Arrow keys to select the cell that contains the field, and then ALT+DOWN ARROW

Display the list for the current page field in a PivotChart report: Arrow keys to select the page field in a PivotChart report, and then ALT+DOWN ARROW

Select the previous item in the list: UP ARROW

Select the next item in the list: DOWN ARROW

Select the first visible item in the list: HOME

Select the last visible item in the list: END

Display the selected item: ENTER

Select or clear a check box in the list: SPACEBAR

1. Press F10 to make the menu bar active.
2. Press CONTROL+TAB or CONTROL+SHIFT+TAB to select the PivotTable toolbar.
3. Press the LEFT ARROW or RIGHT ARROW key to select the menu to the left or right or, when a submenu is visible, to switch between the main menu and submenu.
4. Press ENTER (on a field button) and the DOWN ARROW and UP ARROW keys to select the area you want to move the selected field to.

Group selected PivotTable items: ALT+SHIFT+RIGHT ARROW

Ungroup selected PivotTable items: ALT+SHIFT+LEFT ARROW

Use these keys to complete Step 2 in the OLAP Cube Wizard.

To move a field from the Source fields list to the Dimensions box:

1. Press the TAB key to select the Source fields list.
2. Press the UP ARROW or DOWN ARROW key to select the field you want to move.
3. Because you cannot change the order of a field after you move it, select first the field you want to appear at the top of the Dimensions box. Press the TAB key to select the > button, and then press ENTER.

To move other fields, repeat steps 1 through 3.

To move a field to a lower or higher level in the Dimensions box:

1. Press the TAB key to select the Dimensions box.
2. Press the UP ARROW or DOWN ARROW key to select the field you want to move.
3. Press CONTROL+X.
4. Press the UP ARROW or DOWN ARROW key to select where you want to move the field.
5. Press CONTROL+V.

Make the menu bar active, or close a visible menu and submenu at the same time: F10 or ALT

Select the next or previous button or menu on the toolbar: TAB or SHIFT+TAB (when a toolbar is active)

Select the next or previous toolbar: CONTROL+TAB or CONTROL+SHIFT+TAB (when a toolbar is active)

Open the selected menu, or perform the action assigned to the selected button: ENTER

Show a shortcut menu: SHIFT+F10

Show the program icon menu (on the program title bar): ALT+SPACEBAR

Select the next or previous command on the menu or submenu: DOWN ARROW or UP ARROW (with the menu or submenu displayed)

Select the menu to the left or right or, with a submenu visible, switch between the main menu and the submenu: LEFT ARROW or RIGHT ARROW

Select the first or last command on the menu or submenu: HOME or END

Close the visible menu or, with a submenu visible, close the submenu only: ESCAPE

Display the full set of commands on a menu: CONTROL+DOWN ARROW

Switch to the next program: ALT+TAB

Switch to the previous program: ALT+SHIFT+TAB

Show the Windows Start menu: CONTROL+ESCAPE

Close the active workbook window: CONTROL+W or CONTROL+F4

Restore the active workbook window size: CONTROL+F5

Move to the next pane in a workbook that has been split: F6

Move to the previous pane in a workbook that has been split: SHIFT+F6

Switch to the next workbook window: CONTROL+F6

Switch to the previous workbook window: CONTROL+SHIFT+F6

Carry out the Move command (workbook icon menu, menu bar), or use the arrow keys to move the window: CONTROL+F7

Carry out the Size command (workbook icon menu, menu bar), or use the arrow keys to size the window: CONTROL+F8

Minimize the workbook window to an icon: CONTROL+F9

Maximize or restore the workbook window: CONTROL+F10

Copy the image of the screen to the Clipboard: PRINT-SCREEN

Copy the image of the active window to the Clipboard: ALT+PRINT SCREEN

Move to the next option or option group: TAB

Move to the previous option or option group: SHIFT+TAB

Switch to the next tab in a dialog box: CONTROL+TAB or CONTROL+PAGE DOWN

Switch to the previous tab in a dialog box: CONTROL+SHIFT+TAB or CONTROL+PAGE UP

Move between options in the active drop-down list box or between some options in a group of options: Arrow keys

Perform the action assigned to the active button (the button with the dotted outline), or select or clear the active check box: SPACEBAR

Move to an option in a drop-down list box: Letter key for the first letter in the option name you want (when a drop-down list box is selected)

Select an option, or select or clear a check box: ALT+letter, where letter is the key for the underlined letter in the option name

Open the selected drop-down list box: ALT+DOWN ARROW

Perform the action assigned to the default command button in the dialog box (the button with the bold outline - often the OK button): ENTER

Cancel the command and close the dialog box: ESCAPE

Move to the beginning of the entry: HOME

Move to the end of the entry: END

Move one character to the left or right: LEFT ARROW or RIGHT ARROW

Move one word to the left: CONTROL+LEFT ARROW

Move one word to the right: CONTROL+RIGHT ARROW

Select or unselect one character to the left: SHIFT+LEFT ARROW

Select or unselect one character to the right: SHIFT+RIGHT ARROW

Select or unselect one word to the left: CONTROL+SHIFT+LEFT ARROW

Select or unselect one word to the right: CONTROL+SHIFT+RIGHT ARROW

Select from the insertion point to the beginning of the entry: SHIFT+HOME

Select from the insertion point to the end of the entry: SHIFT+END

Display the Open dialog box: CONTROL+F12 or CONTROL+O

Save the active workbook: ALT+F2 or F12 or CONTROL+S

Display the Save as dialog box: ALT+SHIFT+F2 or SHIFT+F12

Go to the previous folder: ALT+1

Open the folder up one level from the open folder (Up One Level button): ALT+2

Close the dialog box, and open your World Wide Web search page (Search the Web button): ALT+3

Delete the selected folder or file (Delete button): ALT+4

Create a new subfolder in the open folder (Create New Folder button): ALT+5

Switch between List, Details, Properties, and Preview views: ALT+6

Show the Tools menu (Tools button): ALT+7

Get Help. Displays the Assistant balloon if the Assistant is turned on.: F1

Select a Help topic from the list the Assistant displays: ALT+number (ALT+1 is the first topic, ALT+2 is the second, and so on)

See more Help topics: ALT+DOWN ARROW

See previous Help topics: ALT+UP ARROW

Close an Assistant message or a tip: ESCAPE

To use keys to send e-mail messages, you must configure Microsoft Outlook as your default e-mail program. If Outlook Express is your default e-mail program, you cannot use most of these keys to send e-mail messages.

Move to the e-mail message header: SHIFT+TAB
Cell A1 must be the active cell when you press these keys.

Send the active spreadsheet as an e-mail message: ALT+S

Open the Address Book: CONTROL+SHIFT+B

Check the names in the To, Cc, and Bcc boxes against the Address Book: ALT+K

Open the Address Book in the To box: ALT+PERIOD

Open the Address Book in the Cc box: ALT+C

Open the Address Book in the Bcc box: ALT+B

Go to the Subject box: ALT+J

Open the Outlook Message Options dialog box (View menu, Options command in a message): ALT+P

Create a message flag: CONTROL+SHIFT+G

1. Press ALT+U to select the AutoShapes menu on the Drawing toolbar.
2. Use the arrow keys to move to the category of AutoShapes you want, and then press the RIGHT ARROW key.
3. Use the ARROW keys to select the AutoShape you want.
4. Press CONTROL+ENTER
5. then use the keyboard to select AutoShape on the Format menu.
6. Select the options you want on the available tabs.

1. Use the keyboard to select the Text Box
2. Press CONTROL+ENTER.
3. Type the text you want in the text box.
4. When you finish typing and want to switch back to the worksheet, press ESCAPE twice.
5. select Text Box on the Format menu, and then select the options you want on the available tabs.

1. Use the keyboard to select WordArt (Insert menu, Picture submenu).
2. Use the arrow keys to select the WordArt style you want, and then press ENTER.
3. Type the text you want, and then use the TAB key to select other options in the dialog box.
4. Press ENTER to insert the WordArt object.
5. select WordArt on the Format menu, and then select the options you want on the available tabs.

If your insertion point is on the worksheet, do the following:

1. Press F10 to make the menu bar active.
2. Press CONTROL+TAB to select the Drawing toolbar.
3. Press the RIGHT ARROW key to select the Select Objects button on the Drawing toolbar.
4. Press CONTROL+ENTER to select the first drawing object.
5. Press the TAB key to cycle forward (or SHIFT+TAB to cycle backward) through the objects until sizing handles appear on the object you want to select.

If your insertion point is within text in a drawing object, do the following:

1. Press the TAB key to cycle forward (or SHIFT+TAB to cycle backward) through the objects until sizing handles appear on the object you want to select.

To switch from object selection mode back to working in cells, press ESCAPE.

1. Use the keyboard to select the drawing object you want to resize.
2. On the Format menu, select the command for the type of object selected - for example, AutoShape or Text Box - and then choose the Size tab.
3. Select the options you want.

For help on an option, select the option, and then press SHIFT+F1.

1. Use the keyboard to select the drawing object with the attributes you want to copy.
   (If you select an AutoShape with attached text, the look and style of the text as well as the attributes of the AutoShape are copied.)
2. Press CONTROL+SHIFT+C to copy the object attributes.
3. Press TAB or SHIFT+TAB to select the object you want to copy the attributes to.
4. Press CONTROL+SHIFT+V to copy the attributes to the object.

Tip You can select any menu command on the menu bar or on a visible toolbar with the keyboard.

1. To select the menu bar, press ALT.
2. Then to select a toolbar, press CONTROL+TAB repeatedly until you select the toolbar you want.
3. Press the underlined letter in the menu name that contains the command you want.
4. In the menu that appears, press the underlined letter in the command name that you want.

Comments

Previous Section

Level Up

Next Section