EXCEL 97 SHORTCUT KEYS

Using Microsoft Excel 97.0 with Shortcut Keys

3 ways to access Excel 97 commands:

Menu bar
Toolbar
Summary of Excel 97 Shortcut Keys

Menu bar

You can select any menu command on the menu bar; or on the toolbar with keyboard shortcuts. Press ALT to activate the menu bar. Once the menu bar has been activated press any underlined pull down file menu letter, your selection will then become highlighted by a 3-D contrasting focus. Now press the letter that is underlined within the pull down menu containing the command you want.

Toolbar

If you want to use the toolbar, press F10+CONTROL plus TAB to go to the top row of the toolbar; repeat the CONTROL plus TAB command to go to the bottom row of the toolbar. The right and left arrow keys move the 3-D contrasting focus in both toolbar levels.

Summary of Excel 97 Shortcut Keys:

Shortcut Keys provide anyone with the ability to edit and or create a Excel document without depending upon a mouse pointer. Click on any of the following 13 hot links to learn how to use Shortcut Keys to access the commands within Microsoft's Excel 97.

If you are unable to use the mouse pointer to go to any of the 13 "hot links": press the TAB key until the link you want is highlighted by dots then press Enter. Accessing hot links with the TAB key will not work with Internet browsers earlier then Netscape Navigator 4.0.

Enter data by using shortcut keys:

All of the commands presented in the Entering Data Table consist of two units per command. Each command occupies a complete line of text. In the first command, for example, the first unit "Complete a cell entry" describes the result of  pressing the ENTER key. It is this second unit that puts into action the first unit. The  same reasoning applies to the command: "Start a new line in the same cell" with the combined pressing of the ALT+ENTER keys, etc.

Table

Entering Data

Format data by using shortcut keys: 

All of the commands presented in the Entering Data Table consist of two units per command. Each command occupies a complete line of text. In the first command, for example, the first unit "Display the Style command (Format menu)" describes the result of  pressing the ALT+apostrophe keys. It is this second unit that puts into action the first unit. The  same reasoning applies to the command: "Display the Cells command (Format menu)" with the combined pressing of the CONTROL+#1 keys, etc.

Table

Format Data

Edit data by using shortcut keys: 

All of the commands presented in Table 1, Editing a cell, consist of two units per command. Each command occupies a complete line of text. In the first command, for example, the first unit "Edit the active cell" describes the result of  pressing the F2 key. It is this second unit that puts into action the first unit. The same reasoning applies to another command: "Enter a formula as an array formula" with the combined pressing of the CONTROL+SHIFT+ENTER keys, etc.

Table 2 gives information for: "Copying, Inserting, and Deleting, a selection".
Table 3 presents: "Moving within a selection".

Edit Data Tables

Table 1

Editing a cell

Table 2

Copy, Insert, and Delete, a selection

Table 3

Moving within a selection

Select cells, columns, rows, or objects in worksheets and workbooks by using shortcut keys: 

All of the commands presented in Table 1, "Select data, cells, chart items, or objects," consist of two units per command. Each command occupies a complete line of text. In the first command, for example, the first unit "Select the current region around the active cell (the current region is an area enclosed by blank rows and blank columns)" describes the result of the combined pressing of the CONTROL+SHIFT+asterisk keys. It is this second unit that puts into action the first unit. The same reasoning applies to another command: "Extend the selection by one cell" with the combined pressing of the SHIFT+ARROW keys, etc.

The following links branch out to four specialized Tables that expand the capabilities of Shortcut keys within the same group "Select data, cells, chart items, or objects":

Table 2: "In End mode"
Table 3: "With SCROLL LOCK on"
Table 4: "Select cells with special characteristics"
Table 5: "Select chart items"

Table 1

Select data, cells, chart items, or objects,

Table 2

In End mode

Table 3

With SCROLL LOCK on

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.

Table 4

Select cells with special characteristics

Table 5

Select chart items

Move and scroll on a worksheet or workbook by using shortcut keys: 

All of the commands presented in Table 1, "Move and scroll on a worksheet or workbook," consist of two units per command. Each command occupies a complete line of text. In the first command, for example, the first unit "Move one cell in a given direction" describes the result of pressing one of the ARROW keys. It is this second unit that puts into action the first unit. The same reasoning applies to another command: "Move to the edge of the current data region" with the combined pressing of the CONTROL+ARROW KEY keys, etc.

The following links branch out to four specialized Tables that expand the capabilities of Shortcut keys within the same group
"Move and scroll on a worksheet or workbook":

Table 2: "In End mode"
Table 3: "With SCROLL LOCK turned on"

Table 1

Move and scroll on a worksheet or workbook

Table 2

In End mode

Table 3

With SCROLL LOCK turned on

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 preserve your selection while you scroll through the worksheet, turn on SCROLL LOCK first.

Print and preview a document by using shortcut keys

Table 1: "Print and preview," consist of two units per command. Each command occupies a complete line of text. In the first command, for example, the first unit "Display the Print command (File menu)" describes the result of pressing the CONTROL+P keys. It is this second unit that puts into action the first unit. The same reasoning applies to another command: as illustrated in Table 2, Work in print preview; "Move to the first page when zoomed out" with the combined pressing of the CONTROL+UP ARROW or CONTROL+LEFT ARROW keys, etc.

Table 1

Print and preview

Table 2

Work in print preview

Work with databases, lists, and PivotTables by using shortcut keys: 

Table 1: "Work in a data form," consist of two units per command. Each command occupies a complete line of text. In the first command, for example, the first unit "Select a field or a command button" describes the result of pressing the ALT+KEY,  where key is the underlined letter in the field or command name, keys. It is this second unit that puts into action the first unit. The same reasoning applies to another command: "Move to the new record" with the combined pressing of the CONTROL+PAGE DOWN keys, etc.

The following links branch out to four specialized Tables that expand the capabilities of Shortcut keys within the same group
"Work with databases, lists, and PivotTables".

Table 2: "Work with the AutoFilter feature"
Table 3: "Work with the PivotTable Wizard"
Table 4: "Work with page fields in a PivotTable"
Table 5: "Group and ungroup PivotTable items"

Work with databases, lists, and PivotTables:

Table 1

Work in a data form

Table 2

Work with the AutoFilter feature

Table 3

Work with the PivotTable Wizard;

  In Step 3 of the PivotTable Wizard

Table 4

Work with page fields in a PivotTable

Table 5

Group and ungroup PivotTable items

Outline data by using shortcut keys: 

In the following Table: "Outline data," there are two units per command. Each command occupies a complete line of text. In the first command, for example, the first unit "Ungroup rows or column" describes the result of pressing the ALT+SHIFT+LEFT ARROW keys, etc. It are these second units that puts into action the first unit throughout the Table.

Table

Outline data

Function Keys in Microsoft Excel:

In the following Table: "Function Keys," there are two units per command. Each command occupies a complete line of text. In the first command, for example, the first unit "Display Help or the Office Assistant Print command" describes the result of pressing the F1 key, etc. It are these second units that puts into action the first unit throughout the Table.

Table

Function Keys

Work with toolbars by using shortcut keys:

In the following Table: "Keys for toolbars," there are two units per command. Each command occupies a complete line of text. In the first command, for example, the first unit "Make the menu bar active" describes the result of pressing the F10 or ALT key, etc. Another command example for the first unit: "Select an option from a drop-down list box or from a drop-down menu on a button" describes the result of pressing the ARROW KEYS to move through options in the list or menu; press ENTER to select the option you want (when a drop-down list box is selected). It are these second units that puts into action the first unit throughout the Table.

Table

Keys for toolbars

Work in windows and dialog boxes using shortcut keys:

Table 1: "In a window," consist of two units per command. Each command occupies a complete line of text. In the first command, for example, the first unit "Switch to the next program" describes the result of pressing the ALT+TAB keys. It is this second unit that puts into action the first unit. The same reasoning applies to another command: "Switch to the previous program" with the combined pressing of the ALT+SHIFT+TAB keys, etc.

The following links branch out to two specialized Tables that expand the capabilities of Shortcut keys within the same group
"Work in windows and dialog boxes".

Table 2: "In a dialog box"
Table 3: "In a text box"

Work in windows and dialog boxes:

Table 1

In a window

Table 2

In a dialog box

Table 3

In a text box

Web Page Designed By  ADAM
Copyright © 1981 - 2008 MINDPRIDE CONSULTING All rights reserved.
Revised: November 21, 2007