We no longer sell or support these products
if you want unprecedented performance, reliability and stability
we suggest you consider Window-Eyes or ZoomText.

Henter-Joyce Training Banner

Back to Training Tools

Excel 7 Standard Shortcut Keys

Choose one of the following 19 links for more information, or just scroll down the page. There is a "Top of List" link at the bottom of the page.

1. Enter and Format Data

1.1. Enter Data

To complete a cell entry use ENTER

To cancel a cell entry use ESC

To repeat the last action use F4

To start a new line in the same cell use ALT+ENTER

To insert a tab character in a cell use CTRL+ALT+TAB

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

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

To delete text to the end of the line use CTRL+DELETE

To move one character up, down, left, or right use Arrow keys

To move to the beginning of the line use HOME

To edit a cell note use SHIFT+F2

To create names from cell text use CTRL+SHIFT+F3

To fill down use CTRL+D

To fill to the right use CTRL+R

To fill the selected cell range with the current entry use CTRL+ENTER

To complete a cell entry and move down in the selection use ENTER

To complete a cell entry and move up in the selection use SHIFT+ENTER

To complete a cell entry and move to the right in the selection use TAB

To complete a cell entry and move to the left in the selection use SHIFT+TAB

1.2. Work in Cells or the Formula Bar

To start a formula use EQUAL SIGN

To activate a cell and the formula bar use F2

To activate and clear the formula bar when a cell is selected, or delete the preceding character in the formula bar use BACKSPACE

To paste a name into a formula use F3

To define a name use CTRL+F3

To calculate all sheets in all open workbooks use F9 or CTRL+EQUAL SIGN

To calculate the active sheet use SHIFT+F9

To insert the AutoSum formula use ALT+EQUAL SIGN

To enter the date use CTRL+SEMICOLON

To enter the time use CTRL+SHIFT+COLON

To cancel an entry in the cell or formula bar use ESC

To complete a cell entry use ENTER

To insert a line break use ALT+ENTER

To insert a tab character use CTRL+ALT+TAB

To copy the value from the cell above the active cell into the cell or the formula bar CTRL+SHIFT+"

To alternate between displaying cell values and displaying cell formulas use CTRL+`(single left quotation mark)

To copy a formula from the cell above the active cell into the cell or the formula bar use CTRL+' (apostrophe)

To enter a formula as an array formula use CTRL+SHIFT+ENTER

To display step 2 of the Function Wizard, after you type a valid function name in a formula use CTRL+A

To insert the argument names and parentheses for a function, after you type a valid function name in a formula use CTRL+SHIFT+A

To activate the AutoComplete list use ALT+DOWN ARROW

1.3. Format Data

To carry out the Style command (Format menu) use ALT+' (apostrophe)

To carry out the Cells command (Format menu) use CTRL+1

To apply the General number format use CTRL+SHIFT+~

To apply the Currency format with two decimal places (negative numbers appear in parentheses) use CTRL+SHIFT+$

To apply the Percentage format with no decimal places use CTRL+SHIFT+%

To apply the Exponential number format with two decimal places use CTRL+SHIFT+^

To apply the Date format with the day, month, and year use CTRL+SHIFT+#

To apply the Time format with the hour and minute, and indicate A.M. or P.M. use CTRL+SHIFT+@

To apply the two-decimal-place format with commas use CTRL+SHIFT+!

To apply the outline border use CTRL+SHIFT+&

To remove all borders use CTRL+SHIFT+_

To apply or remove bold formatting use CTRL+B

To apply or remove italic formatting use CTRL+I

To apply or remove an underline use CTRL+U

A To apply pply or remove strikethrough formatting use CTRL+5

To Hide rows use CTRL+9

To unhide rows use CTRL+SHIFT+(

To Hide columns use CTRL+0 (zero)

To unhide columns use CTRL+SHIFT+)

2. Edit and Move Data

2.1 Select in Worksheets and Workbooks

To extend the selection by one cell use SHIFT+ arrow key

To extend the selection to the edge of the current data region use CTRL+SHIFT+ arrow key

To extend the selection to the beginning of the row use SHIFT+HOME

To extend the selection to the beginning of the worksheet use CTRL+SHIFT+HOME

To extend the selection to the last cell in the worksheet (lower-right corner) use CTRL+SHIFT+END

To select the entire column use CTRL+SPACEBAR

To select the entire row use SHIFT+SPACEBAR

To select the entire worksheet use CTRL+A

To collapse the selection to the active cell use SHIFT+BACKSPACE

To extend the selection down one screen use SHIFT+PAGE DOWN

To extend the selection up one screen use SHIFT+PAGE UP

To select the current region use CTRL+SHIFT+*

With an object selected, to select all objects on a sheet use CTRL+SHIFT+SPACEBAR

To alternate between hiding objects, displaying objects, and displaying placeholders for objects use CTRL+6

To show or hide the Standard toolbar use CTRL+7

2.1.1. In End mode

To turn End mode on or off use END

To extend the selection to the end of the data block in the direction of the arrow use END, SHIFT+ arrow key

To extend the selection to the last cell in the worksheet (lower-right corner) use END, SHIFT+HOME

To extend the selection to the last cell in the current row (unavailable if you've selected the Transition Navigation Keys check box) use END, SHIFT+ENTER

2.1.2. With scroll lock turned on

To scroll the screen up or down one row use UP ARROW or DOWN ARROW

To scroll the screen left or right one column use LEFT ARROW or RIGHT ARROW

To extend the selection to the cell in the upper-left corner of the window use SHIFT+HOME

To extend the selection to the cell in the lower-right corner of the window use SHIFT+END

To turn Scroll Lock on or off use SCROLL LOCK

Note 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 Scroll Lock on first.

2.2. Select Cells with Special Characteristics

To select all cells that contain a note use CTRL+SHIFT+?

To select a range around the active cell (the selected range is an area enclosed by blank rows and blank columns) use CTRL+SHIFT+*

To select the entire array that the active cell belongs to use CTRL+/

To select cells whose contents are different from the comparison cell in each row (for each row, the comparison cell is in the same column as the active cell) use CTRL+\

To select cells whose contents are different from the comparison cell in each column (for each column, the comparison cell is in the same row as the active cell) use CTRL+SHIFT+|

To select only cells that are directly referred to by formulas in the selection use CTRL+[

To select all cells that are directly or indirectly referred to by formulas in the selection use CTRL+SHIFT+{

To select only cells with formulas that refer directly to the active cell use CTRL+]

To select all cells with formulas that refer directly or indirectly to the active cell use CTRL+SHIFT+}

To select only visible cells in the current selection use ALT+SEMICOLON

2.3. Select Chart Items

Some items, such as data series and data labels, are grouped together. First select the entire group, and then select an individual item within the group.

To select the previous group of items use DOWN ARROW

To select the next group of items use UP ARROW

To select the next item within the group use RIGHT ARROW

To select the previous item within the group use LEFT ARROW

2.4. Move Within a Selection

To move from top to bottom within the selection, or move to the right one cell if only one row is selected use ENTER

To move from bottom to top within the selection, or move to the left one cell if only one row is selected use SHIFT+ENTER

To move from left to right within the selection use TAB

To move from right to left within the selection use SHIFT+TAB

To move clockwise to the next corner of the selection use CTRL+PERIOD

To move to the right between nonadjacent selections use CTRL+ALT+RIGHT ARROW

To move to the left between nonadjacent selections use CTRL+ALT+LEFT ARROW

2.5. Insert, Delete, and Copy a Selection

To copy the selection use CTRL+C

To paste the selection use CTRL+V

To cut the selection use CTRL+X

To clear the selection of formulas and data use DELETE

To insert blank cells use CTRL+SHIFT+PLUS SIGN

To delete the selection use CTRL+MINUS SIGN

To undo the last action use CTRL+Z

2.6. Move in Worksheets and Workbooks

To move one cell in a given direction use Arrow key

To move to the edge of the current data region use CTRL+ arrow key

To move between unlocked cells in a protected worksheet use TAB

To move to the beginning of the row use HOME

To move to the beginning of the worksheet use CTRL+HOME

To move to the last cell in the worksheet (in the lower-right corner) use CTRL+END

To move one screen down use PAGE DOWN

To move one screen up use PAGE UP

To move one screen to the right use ALT+PAGE DOWN

To move one screen to the left use ALT+PAGE UP

To move to the next sheet in the workbook use CTRL+PAGE DOWN

To move to the previous sheet in the workbook use CTRL+PAGE UP

To move to the next workbook use CTRL+F6

To move to the previous workbook use CTRL+SHIFT+F6

To move to the next pane use F6

To move to the previous pane use SHIFT+F6

2.6.1. In End mode

To turn End mode on or off use END

To move by one block of data within a row or column use END, arrow key

To move to the last cell in the worksheet (in the lower-right corner) use END, HOME

To move to the last cell in the current row (unavailable if you've selected the Transition Navigation Keys check box) use END, ENTER

2.6.2. With Scroll Lock turned on

To move to the cell in the upper-left corner of the window use HOME

To move to the cell in the lower-right corner of the window use END

To turn Scroll Lock on or off use SCROLL LOCK

2.7. Scroll in a Workbook Window

To move one screen up or down use PAGE UP or PAGE DOWN

To move one screen to the right use ALT+PAGE DOWN

To move one screen to the left use ALT+PAGE UP

To move to the previous sheet in the workbook use CTRL+PAGE UP

To move to the next sheet in the workbook use CTRL+PAGE DOWN

To display the next window use CTRL+F6 or CTRL+TAB

To display the previous window use CTRL+SHIFT+F6 or CTRL+SHIFT+TAB

To scroll to display the active cell use CTRL+BACKSPACE

To turn scroll lock on or off use SCROLL LOCK

To scroll one row up or down use UP ARROW or DOWN ARROW (with Scroll Lock turned on)

To scroll one column left or right use LEFT ARROW or RIGHT ARROW (with Scroll Lock turned on)

3. Outline Data

To ungroup rows or columns use ALT+SHIFT+LEFT ARROW

To group rows or columns use ALT+SHIFT+RIGHT ARROW

To display or hide outline symbols use CTRL+8

To hide selected rows use CTRL+9

To unhide selected rows use CTRL+SHIFT+(

To hide selected columns use CTRL+0 (zero)

To unhide selected columns use CTRL+SHIFT+)

4. Print a Document

To print entire sheet use CTRL+P

To print portions of a sheet, or multiple copies, use ALT+F, P and make selections in dialog box

5. Work with Databases, Lists, and PivotTables

5.1. Work in a Data Form

To select a field or a command button use ALT+ key for letter underlined in name

To move to the same field in the next record use DOWN ARROW

To move to the same field in the previous record use UP ARROW

To move to the next field you can edit in the record use TAB

To move to the previous field you can edit in the record use SHIFT+TAB

To move to the first field in the next record use ENTER

To move to the first field in the previous record use SHIFT+ENTER

To move to the same field 10 records forward use PAGE DOWN

To move to the same field 10 records back use PAGE UP

To move to the new record use CTRL+PAGE DOWN

To move to the first record use CTRL+PAGE UP

To move to the beginning or end of a field use HOME or END

To move one character left or right within a field use LEFT ARROW or RIGHT ARROW

To extend a selection to the beginning of a field use SHIFT+HOME

To extend a selection to the end of a field use SHIFT+END

To select the character to the left use SHIFT+LEFT ARROW

To select the character to the right use SHIFT+RIGHT ARROW

5.2. Work with AutoFilter

To display the list for the selected column label use ALT+DOWN ARROW

To close the list for the selected column label use ALT+UP ARROW

To select the previous item in the list use UP ARROW

To select the next item in the list use DOWN ARROW

To select the first item in the list (All) use HOME

To select the last item in the list (NonBlanks) use END

To filter the list using the selected item use ENTER

5.3. Work with the PivotTable Wizard

5.3.1. In Step 3 of the PivotTable Wizard

To select the next or previous field button in the list use UP ARROW or DOWN ARROW

To select the field button to the right or left in a multicolumn field button list use LEFT ARROW or RIGHT ARROW

To move the selected field into the Page area use ALT+P

To move the selected field into the Row area use ALT+R

To move the selected field into the Column area use ALT+C

To move the selected field into the Data area use ALT+D

To display the PivotTable Field dialog box use ALT+L

5.3.2. Work with page fields in a PivotTable using shortcut keys

To display the page field list use ALT+DOWN ARROW

To close the page field list use ALT+UP ARROW

To select the previous item in the list use UP ARROW

To select the next item in the list use DOWN ARROW

To select the first visible item in the list use HOME

To select the last visible item in the list use END

To display the selected item use ENTER

5.3.3. Group and ungroup PivotTable items using shortcut keys

To group selected PivotTable items use ALT+SHIFT+RIGHT ARROW

To ungroup selected PivotTable items use ALT+SHIFT+LEFT ARROW

6. JAWS Shortcut Keys

To hear the coordinates of current cell, use Insert + C

If you hear equals when you move to a cell, there is a formula there

To review the formula, use Insert+F2

To review selected cells, use Insert + Shift + Down arrow

To hear the contents of the top 4 cells in the column use the Alt key with 1 through 4 on the number row

To hear the contents of the 4 cells from the left margin use the Alt key with 5 through 8 on the number row

Top of List

Henter-Joyce Main Info Page