Press	To
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	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 or Control + G
Display the Find dialog box	Shift + F5 or Control + F
Repeat the last Find action (same as Find Next)	Shift + F4 or Enter
Move between unlocked cells on a protected worksheet	Tab

Keys for moving in a worksheet with End mode on

Hold down the end key to enter “end mode.”	End
END, Arrow key	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

Keys for moving in a worksheet with scroll lock on

Press	To
Turn your 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 or Down Arrow
Scroll one column left or right	Left 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.

Keys for previewing and printing a document

Display the Print dialog box

Control + P or

Control + Shift + F12

Work in print preview

Press	To
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

Keys for working with worksheets, charts, and macros

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

Keys for entering data

Keys for entering data on a worksheet

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

Keys for working in cells or the formula bar

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 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	CTRL+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) (next to the one key)
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

Keys for formatting data

Display the Style dialog box	Alt + ‘ (apostrophe)
Display the Format Cells dialog box	Control + 1
Apply the General number format	Control + Shift + ~ (Tilde) (shift + key next to the one key)
Apply the Currency format with two decimal places (negative numbers appear in parentheses)	Control + shift + $ (dollar sign) (Shift + 4)
Apply the Percentage format with no decimal places	Control + Shift + % (percent sign) (shift + 5)
Apply the Exponential number format with two decimal places	Control + Shift + ^ (carat) (shift + 6)
Apply the Date format with the day, month, and year	Control + Shift + # (number sign) (shift + 3)
Apply the Time format with the hour and minute, and indicate A.M. or P.M.	Control + Shift + @ (at sign) (shift + 2)
Apply the Number format with two decimal places, thousands separator, and minus sign (–) for negative values	Control + shift + ! (exclamation mark) (shift + 1)
Apply the outline border	Control + Shift + & (ampersand) (shift + 7)
Remove outline borders	Control + shift + _ (underscore)
Toggle Bold Attribute	Control + B
Toggle Italic Attribute	Control + I
Toggle Underline Attribute	Control + U
Toggle Strikethrough Attribute	Control + 5
Hide rows	Control + 9
Unhide rows	Control + Shift + ( (left parenthesis) (Shift + 9)
Hide columns	Control + 0 (zero)
Unhide columns	Control + shift + ) (right Parenthesis) (shift + 0)

Keys for editing data

Edit the active cell and put the insertion point at the end of the line	F2
Cancel an entry in a cell or the 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
Launch Spell Check	F7

Keys for inserting, deleting, and copying a selection

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

Keys for moving within a selection

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

Keys for selecting cells, columns, or rows

Select the current region around the active cell (the current region is a data area enclosed by blank rows and blank columns)	Control + Shift + * (star) (shift + 8)
Select an additional cell.	Shift + Arrow Key
Select from the current cursor location to the last nonblank cell in the same column or row as the active cell	Control + Shift + Arrow Keys
Select from the cursor location to the beginning of the row.	Shift + Home
Select from the current cursor location to the beginning of the worksheet	Control + Shift + Home
Select from the cursor location 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 + F6
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
Select from current cursor location to the cell in the upper-left corner of the window	Scroll lock, Shift + Home
Select from the current cursor location 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.

Keys for extending the selection with End mode on

Turn End Mode on or off	End
Select from the current cursor location to the last nonblank cell in the same column or row as the active cell	End, Shift + Arrow keys
Select from the current cursor location 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

Keys for selecting cells that have special characteristics

Select the current region around the active cell (the current region is a data area enclosed by blank rows and blank columns)	Control + Shift + * (star) (shift + 8)
Select the current array, which is the array that the active cell belongs to	Control + backslash
Select all cells with comments	Control + Shift + 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 + backslash
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 + \| (vertical bar) (shift + backslash)
Select only cells that are directly referred to by formulas in the selection	Control + [ (left bracket)
Select all cells that are directly or indirectly referred to by formulas in the selection	Control + Shift + { (left brace)
Select only cells with formulas that refer directly to the active cell	Control + ] (right bracket)
Select all cells with formulas that refer directly or indirectly to the active cell	Control + Shift + } (Right brace)
Select only visible cells in the current selection	Alt + ; (semicolon)

Keys for selecting a chart sheet

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

Keys for selecting an embedded chart

Note The Drawing toolbar must already be displayed. if you display more than the formatting and standard toolbars, this may render your screen reader specific hotkeys invalid

Press F10 to make the menu bar active.
Press CTRL+TAB or CTRL+SHIFT+TAB to select the Drawing toolbar.
Press the RIGHT ARROW key to select the Select Objects button on the Drawing toolbar.
Press CTRL+ENTER to select the first object.
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.
Press CTRL+ENTER to make the chart active.

Keys for selecting chart items

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

Keys for working with a data form

Select a field or a command button	Alt + the Underlined key of a menu or menu item. (In window eyes, you will hear “f equals file” etc…. this is the key which will be pressed in conjunction with the alt key. In Jaws, press the 5 key on your numeric keypad to hear the appropriate key spoken and then press that key in conjunction with the alt key.)
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
Select from the current cursor location to the beginning of the 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

Keys for using AutoFilter

Display the AutoFilter list for the current column	Arrow keys to select the cell that contains the column lable 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

Keys for outlining data

Group rows or columns	Alt + Shift + Right Arrow
Ungroup rows or columns	Alt + Shift + Right Arrow
Display or hide outline symbols	Control + 8
Hide selected rows	Control + 9
Unhide selected rows	Control + ( (Left Parenthesis)
Hide selected columns	Control + 0
Unhide selected columns	Control + Shift + ) (Right Parenthesis)

Keys for the PivotTable and PivotChart Wizard

Select the previous or next field button in the list	Up or Down Arrow
Select the field button to the left or right in a multicolumn field button list	Left 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

Keys for page fields in a PivotTable or PivotChart report

Select the entire PivotTable report	Control + Shift + * (star) (shift + 8)
Display the list for the current field in the 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

Keys for laying out a PivotTable or PivotChart report

Press F10 to make the menu bar active.
Press CTRL+TAB or CTRL+SHIFT+TAB to select the PivotTable toolbar.
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.
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.

Note To scroll to the top or bottom of the field list, press ENTER on the More Fields button.

Keys for grouping and ungrouping PivotTable items

Group selected PivotTable items	Alt + Shift + Down Arrow
Ungroup selected PivotTable items	Alt + Shift + Left Arrow

Keys to use with the OLAP Cube Wizard

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

Press the TAB key to select the Source fields list.
Press the UP ARROW or DOWN ARROW key to select the field you want to move.

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

Press the TAB key to select the Dimensions box.
Press the UP ARROW or DOWN ARROW key to select the field you want to move.
Press CTRL+X.
Press the UP ARROW or DOWN ARROW key to select where you want to move the field.
Press CTRL+V.

Keys for menus and toolbars

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 or up Arrow (with the menu or submenu open)
Select the menu to the left or right or, with a submenu visible, switch between the main menu and the submenu	Left or Right Arrow
Select the first or last command on the menu or submenu	Home or End
Close the currently open menu, submenu or menu bar.	Escape
Display the full set of commands on a menu	Control + Down Arrow

Keys for windows

Cycle among currently open programs	Alt + Tab
Cycle backward among currently open programs.	Alt + Shift + Tab
Open the Windows Start Menu	Control + Escape or Windows key
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

Keys for dialog boxes

Move to the next option or option group	Tab
Move to the previous option or option group	Shift + Tab
Switch to the next property sheet in a dialog box	Control + Tab or Control + Page Down
Switch to the previous property sheet 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 of the item or option or the up and down Arrow keys.
Select an option, or select or clear a check box	Alt plus the hot key letter.
Open the selected drop-down list box	Alt + Down Arrow
Perform the action assigned to the default button.	Enter
Cancel the command and close the dialog box	Escape

Keys for edit boxes in dialog boxes

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

Keys for working with the Open and Save As dialog boxes

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)	Alt + 2
Close the dialog box, and open your World Wide Web "blue" Button.	Alt + 3
Delete the selected folder or file	Alt + 4
Create a new subfolder in the open folder	Alt + 5
Switch between List, Details, Properties, and Preview views	Alt + 6
Show the Tools menu (Tools button)	Alt + 7

Keys for using the Office Assistant

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	Esc

Keys for sending e-mail messages

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. Cell A1 must be the active cell when you press these keys.	Shift + Tab
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	Alt + P
Create a message flag	Control + Shift + G

Insert an AutoShape by using the keyboard

Press ALT+U to select the AutoShapes menu on the Drawing toolbar.
Use the Arrow keys to move to the category of AutoShapes you want, and then press the RIGHT ARROW key.
Use the Arrow keys to select the AutoShape you want.
Press CTRL+ENTER.

Insert a text box by using the keyboard

Use your mouse emulation keys to select the Text Box button on the Drawing toolbar.
Press CTRL+ENTER.
Type the text you want in the text box.
When you finish typing and want to switch back to the worksheet, press ESC twice.

Note To format the text box (add a fill color or change the size, for example) select the text box, select Text Box on the Format menu, and then select the options you want on the available tabs.

Insert a WordArt object by using the keyboard

From within the insert menu, press enter on the “picture” submenu and then select “wordart.”
Use the Arrow keys to select the WordArt style you want, and then press ENTER.
Type the text you want, and then use the TAB key to select other options in the dialog box.
Press ENTER to insert the WordArt object.

Select a drawing object by using the keyboard

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

Press F10 to make the menu bar active.
Press CTRL+TAB to select the Drawing toolbar.

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

Press CTRL+ENTER to select the first drawing object.
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:

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.

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

Rotate a drawing object by using the keyboard

Select the drawing object you want to rotate.
On ôhe Format menu, select the command for the type of object selected — for example, AutoShape or Text Box — and then select the Size tab.
In the Rotation box, enter the amount of rotation you want.

Change the size of a drawing object by using the keyboard

Select the drawing object you want to resize.
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.

Select the options you want. For help on an option, select the option, and then press SHIFT+F1.

Copy the attributes of a drawing object by using the keyboard

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.

Press CTRL+SHIFT+C to copy the object attributes.
Press TAB or SHIFT+TAB to select the object you want to copy the attributes to.
Press CTRL+SHIFT+V to copy the attributes to the object.

Return to the List of Reference Cards

Return to the ATI Home Page