EXCEL 97 - 261 Keyboard Shortcuts
Start a formula; works within a cell or formula bar. = (EQUAL SIGN)
Close the visible menu and submenu at the same time; works with menu commands.
ALT
Display the Style command (on Format menu); works in a spreadsheet. ALT+'
(APOSTROPHE)
Select a field or a menu; works within a spreadsheet. ALT+ letter key, where key
is the underlined letter in the field or menu command
Select a menu, or select or clear a check box by the letter underlined in the
menu command; works with dialog boxes. ALT+ letter key, where key is the
underlined letter in the field or menu command
Select an option in the Open or Save As dialog boxes (in File menu); works with
windows and dialog boxes. ALT+ number (where hitting key for 1 selects the
leftmost option, 2 the next, and so on)
Insert the AutoSum formula; works within a cell or formula bar of a spreadsheet.
ALT+= (EQUAL SIGN)
Select the folder list in the Open and Save As dialog boxes (in File menu); use
within a dialog box; use arrow keys to select a folder in the list. ALT+0(ZERO)
Display the previous tip; use with Office Assistant. ALT+B
Move the selected field into the Column area; Use within the Pivot Table Wizard.
ALT+C
Move a selected field into the Data area; use when working within the Pivot
Table Wizard. ALT+D
Display the AutoComplete list when working within a cell or formula bar.
ALT+DOWN ARROW
Open a selected drop-down menu; works within a dialog box. ALT+DOWN ARROW
Display more Help topics; works when using Office Assistant. ALT+DOWN ARROW
Start a new line in the same cell while working in a cell or formula bar.
ALT+ENTER
Activate Office Assistant while working in a document. ALT+F6; repeat until the
balloon is active
Display Pivot Table dialog box. ALT+L
Display the next tip when working with Office Assistant. ALT+N
Move a selected field into the Page area when working with the Pivot Table
Wizard. ALT+P
Display next screen to the right while working in a worksheet or workbook.
ALT+PAGE DOWN
Display previous screen to the left while working in a worksheet or workbook.
ALT+PAGE UP
Move a selected field into the Row area while working within the Pivot Table
Wizard. ALT+R
Select only visible cells in the active window. ALT+SEMICOLON
Ungroup selected Pivot Table items while working with Pivot Table.
ALT+SHIFT+LEFT ARROW
Ungroup rows or columns in an outlined spreadsheet. ALT+SHIFT+LEFT ARROW
Group selected Pivot Table items while working within a Pivot Table.
ALT+SHIFT+RIGHT ARROW
Group rows or columns while working within a worksheet or workbook.
ALT+SHIFT+RIGHT ARROW
Move from active application window to previously active application window.
ALT+SHIFT+TAB
Open the menu of the leftmost icon on the main toolbar bar of the active window;
this menu typically contains the following commands: Restore, Move, Size,
Minimize, Maximize and Close. ALT+SPACEBAR
Move from active application window to the previously used application window;
to select an application from a list of the open applications, hold ALT down and
press TAB more than once to move through the list. ALT+TAB
Select a Help topic while using Office Assistant. ALT+number (where hitting key
for 1 selects the leftmost option, 2 the next, and so on)
Close the Auto Filter list for the current column. ALT+UP ARROW
Display previously viewed Help topics while using Office Assistant. ALT+UP ARROW
Move one cell in the given direction of the arrow key when working in a
worksheet or workbook. ARROW KEY
Move one cell in the given direction of the arrow key when working in a
worksheet or workbook. ARROW KEY
Move around a document while in Print Preview and zoomed in. ARROW KEY
Move between options in a selected drop-down menu or dialog box or between some
options in a group of options. ARROW KEY
Move between options in a selected drop-down menu or dialog box or between some
options in a group of options; add ENTER to select an option. ARROW KEY
Clear a selected cell or cells or to delete the character to the left of where
the cursor is positioned within the active cell while editing. BACKSPACE
Delete selected text while working within a worksheet or workbook. CTRL+ –
Copy a formula from the cell above the active cell into the active cell or
formula bar while working within a worksheet or workbook. CTRL+' (APOSTROPHE)
Move cursor to an edge of the current data region. CTRL+ arrow key
Select the current array, which is the array that the active cell belongs to.
CTRL+/
Enter the date where the cursor is positioned within an active cell. CTRL+;
(SEMI COLON)
Select only cells that are directly referred to by formulas in the specified
area of a worksheet or workbook. 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+\
Select only cells with formulas that refer directly to the active cell. CTRL+]
Alternate view between displaying cell values and displaying cell formulas.
CTRL+` (SINGLE LEFT QUOTATION MARK
Hide, or collapse, selected column(s) within a worksheet or workbook. CTRL+0
(ZERO)
Display the Cells dialog box (in Format menu) when working in a worksheet or
workbook. CTRL+1
Apply or remove strikethrough formatting to a selected area of a worksheet or
workbook. CTRL+5
Alternate view between hiding, displaying and displaying placeholders for
selected objects. CTRL+6
Display or hide the main toolbar of the active window. CTRL+7
Display or hide outline symbols of an active worksheet or workbook with an
outline. CTRL+8
Hide selected rows within an active worksheet or workbook. CTRL+9
Display Formula Palette after you type a valid function name in a formula bar.
CTRL+A
Select the entire active worksheet. CTRL+A
Move to the left between nonadjacent selections within a worksheet or workbook.
CTRL+ALT+LEFT ARROW
Move to the right between nonadjacent selections in a worksheet or workbook.
CTRL+ALT+RIGHT ARROW
Apply or remove Bold formatting to selected text within a cell, worksheet or
workbook. CTRL+B
Scroll to display the active cell. CTRL+BACKSPACE
Copy selected text or area to Windows Clipboard. CTRL+C
Enter data from cell just above active cell into active cell (Fill down) on a
worksheet or workbook. CTRL+D
Delete text to the end of the line in which the cursor is positioned.
CTRL+DELETE
Move to the last page in a spreadsheet, worksheet or workbook when zoomed out
while in Print Preview. CTRL+DOWN ARROW or CTRL+RIGHT ARROW
Move to the end of the current sheet of a worksheet or workbook. CTRL+END
Move to the last cell on the worksheet, which is the cell at the intersection of
the right-most active column and the bottom-most active row (in the lower-right
corner). CTRL+END
Fill the selected range with the current cell's contents while working in a
worksheet or workbook. CTRL+ENTER
Display Windows Start menu. CTRL+ESC
Maximize or restore the active worksheet or workbook window. CTRL+F10
Restore the active workbook window. CTRL+F5
Go to the next workbook window in the active application. CTRL+F6
Move to the next worksheet, workbook or window. CTRL+F6 or CTRL+TAB
Carry out the Move command (under Workbook icon menu, menu bar). CTRL+F7
Carry out the Size command (under Workbook icon menu, menu bar). CTRL+F8
Minimize the active workbook window. CTRL+F9
Go to the beginning of the active worksheet. CTRL+HOME
Apply or remove italic formatting to selected characters. CTRL+I
Insert a hyperlink from a document to a specified Web page address. CTRL+K
Move cursor's position one word to the left or right. CTRL+LEFT ARROW or
CTRL+RIGHT ARROW
Display the Print dialog box in order to print the active selection. CTRL+P
Move cursor's position to the top of the next sheet in the workbook. CTRL+PAGE
DOWN
Move cursor's position to the beginning of a new record. CTRL+PAGE DOWN
Move cursor's position to the top of the previous sheet in the workbook.
CTRL+PAGE UP
Go to the first record in the worksheet. CTRL+PAGE UP
Move cursor's position clockwise to the next corner of the selection.
CTRL+PERIOD
Fill cells to the right of the active cell with the content from the active
cell. CTRL+R
Extend the active selection to the last nonblank cell in the same column or row
as the active cell. CTRL+SHIFT+ arrow key
Apply the Number format with two decimal places, 1000 separator, and – for
negative values. CTRL+SHIFT+!
Copy the value from the cell above the active cell into the active cell or the
formula bar. CTRL+SHIFT+" (QUOTATION MARK)
Apply the Date format with the day, month and year into the active cell.
CTRL+SHIFT+#
Apply a currency format with two decimal places in the active cell (negative
numbers appear in parentheses). CTRL+SHIFT+$
Apply the Percentage format with no decimal places into the active cell.
CTRL+SHIFT+%
Apply the outline border to the active cell. CTRL+SHIFT+&
Unhide selected rows in worksheet. CTRL+SHIFT+(
Unhide selected columns in worksheet. CTRL+SHIFT+)
Select the current region around the active cell (the current region is an area
enclosed by blank rows and blank columns). CTRL+SHIFT+* (ASTERISK)
Enter the current time, including hour, minute and A.M. or P.M., into active
cell. CTRL+SHIFT+: (COLON)
Apply the Time format with the hour and minute, and indicate A.M. or P.M.
CTRL+SHIFT+@
Apply the Exponential number format with two decimal places into active cell.
CTRL+SHIFT+^
Remove all borders from a selected area. CTRL+SHIFT+_
Select all cells that are directly or indirectly referred to by formulas in a
selected area. CTRL+SHIFT+{
Select cells in a given area 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+SHIFT+|
Select all cells with formulas that refer directly or indirectly to the active
cell. CTRL+SHIFT+}
Apply the General number format to the active cell. CTRL+SHIFT+~
Insert the argument names and parentheses for a function, after you type a valid
function name in a formula. CTRL+SHIFT+A
Extend a selection to the last cell used on the worksheet (lower-right corner).
CTRL+SHIFT+END
Enter a formula as an array formula into the active cell. CTRL+SHIFT+ENTER
Go to the previous workbook window. CTRL+SHIFT+F6
Go to the previous workbook window. CTRL+SHIFT+F6 or CTRL+SHIFT+TAB
Extend the selection to the beginning of the worksheet. CTRL+SHIFT+HOME
Select or unselect one word to the left of the cursor. CTRL+SHIFT+LEFT ARROW
Select all cells with comments. CTRL+SHIFT+O (the letter O)
Insert blank cells into a row or column. CTRL+SHIFT+PLUS SIGN
Select or unselect one word to the right of the cursor. CTRL+SHIFT+RIGHT ARROW
With an object already selected, select all objects on a sheet.
CTRL+SHIFT+SPACEBAR
Go to the previous tab when working in a tabbed dialog box. CTRL+SHIFT+TAB or
CTRL+PAGE UP
Select the entire active column. CTRL+SPACEBAR
Move to the next tab on a tabbed dialog box. CTRL+TAB or CTRL+PAGE DOWN
Select the next or previous toolbar. CTRL+TAB or CTRL+SHIFT+TAB
Apply or remove Underline formatting to selected text. CTRL+U
Move to the first page when zoomed out in Print Preview. CTRL+UP ARROW or
CTRL+LEFT ARROW
Paste a copied item(s) from the Clipboard into a selected location (You also can
choose Paste from the Edit menu.). CTRL+V
Close the active workbook window. CTRL+W
Copy and remove the selected item(s) from their original location to the
Clipboard. (You also can choose the Cut command from the Edit menu.). CTRL+X
Redo, or repeat, the previous action. CTRL+Y
Undo the last action; note: some actions, like Shutdown, cannot be undone (You
also can choose Undo from the Edit menu.). CTRL+Z
Delete the selected item(s), or to delete the character to the right of the
cursor; if items are files they will be moved to the Recycle Bin. DELETE
Select the previous group of chart items. DOWN ARROW
Move to the same field in the next record. DOWN ARROW
Select the next item in the AutoFilter list. DOWN ARROW
Select the next item in a list when working with page fields in a Pivot Table.
DOWN ARROW
Select the next or previous command on the menu or submenu. DOWN ARROW or UP
ARROW (with the menu or submenu displayed)
Go to the end of the line. END
Turn End mode on or off in Excel. END
Go to the cell in the lower-right corner of the window. END
Select the last item in the AutoFilter list. END
Select the last visible item in the list when working in a Pivot Table. END
Go to the end of the entry. END
Scroll, within a row or column, one block of data in the direction of the arrow
key. END, arrow key
Move to the last cell to the right that is not blank in the current row;
unavailable if you have selected the Transition navigation keys check box on the
Transition tab. END, ENTER
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, HOME
Complete a cell entry and move down in the selection. ENTER
Move to the first field in the next record when working in Excel data form.
ENTER
Filter a list by selecting an item from AutoFilter list (Under Tools menu,
Filter submenu). ENTER
Display the selected item when working with page fields in a Pivot Table. ENTER
Open, or display, the selected menu on a toolbar. ENTER
Perform the action assigned to a selected button on a toolbar. ENTER
Enter text in the selected text box in a toolbar. ENTER
Perform the action assigned to the selected default command button in a dialog
box. 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). ENTER
Cancel an entry in the cell or formula bar. ESC
Close the visible menu, or, with a submenu visible, close the submenu only. ESC
Close a selected drop-down list in a dialog box. ESC
Cancel a command and close the dialog box. ESC
Close an Office Assistant message or tip. ESC
Display Help or the Office Assistant. F1
Insert a chart sheet into a worksheet or workbook. F1+ALT
Insert a new worksheet into a workbook. F1+ALT+SHIFT
Open Office Assistant in order to display context sensitive Help or to reveal
formatting of selected characters. F1+SHIFT
Activate, or select, the main toolbar beginning with the first toolbar option on
the left, usually File; after the first option is activated you can navigate
through toolbar and menu options using the appropriate ARROW keys; press F10 or
ALT again F10
Activate, or select, the main toolbar beginning with the first toolbar option on
the left, usually File; after the first option is activated you can navigate
through toolbar and menu options using the appropriate ARROW keys; press F10 or
ALT again F10 or ALT
Maximize or restore the workbook window. F10+CTRL
Display a shortcut menu. F10+SHIFT
Create a chart. F11
Display Visual Basic Editor. F11+ALT
Insert a Microsoft Excel 4.0 macro sheet. F11+CTRL
Insert a new worksheet into a workbook. F11+SHIFT
Display Save As dialog box (file menu). F12
Display Open dialog box (File menu). F12+CTRL
Display Print command (File menu). F12+CTRL+SHIFT
Carry out Save command (File menu). F12+SHIFT
Edit the active cell. F2
Display Save As dialog box (file menu). F2+ALT
Carry out the Save command (File menu). F2+ALT+SHIFT
Edit a cell comment. F2+SHIFT
Paste a name into a formula. F3
Define a name. F3+CTRL
Create names by using row and column labels. F3+CTRL+SHIFT
Paste a function into a formula. F3+SHIFT
Repeat the last action. F4
Quit Excel. F4+ALT
Close the active window. F4+CTRL
Repeat the last Find (find next) command. F4+SHIFT
Update the files visible in the Open or Save As dialog box (File menu). F5
Display the Go To tab on the Find and Replace dialog box (Edit menu). F5+
Restore the program window size. F5+CTRL
Display the Find dialog box. F5+SHIFT
Go to the next pane. F6
Move to the next open workbook window. F6+CTRL
Go to the previous open workbook window. F6+CTRL+SHIFT
Go to the previous open workbook window. F6+SHIFT
Display Spelling and Grammar dialog box (Tools Menu). F7
Move the window. F7+CTRL
Turn Extend mode on, which allows you to select as much of a worksheet or
workbook as you want; press ESC to cancel. F8
Display the Macro dialog box. F8+ALT
Resize the active window (document Control menu). F8+CTRL
Increase the size of selected area. F8+SHIFT
Calculate all sheets in all open workbooks. F9
Minimize the active workbook. F9+CTRL
Calculate the active worksheet. F9+SHIFT
Go to the beginning of the current line. HOME
Move to the beginning of the current row. HOME
Go to the cell in the upper-left corner of the worksheet. HOME
Select the first item (All) in the AutoFilter list, with Auto filter list open.
HOME
Select the first visible item in a list. HOME
Move to the beginning of the current entry. HOME
Go to the beginning or end of the current field. HOME or END
Select the first or last command on the menu or submenu. HOME or END
Select the previous item within the current group on a chart. LEFT ARROW
With scroll lock on, scroll the current screen left or right one column. LEFT
ARROW or RIGHT ARROW
In a data form, move one character left or right within a field. LEFT ARROW or
RIGHT ARROW
In the Pivot Table wizard, move the field button to the right or left in a
multicolumn field button list. LEFT ARROW or RIGHT ARROW
With a menu open, select the menu to the left or right of the original, or, with
a submenu visible, switch between the main menu and the submenu. LEFT ARROW or
RIGHT ARROW
Move one character to the left or right in a text box. LEFT ARROW or RIGHT ARROW
Choose a selected menu, drop-down list, or dialog box option by typing the first
letter in the option name. Letter key, where the letter is the same as the first
letter in option you want on a selected menu,
Scroll down one screen. PAGE DOWN
Go to the same field 10 records forward. PAGE DOWN
Move up one screen. PAGE UP
Move to the same field 10 records back when working in Data Form view. PAGE UP
In Print Preview, move forward or back by one preview page when zoomed out. PAGE
UP or PAGE DOWN
Select the next item within the group on a chart. RIGHT ARROW
Turn SCROLL LOCK on or off. SCROLL LOCK
Display the AutoFilter list for the current column. Select the cell that
contains the column label, and then press ALT+DOWN ARROW
Extend or reduce a selection by one cell. SHIFT+ ARROW KEY
If multiple cells are selected, select only the active cell. SHIFT+BACKSPACE
With scroll lock on, extend the selection to the cell in the lower-right corner
of the window. SHIFT+END
Use when working in Data form to extend a selection to the end of a field.
SHIFT+END
Select from the insertion point to the end of the text box entry. SHIFT+END
Complete a cell entry and move up in a selection. SHIFT+ENTER
Move to the first field in the previous record when working in Data form.
SHIFT+ENTER
Move with in a selection from bottom to top within the selection (up), or
opposite to the direction that is selected on the Edit tab (Tools menu, Options
command). SHIFT+ENTER
Display a shortcut menu that shows a list of commands relevant to the selected
object. SHIFT+F10
Move to the previous pane. SHIFT+F6
Extend the selection from the cursor's position in the row to the beginning of
the row. SHIFT+HOME
Extend a selection to the cell in the upper-left corner of the window.
SHIFT+HOME
Extend a selection to the beginning of a field. SHIFT+HOME
Select from the insertion point in the text box to the beginning of the text box
entry. SHIFT+HOME
Select or unselect one character to the left of the cursor's position.
SHIFT+LEFT ARROW
Extend the selection one screen down. SHIFT+PAGE DOWN
Extend the selection one screen up. SHIFT+PAGE UP
Select or unselect by one character to the right of the cursor's current
position. SHIFT+RIGHT ARROW
Select an entire row. SHIFT+SPACEBAR
Complete a cell entry and move to the left in the selection. SHIFT+TAB
Move from right to left within the selection, or move up one cell if only one
column is selected. SHIFT+TAB
Move to the previous option or option group in a dialog box. SHIFT+TAB
Move to the previous field you can edit in the selected record when working in
data form. SHIFT+TAB
Perform the action assigned to the active button, or select or clear the active
check box in the dialog box. SPACEBAR
Complete a cell entry and move to the right in the selection. TAB
Move from left to right within a selection, or move down one cell if only one
column is selected. TAB
Move between unlocked cells on a protected worksheet. TAB
Move to the next field you can edit in the record. TAB
Move to the next option or option group in a dialog box. TAB
When a toolbar is active, select the next or previous button or menu on the
toolbar. TAB or SHIFT+TAB (when a toolbar is active)
Display the Office Assistant in a wizard, or turn off Help with the wizard. TAB
to select the Office Assistant button; SPACEBAR to show or hide the Assistant
Select the next group of items in a chart. UP ARROW
Move to the same field in the previous record when working in data form. UP
ARROW
Select the previous item in the AutoFilter list. UP ARROW
Use with page fields in a Pivot Table to select the previous item in the list.
UP ARROW
Use with Scroll Lock to scroll the screen up or down one row. UP ARROW or DOWN
ARROW
In the Pivot Table Wizard, select the next or previous field button in the list.
UP ARROW or DOWN ARROW