excelshortcutkeys

Use FIND to locate a shortcut

Windows Shortcuts Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P. Use of ALT+SPACEBAR is also good to move a window when the titlebar gets stuck under the top of the screen. More on handling Windows Window and an Excel Window.

Move one cell up, down, left, or right

Move to the edge of the current data region

Mouse alternative: double-click on cell border in direction wanted.

Move to the beginning of the row

Move to the beginning of the worksheet

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

Move down one screen

Move up one screen

Move one screen to the right

Move one screen to the left

Move to the next sheet in the workbook

Move to the previous sheet in the workbook

Move to the next workbook or window

Move to the previous workbook or window

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

Move to the previous pane in a workbook that has been split

Scroll to display the active cell

Display the Go To dialog box

Display the Find dialog box

Repeat the last Find action (same as Find Next)

Move between unlocked cells on a protected worksheet

Keys for moving in a worksheet with End mode on

Turn End mode on or off

Move by one block of data within a row or column

(a shortcut for this shortcut is to double-click on a cell border)

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

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)

Turn SCROLL LOCK on or off

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

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

Scroll one row up or down

Scroll one column left or right

Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P.

This topic lists:

Keys for entering data on a worksheet

Keys for working in cells or the formula bar

Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P.

This topic lists:

Keys for editing data

Keys for inserting, deleting, and copying a selection

Keys for moving within a selection

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

Cancel an entry in the cell or formula bar

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

Paste a defined name into a formula

Complete a cell entry

Enter a formula as an array formula

Display the Formula Palette after you type a function name in a formula

Insert the argument names and parentheses for a function, after you type a function name in a formula

Display the Spelling dialog box

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)

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)

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

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

Move clockwise to the next corner of the selection

Move to the right between nonadjacent selections

Move to the left between nonadjacent selections

Select the current region around the active cell (the current region is a data area enclosed by blank rows and blank columns)

Extend the selection by one cell

Extend the selection to the last nonblank cell in the same column or row as the active cell

Extend the selection to the beginning of the row

Extend the selection to the beginning of the worksheet

Extend the selection to the last used cell on the worksheet (lower-right corner)

Select the entire column (remains valid in Excel 2003)

Select the entire row (remains valid in Excel 2003)

Select the entire worksheet

(the grey button to the left of column headings (A-B-C), and above the

row headings (1-2-3) is similar but does change the active cell)

Select only the active cell when multiple cells are selected

Extend the selection down one screen

Extend the selection up one screen

With an object selected, select all objects on a sheet (Excel 2003 behavior is broken by design just like Excel 2003 Alt+A)

Alternate between hiding objects, displaying objects, and displaying placeholders for objects

Show or hide the Standard toolbar

Turn on extending a selection by using the arrow keys

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

Extend the selection to the cell in the upper-left corner of the window

Extend the selection to the cell in the lower-right corner of the window

Turn End mode on or off

Extend the selection to the last nonblank cell in the same column or row as the active cell

Extend the selection to the last cell used on the worksheet (lower-right corner)

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).

Select the next sheet in the workbook, until the chart sheet you want is selected

Select the previous sheet in the workbook, until the chart sheet you want is selected

Note The Drawing toolbar must already be displayed.

1. Press F10 to make the menu bar active.

2. Press CTRL+TAB or CTRL+SHIFT+TAB to select the Drawing toolbar.

3. Press the RIGHT ARROW key to select the Select Objects button on the Drawing toolbar.

4. Press CTRL+ENTER to select the first object.

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

6. Press CTRL+ENTER to make the chart active.

Select the previous group of items

Select the next group of items

Select the next item within the group

Select the previous item within the group

There are also keys to use with PivotChart reports.

Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P.

Select a field or a command button

Move to the same field in the next record

Move to the same field in the previous record

Move to the next field you can edit in the record

Move to the previous field you can edit in the record

Move to the first field in the next record

Move to the first field in the previous record

Move to the same field 10 records forward

Move to a new record

Move to the same field 10 records back

Move to the first record

Move to the beginning or end of a field

Extend a selection to the end of a field

Extend a selection to the beginning of a field

Move one character left or right within a field

Select the character to the left

Select the character to the right

Display the AutoFilter list for the current column

Select the next item in the AutoFilter list

Select the previous item in the AutoFilter list

Close the AutoFilter list for the current column

Select the first item (All) in the AutoFilter list

Select the last item in the AutoFilter list

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

Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P.

Group rows or columns

Ungroup rows or columns

Display or hide outline symbols

Hide selected rows

Unhide selected rows

Hide selected columns

Unhide selected columns

Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P.

Select the previous or next field button in the list

Select the field button to the left or right in a multicolumn field button list

Move the selected field into the Column area

Move the selected field into the Data area

Display the PivotTable Field dialog box

Move the selected field into the Page area

Move the selected field into the Row area

Select the entire PivotTable report

Display the list for the current field in a PivotTable report

Display the list for the current page field in a PivotChart report

Select the previous item in the list

Select the next item in the list

Select the first visible item in the list

Select the last visible item in the list

Display the selected item

Select or clear a check box in the list

1. Press F10 to make the menu bar active.

2. Press CTRL+TAB or CTRL+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

Ungroup selected PivotTable items

Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P.

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

Select the next or previous button or menu on the toolbar

Select the next or previous toolbar

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

Show a shortcut menu

Show the program icon menu (on the program title bar)

Select the next or previous command on the menu or submenu

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

Select the first or last command on the menu or submenu

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

Display the full set of commands on a menu

Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P.

Switch to the next program

Switch to the previous program

Show the Windows Start menu

Close the active workbook window

Restore the active workbook window size

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

Move to the previous pane in a workbook that has been split

Switch to the next workbook window

Switch to the previous workbook window

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

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

Minimize the workbook window to an icon

Maximize or restore the workbook window

Copy the image of the screen to the Clipboard

Copy the image of the active window to the Clipboard

Keys for dialog boxes

Move to the next option or option group

Move to the previous option or option group

Switch to the next tab in a dialog box

Switch to the previous tab in a dialog box

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

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

Move to an option in a drop-down list box

Select an option, or select or clear a check box

Open the selected drop-down list box

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

Cancel the command and close the dialog box

Keys for edit boxes in dialog boxes

Move to the beginning of the entry

Move to the end of the entry

Move one character to the left or right

Move one word to the left

Move one word to the right

Select or unselect one character to the left

Select or unselect one character to the right

Select or unselect one word to the left

Select or unselect one word to the right

Select from the insertion point to the beginning of the entry

Select from the insertion point to the end of the entry

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

Select a Help topic from the list the Assistant displays

See more Help topics

See previous Help topics

Close an Assistant message or a tip

Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P.

Display the Open dialog box

Save the active workbook

Display the Save as dialog box

Go to the previous folder ()

Open the folder up one level from the open folder (Up One Level button )

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

Delete the selected folder or file (Delete button )

Create a new subfolder in the open folder (Create New Folder button )

Switch between List, Details, Properties, and Preview views

Show the Tools menu (Tools button)

Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P.

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

Send the active spreadsheet as an e-mail message

Open the Address Book

Check the names in the To, Cc, and Bcc boxes against the Address Book

Open the Address Book in the To box

Open the Address Book in the Cc box

Open the Address Book in the Bcc box

Go to the Subject box

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

Create a message flag

Insert an AutoShape

Insert a text box

Insert a WordArt object

Selecting drawing objects

Select a drawing object

Editing drawing objects

Rotate a drawing object

Change the size of a drawing object

Copy the attributes of a drawing object

2. to copy the object attributes.

3. to select the object you want to copy the attributes to.

4. to copy the attributes to the object.

reveal the smart tag menu