Microsoft Excel 97 Keyboard Shortcuts

SHORTCUT	ACTION
Enter data
ENTER	Complete a cell entry
ESC	Cancel a cell entry
F4 or CTRL+Y	Repeat the last action
ALT+ENTER	Start a new line in the same cell
BACKSPACE	Delete the character to the left of the insertion point, or delete the selection
DELETE	Delete the character to the right of the insertion point, or delete the selection
CTRL+DELETE	Delete text to the end of the line
Arrow keys	Move one character up, down, left, or right
HOME	Move to the beginning of the line
SHFT+F2	Edit a cell comment
CTRL+SHFT+F3	Create names from row and column labels
CTRL+D	Fill down
CTRL+R	Fill to the right
CTRL+ENTER	Fill the selected cell range with the current entry
ENTER	Complete a cell entry and move down in the selection
SHFT+ENTER	Complete a cell entry and move up in the selection
TAB	Complete a cell entry and move to the right in the selection
SHFT+TAB	Complete a cell entry and move to the left in the selection
Work in cells or the formula bar
= (EQUAL SIGN)	Start a formula
ESC	Cancel an entry in the cell or formula bar
F2	Edit the active cell
BACKSPACE	Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents
F3	Paste a name into a formula
CTRL+F3	Define a name
F9	Calculate all sheets in all open workbooks
SHFT+F9	Calculate the active worksheet
ALT+= (EQUAL SIGN)	Insert the AutoSum formula
CTRL+; (SEMICOLON)	Enter the date
CTRL+SHFT+: (COLON)	Enter the time
CTRL+K	Insert a hyperlink
ENTER	Complete a cell entry
CTRL+SHFT+ (QUOTATION MARK)	Copy the value from the cell above the active cell into the cell or the formula bar
CTRL+` (SINGLE LEFT QUOTATION MARK)	Alternate between displaying cell values and displaying cell formulas
CTRL+' (APOSTROPHE)	Copy a formula from the cell above the active cell into the cell or the formula bar
CTRL+SHFT+ENTER	Enter a formula as an array formula
CTRL+A	Display the Formula Palette after you type a valid function name in a formula
CTRL+SHFT+A	Insert the argument names and parentheses for a function, after you type a valid function name in a formula
ALT+DOWN ARROW	Display the AutoComplete list
Format data
ALT+' (APOSTROPHE)	Display the Style command (Format menu)
CTRL+1	Display the Cells command (Format menu)
CTRL+SHFT+~	Apply the General number format
CTRL+SHFT+$	Apply the Currency format with two decimal places (negative numbers appear in parentheses)
CTRL+SHFT+%	Apply the Percentage format with no decimal places
CTRL+SHFT+^	Apply the Exponential number format with two decimal places
CTRL+SHFT+#	Apply the Date format with the day, month, and year
CTRL+SHFT+@	Apply the Time format with the hour and minute, and indicate A.M. or P.M.
CTRL+SHFT+!	Apply the Number format with two decimal places, 1000 separator, and - for negative values
CTRL+SHFT+&	Apply the outline border
CTRL+SHFT+	Remove all borders
CTRL+B	Apply or remove bold formatting
CTRL+I	Apply or remove italic formatting
CTRL+U	Apply or remove an underline
CTRL+5	Apply or remove strikethrough formatting
CTRL+9	Hide rows
CTRL+SHFT+(	Unhide rows
CTRL+0 (ZERO)	Hide columns
CTRL+SHFT+)	Unhide columns
Edit data
F2	Edit the active cell
ESC	Cancel an entry in the cell or formula bar
BACKSPACE	Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents
F3	Paste a name into a formula
ENTER	Complete a cell entry
CTRL+SHFT+ENTER	Enter a formula as an array formula
CTRL+A	Display the Formula Palette after you type a valid function name in a formula
CTRL+SHFT+A	Insert the argument names and parentheses for a function, after you type a valid function name in a formula
Insert, delete, and copy a selection
CTRL+C	Copy the selection
CTRL+V	Paste the selection
CTRL+X	Cut the selection
DELETE	Clear the contents of the selection
CTRL+SHFT+PLUS SIGN	Insert blank cells
CTRL+ -	Delete the selection
CTRL+Z	Undo the last action
Move within a selection
ENTER	Move from top to bottom within the selection (down), or in the direction that is selected on the Edit tab (Tools menu, Options command)
SHFT+ENTER	Move from bottom to top within the selection (up), or opposite to the direction that is selected on the Edit tab (Tools menu, Options command)
TAB	Move from left to right within the selection, or move down one cell if only one column is selected
SHFT+TAB	Move from right to left within the selection, or move up one cell if only one column is selected
CTRL+PERIOD	Move clockwise to the next corner of the selection
CTRL+ALT+RIGHT ARROW	Move to the right between nonadjacent selections
CTRL+ALT+LEFT ARROW	Move to the left between nonadjacent selections
Select cells, columns, rows, or objects in worksheets and workbooks
CTRL+SHFT+* (ASTERISK)	Select the current region around the active cell (the current region is an area enclosed by blank rows and blank columns)
SHFT+ arrow key	Extend the selection by one cell
CTRL+SHFT+ arrow key	Extend the selection to the last nonblank cell in the same column or row as the active cell
SHFT+HOME	Extend the selection to the beginning of the row
CTRL+SHFT+HOME	Extend the selection to the beginning of the worksheet
CTRL+SHFT+END	Extend the selection to the last cell used on the worksheet (lower-right corner)
CTRL+SPACEBAR	Select the entire column
SHFT+SPACEBAR	Select the entire row
CTRL+A	Select the entire worksheet
SHFT+BACKSPACE	If multiple cells are selected, select only the active cell
SHFT+PAGE DOWN	Extend the selection down one screen
SHFT+PAGE UP	Extend the selection up one screen
CTRL+SHFT+SPACEBAR	With an object selected, select all objects on a sheet
CTRL+6	Alternate between hiding objects, displaying objects, and displaying placeholders for objects
CTRL+7	Show or hide the Standard toolbar
In End mode
END	Turn End mode on or off
END, SHFT+ arrow key	Extend the selection to the last nonblank cell in the same column or row as the active cell
END, SHFT+HOME	Extend the selection to the last cell used on the worksheet (lower-right corner)
END, SHFT+ENTER	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)
With SCROLL LOCK on
SCROLL LOCK	Turn SCROLL LOCK on or off
UP ARROW or DOWN ARROW	Scroll the screen up or down one row
LEFT ARROW or RIGHT ARROW	Scroll the screen left or right one column
SHFT+HOME	Extend the selection to the cell in the upper-left corner of the window
SHFT+END	Extend the selection to the cell in the lower-right corner of the window
Select cells with special characteristics
CTRL+SHFT+* (ASTERISK)	Select the current region around the active cell (the current region is an area enclosed by blank rows and blank columns)
CTRL+/	Select the current array, which is the array that the active cell belongs to
CTRL+SHFT+O (the letter O)	Select all cells with comments
CTRL+\	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)
CTRL+SHFT+|	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)
CTRL+[	Select only cells that are directly referred to by formulas in the selection
CTRL+SHFT+{	Select all cells that are directly or indirectly referred to by formulas in the selection
CTRL+]	Select only cells with formulas that refer directly to the active cell
CTRL+SHFT+}	Select all cells with formulas that refer directly or indirectly to the active cell
ALT+SEMICOLON	Select only visible cells in the current selection
Select chart items
DOWN ARROW	Select the previous group of items
UP ARROW	Select the next group of items
RIGHT ARROW	Select the next item within the group
LEFT ARROW	Select the previous item within the group
Move and scroll on a worksheet or workbook
Arrow key	Move one cell in a given direction
CTRL+ arrow key	Move to the edge of the current data region
TAB	Move between unlocked cells on a protected worksheet
HOME	Move to the beginning of the row
CTRL+HOME	Move to the beginning of the worksheet
CTRL+END	Move to the last cell on the worksheet, which is the cell at the intersection of the right-most used column and the bottom-most used row (in the lower-right corner); cell opposite the Home cell, which is typically A1
PAGE DOWN	Move down one screen
PAGE UP	Move up one screen
ALT+PAGE DOWN	Move one screen to the right
ALT+PAGE UP	Move one screen to the left
CTRL+PAGE DOWN	Move to the next sheet in the workbook
CTRL+PAGE UP	Move to the previous sheet in the workbook
CTRL+F6 or CTRL+TAB	Move to the next workbook or window
CTRL+SHFT+F6 or CTRL+SHFT+TAB	Move to the previous workbook or window
F6	Move to the next pane
SHFT+F6	Move to the previous pane
CTRL+BACKSPACE	Scroll to display the active cell
In End mode
END	Turn End mode on or off
END, arrow key	Move by one block of data within a row or column
END, HOME	Move to the last cell on the worksheet, which is the cell at the intersection of the right-most used column and the bottom-most used row (in the lower-right corner); cell opposite the Home cell, which is typically A1
END, ENTER	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)
With SCROLL LOCK turned on
SCROLL LOCK	Turn SCROLL LOCK on or off
HOME	Move to the cell in the upper-left corner of the window
END	Move to the cell in the lower-right corner of the window
UP ARROW or DOWN ARROW	Scroll one row up or down
LEFT ARROW or RIGHT ARROW	Scroll one column left or right
Work in print preview
Arrow keys	Move around the page when zoomed in
PAGE UP or PAGE DOWN	Move by one page when zoomed out
CTRL+UP ARROW or CTRL+LEFT ARROW	Move to the first page when zoomed out
CTRL+DOWN ARROW or CTRL+RIGHT ARROW	Move to the last page when zoomed out
Work in a data form
ALT+ key, where key is the underlined letter in the field or cmnd name	Select a field or a command button
DOWN ARROW	Move to the same field in the next record
UP ARROW	Move to the same field in the previous record
TAB	Move to the next field you can edit in the record
SHFT+TAB	Move to the previous field you can edit in the record
ENTER	Move to the first field in the next record
SHFT+ENTER	Move to the first field in the previous record
PAGE DOWN	Move to the same field 10 records forward
PAGE UP	Move to the same field 10 records back
CTRL+PAGE DOWN	Move to the new record
CTRL+PAGE UP	Move to the first record
HOME or END	Move to the beginning or end of a field
LEFT ARROW or RIGHT ARROW	Move one character left or right within a field
SHFT+HOME	Extend a selection to the beginning of a field
SHFT+END	Extend a selection to the end of a field
SHFT+LEFT ARROW	Select the character to the left
SHFT+RIGHT ARROW	Select the character to the right
Work with the AutoFilter feature
Select the cell that contains the column label, and then press ALT+DOWN ARROW	Display the AutoFilter list for the current column
ALT+UP ARROW	Close the AutoFilter list for the current column
DOWN ARROW	Select the next item in the AutoFilter list
UP ARROW	Select the previous item in the AutoFilter list
HOME	Select the first item (All) in the AutoFilter list
END	Select the last item in the AutoFilter list
ENTER	Filter the list by using the selected item in the AutoFilter list
Work with the PivotTable Wizard (In Step 3 of the PivotTable Wizard)
UP ARROW or DOWN ARROW	Select the next or previous field button in the list
LEFT ARROW or RIGHT ARROW	Select the field button to the right or left in a multicolumn field button list
ALT+P	Move the selected field into the Page area
ALT+R	Move the selected field into the Row are
ALT+C	Move the selected field into the Column area
ALT+D	Move the selected field into the Data area
ALT+L	Display the PivotTable Field dialog box
Work with page fields in a PivotTable
UP ARROW	Select the previous item in the list
DOWN ARROW	Select the next item in the list
HOME	Select the first visible item in the list
END	Select the last visible item in the list
ENTER	Display the selected item
Group and ungroup PivotTable items
ALT+SHFT+RIGHT ARROW	Group selected PivotTable items
ALT+SHFT+LEFT ARROW	Ungroup selected PivotTable items
Outline data
ALT+SHFT+LEFT ARROW	Ungroup rows or columns
ALT+SHFT+RIGHT ARROW	Group rows or columns
CTRL+8	Display or hide outline symbols
CTRL+9	Hide selected rows
CTRL+SHFT+(	Unhide selected rows
CTRL+0 (ZERO)	Hide selected columns
CTRL+SHFT+)	Unhide selected columns
Keys for menus
SHFT+F10	Show a shortcut menu
F10 or ALT	Make the menu bar active
ALT+SPACEBAR	Show the program icon menu (on the program title bar)
DOWN ARROW or UP ARROW (with the menu or submenu displayed)	Select the next or previous command on the menu or submenu
LEFT ARROW or RIGHT ARROW	Select the menu to the left or right, or, with a submenu visible, switch between the main menu and the submenu
HOME or END	Select the first or last command on the menu or submenu
ALT	Close the visible menu and submenu at the same time
ESC	Close the visible menu, or, with a submenu visible, close the submenu only
On a toolbar
F10 or ALT	Make the menu bar active
CTRL+TAB or CTRL+SHFT+TAB	Select the next or previous toolbar
TAB or SHFT+TAB (when a toolbar is active)	Select the next or previous button or menu on the toolbar
ENTER	Open the selected menu
ENTER	Perform the action assigned to the selected button
ENTER	Enter text in the selected text box
Arrow keys to move through optns in the list or menu; ENTER to select the optn you want (when a drop-down list box is selected)	Select an option from a drop-down list box or from a drop-down menu on a button
In a window
ALT+TAB	Switch to the next program
ALT+SHFT+TAB	Switch to the previous program
CTRL+ESC	Show the Windows Start menu
CTRL+W	Close the active workbook window
CTRL+F5	Restore the active workbook window
CTRL+F6	Switch to the next workbook window
CTRL+SHFT+F6	Switch to the previous workbook window
CTRL+F7	Carry out the Move command (workbook icon menu, menu bar)
CTRL+F8	Carry out the Size command (workbook icon menu, menu bar)
CTRL+F9	Minimize the workbook window to an icon
CTRL+F10	Maximize or restore the workbook window
ALT+0 to select the folder list; arrow keys to select a folder	Select a folder in the Open or Save As dialog box (File menu)
ALT+ number (1 is the leftmost button, 2 is the next, and so on)	Choose a toolbar button in the Open or Save As dialog box (File menu)
F5	Update the files visible in the Open or Save As dialog box (File menu)
In a dialog box
CTRL+TAB or CTRL+PAGE DOWN	Switch to the next tab in a dialog box
CTRL+SHFT+TAB or CTRL+PAGE UP	Switch to the previous tab in a dialog box
TAB	Move to the next option or option group
SHFT+TAB	Move to the previous option or option group
Arrow keys	Move between options in the active drop-down list box or between some options in a group of options
SPACEBAR	Perform the action assigned to the active button (the button with the dotted outline), or select or clear the active check box
Letter key for the first letter in the optn name you want (when a drop-down list box is selected)	Move to an option in a drop-down list box
ALT+ letter, where letter is the key for the underlined letter in the optn name	Select an option, or select or clear a check box
ALT+DOWN ARROW	Open the selected drop-down list box
ESC	Close the selected drop-down list box
ENTER	Perform the action assigned to the default command button in the dialog box (the button with the bold outline ¾ often the OK button)
ESC	Cancel the command and close the dialog box
In a text box
HOME	Move to the beginning of the entry
END	Move to the end of the entry
LEFT ARROW or RIGHT ARROW	Move one character to the left or right
CTRL+LEFT ARROW or CTRL+RIGHT ARROW	Move one word to the left or right
SHFT+HOME	Select from the insertion point to the beginning of the entry
SHFT+END	Select from the insertion point to the end of the entry
SHFT+LEFT ARROW	Select or unselect one character to the left
SHFT+RIGHT ARROW	Select or unselect one character to the right
CTRL+SHFT+LEFT ARROW	Select or unselect one word to the left
CTRL+SHFT+RIGHT ARROW	Select or unselect one word to the right
Keys for using the Office Assistant
ALT+F6; repeat until the balloon is active	Make the Office Assistant the active balloon
ALT+topic number (where 1 is the first topic, 2 is the second, and so on)	Select a Help topic from the topics displayed by the Office Assistant
ALT+DOWN ARROW	See more help topics
ALT+UP ARROW	See previous help topics
ESC	Close an Office Assistant message
F1	Get Help from the Office Assistant
ALT+N	Display the next tip
ALT+B	Display the previous tip
ESC	Close tips
TAB to select the Office Assistant button; SPACEBAR to show or hide the Assistant	Show or hide the Office Assistant in a wizard