Note these shortcuts are with transition navigation keys option turned off. If you have a problem with any of these shortcuts -- tools, options, transition, make sure transition navigation keys is off -- also make sure that you do not have Scroll Lock on (there is an indicator light and you can have sound warning with ToggleKeys for Scroll Lock) /* required outside generated table*/.

XL2000 Keyboard Shortcuts Keystrokes to invoke

Location: http://www.mvps.org/dmcritchie/excel/shortx2k.htm

Use FIND to locate a shortcut Use FIND to locate a shortcut

If you create your own table in Excel from the Help files it will contain shortcuts to the HELP files, and give you some experience in copying data. This table was created by copying from the HELP file. Segments have been swapped left and right to make this more readable using move Column C by dragging the side of selected cells to Column A then using Edit, Shift cells to right. This table is similar to the one in SHORTX95.HTM where you will find additional information on Calculation and on working with disabilities (accessibility options).

(shortx2k -- Created from webpages.xls [ShortX2K] file 2000-06-25)

Keys for working in a spreadsheet

s1 Keys for moving and scrolling in a worksheet or workbook

s2 Keys for previewing and printing a document

s3 Keys for working with worksheets, charts, and macros

Keys for working with data

1 Keys for entering data

2 Keys for formatting data

3 Keys for editing data

4 Keys for selecting data and cells

5 Keys for selecting charts and chart items

6 Keys to use with databases and lists

7 Keys for outlining data

8 Keys to use with PivotTable and PivotChart reports

x9 Keys to use with the OLAP Cube Wizard

Keys for working in Microsoft Office

10 Keys for menus and toolbars

11 Keys for windows, dialog boxes, and edit boxes

12 Keys for the Office Assistant

13 Keys for working with the Open and Save As dialog boxes

14 Keys for sending e-mail messages

15 Keys for working with drawing objects, AutoShapes, WordArt, and other objects

Keys for working in a spreadsheet

Keys for moving and scrolling in a worksheet or workbook

Windows Shortcuts Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P. Use of ALT+SPACEBAR is also good to move a window when the titlebar gets stuck under the top of the screen. More on handling Windows Window and an Excel Window. ALT+SPACEBAR then X (Ma x imize)

ALT+SPACEBAR then R ( R estore)

ALT+SPACEBAR then M ( M ove)

This topic lists:

Keys for moving and scrolling in a worksheet or workbook

Keys for moving in a worksheet with End mode on

Keys for moving in a worksheet with SCROLL LOCK on

s1 Keys for moving and scrolling in a worksheet or workbook

Move one cell up, down, left, or right Arrow keys

Move to the edge of the current data region

Mouse alternative: double-click on cell border in direction wanted. CTRL+arrow key

Move to the beginning of the row HOME

Move to the beginning of the worksheet CTRL+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 CTRL+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 CTRL+PAGE DOWN

Move to the previous sheet in the workbook CTRL+PAGE UP

Move to the next workbook or window CTRL+F6 or CTRL+TAB

Move to the previous workbook or window CTRL+SHIFT+F6 or CTRL+SHIFT+TAB

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

Scroll to display the active cell CTRL+BACKSPACE

Display the Go To dialog box F5

Display the Find dialog box SHIFT+F5

Repeat the last Find action (same as Find Next) SHIFT+F4

Move between unlocked cells on a protected worksheet TAB

s2 Keys for moving in a worksheet with End mode on

Turn End mode on or off END

Move by one block of data within a row or column

(a shortcut for this shortcut is to double-click on a cell border) 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

s3 Keys for moving in a worksheet with SCROLL LOCK on

Turn 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 ARROW or DOWN ARROW

Scroll one column left or right LEFT ARROW 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 working with data

1 Keys for entering data

Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P. ALT+SPACEBAR then X

ALT+SPACEBAR then R

This topic lists:

Keys for entering data on a worksheet

Keys for working in cells or the formula bar

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 (IBM ThinkPad problem...) ALT+ENTER (Mac: Ctrl Command Enter)

Fill the selected cell range with the current entry CTRL+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 ESC

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 CTRL+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 CTRL+Y

Edit a cell comment SHIFT+F2

Create names from row and column labels CTRL+SHIFT+F3

Fill down CTRL+D

Fill to the right CTRL+R

Define a name CTRL+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 a formula as an array formula CTRL+SHIFT+ENTER

Cancel an entry in the cell or formula bar ESC

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 CTRL+SHIFT+A

Insert a hyperlink CTRL+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 -- [fx] toolbar button, replace missing button SHIFT+F3

Calculate all sheets in all open workbooks F9

Calculate all sheets in the active workbook CTRL+ALT+F9

Calculate the active worksheet SHIFT+F9

Start a formula = (equal sign)

Insert the AutoSum formula ALT+= (equal sign)

Enter the date CTRL+; (semicolon)

Enter the time CTRL+SHIFT+: (colon)

Copy the value from the cell above the active cell into the cell or the formula bar CTRL+SHIFT+" (quotation mark)

Alternate between displaying cell values and displaying cell formulas CTRL+` (accent grave /not a quotation mark)

Copy a formula from the cell above the active cell into the cell or the formula bar CTRL+' (apostrophe / single quote)

Display the AutoComplete list (i.e. cell with data validation dropdown) ALT+DOWN ARROW

2 Keys for formatting data

Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P. ALT+SPACEBAR then X

ALT+SPACEBAR then R

Display the Style dialog box ALT+' (apostrophe / single quote)

Display the Format Cells dialog box CTRL+1

Apply the General number format CTRL+SHIFT+~

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

Apply the Percentage format with no decimal places CTRL+SHIFT+%

Apply the Exponential number format with two decimal places CTRL+SHIFT+^

Apply the Date format with the day, month, and year CTRL+SHIFT+#

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

Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values CTRL+SHIFT+!

Apply the outline border CTRL+SHIFT+&

Remove outline borders CTRL+SHIFT+_

Apply or remove bold formatting CTRL+B

Apply or remove italic formatting CTRL+I

Apply or remove an underline CTRL+U

Apply or remove strikethrough formatting CTRL+5

Hide rows CTRL+9

Unhide rows CTRL+SHIFT+( (opening parenthesis)

Hide columns CTRL+0 (zero)

Unhide columns CTRL+SHIFT+) (closing parenthesis)

3 Keys for editing data

Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P. ALT+SPACEBAR then X

ALT+SPACEBAR then R

This topic lists:

Keys for editing data

Keys for inserting, deleting, and copying a selection

Keys for moving within a selection

Keys for editing data

Edit the active cell and put the insertion point at the end of the line F2

Cancel an entry in the cell or formula bar ESC

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 CTRL+SHIFT+ENTER

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 CTRL+SHIFT+A

Display the Spelling dialog box F7

Keys for inserting, deleting, and copying a selection

Copy the selection CTRL+C

Cut the selection CTRL+X

Paste the selection CTRL+V

Clear the contents of the selection DELETE

Delete the selection CTRL+HYPHEN [Ctrl+-]

Undo the last action CTRL+Z

Insert blank cells CTRL+SHIFT+PLUS SIGN [Ctrl++]

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 CTRL+PERIOD

Move to the right between nonadjacent selections CTRL+ALT+RIGHT ARROW

Move to the left between nonadjacent selections CTRL+ALT+LEFT ARROW

4 Keys for selecting data and cells

This topic lists:

Keys for selecting cells, columns, or rows

Keys for extending the selection with End mode on

Keys for selecting cells that have special characteristics

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) CTRL+SHIFT+* (asterisk)

Extend the selection by one cell SHIFT+arrow key

Extend the selection to the last nonblank cell in the same column or row as the active cell CTRL+SHIFT+arrow key

Extend the selection to the beginning of the row SHIFT+HOME

Extend the selection to the beginning of the worksheet CTRL+SHIFT+HOME

Extend the selection to the last used cell on the worksheet (lower-right corner) CTRL+SHIFT+END

Select the entire column (remains valid in Excel 2003) CTRL+SPACEBAR

Select the entire row (remains valid in Excel 2003) SHIFT+SPACEBAR

Select the entire worksheet

(the grey button to the left of column headings (A-B-C), and above the

row headings (1-2-3) is similar but does change the active cell) CTRL+A (unless you have Excel 2003)

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 (Excel 2003 behavior is broken by design just like Excel 2003 Alt+A) CTRL+SHIFT+SPACEBAR (broken by Excel 2003)

Alternate between hiding objects, displaying objects, and displaying placeholders for objects CTRL+6

Show or hide the Standard toolbar CTRL+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

Extend the selection to the cell in the upper-left corner of the window SCROLL LOCK, SHIFT+HOME

Extend the selection to the cell in the lower-right corner of the window SCROLL LOCK, SHIFT+END

Return to top

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

Extend the selection to the last nonblank cell in the same column or row as the active cell END, SHIFT+arrow key

Extend the selection 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

Return to top

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) CTRL+SHIFT+* (asterisk)

Select the current array, which is the array that the active cell belongs to CTRL+/

Select all cells with comments CTRL+SHIFT+O (the letter 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. CTRL+\

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. CTRL+SHIFT+|

Select only cells that are directly referred to by formulas in the selection CTRL+[ (opening bracket)

Select all cells that are directly or indirectly referred to by formulas in the selection CTRL+SHIFT+{ (opening brace)

Select only cells with formulas that refer directly to the active cell CTRL+] (closing bracket)

Select all cells with formulas that refer directly or indirectly to the active cell CTRL+SHIFT+} (closing brace)

Select only visible cells in the current selection ALT+; (semicolon)

5 Keys for selecting charts and chart items

Keys for selecting a chart sheet

Select the next sheet in the workbook, until the chart sheet you want is selected CTRL+PAGE DOWN

Select the previous sheet in the workbook, until the chart sheet you want is selected CTRL+PAGE UP

Keys for selecting an embedded chart

Note The Drawing toolbar must already be displayed.

1. Press F10 to make the menu bar active. F10

2. Press CTRL+TAB or CTRL+SHIFT+TAB to select the Drawing toolbar. CTRL+TAB

CTRL+SHIFT + TAB

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

4. Press CTRL+ENTER to select the first object. CTRL+ENTER

5. 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. TAB

6. Press CTRL+ENTER to make the chart active. CTRL + ENTER

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

There are also keys to use with PivotChart reports.

6 Keys to use with databases and lists

Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P. ALT+SPACEBAR then X

ALT+SPACEBAR then R

This topic lists:

Keys for working with a data form

Keys for using AutoFilter

Keys for working with a data form

Select a field or a command button ALT+key, where key is the underlined letter in the field or command name

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 CTRL+PAGE DOWN

Move to the same field 10 records back PAGE UP

Move to the first record CTRL+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

Extend a selection to the beginning of a 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 label, 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

7 Keys for outlining data

Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P. ALT+SPACEBAR then X

ALT+SPACEBAR then R

Group rows or columns ALT+SHIFT+RIGHT ARROW

Ungroup rows or columns ALT+SHIFT+LEFT ARROW

Display or hide outline symbols CTRL+8

Hide selected rows CTRL+9

Unhide selected rows CTRL+SHIFT+( (opening parenthesis)

Hide selected columns CTRL+0 (zero)

Unhide selected columns CTRL+SHIFT+) (closing parenthesis)

8 Keys to use with PivotTable and PivotChart reports

Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P. ALT+SPACEBAR then X

ALT+SPACEBAR then R

This topic lists:

Keys for the PivotTable and PivotChart Wizard

Keys for page fields in a PivotTable or PivotChart report

Keys for laying out a PivotTable or PivotChart report

Keys for grouping and ungrouping PivotTable items

Keys for the PivotTable and PivotChart Wizard

Select the previous or next field button in the list UP ARROW or DOWN ARROW

Select the field button to the left or right in a multicolumn field button list LEFT ARROW 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 CTRL+SHIFT+* (asterisk)

Display the list for the current field in a 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

1. Press F10 to make the menu bar active. F10

2. Press CTRL+TAB or CTRL+SHIFT+TAB to select the PivotTable toolbar. CTRL+TAB

CTRL+SHIFT+TAB

3. 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. LEFT ARROW

RIGHT ARROW

4. 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. ENTER* + DOWN ARROW

ENTER* + UP ARROW

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

Keys for grouping and ungrouping PivotTable items

Group selected PivotTable items ALT+SHIFT+RIGHT ARROW

Ungroup selected PivotTable items ALT+SHIFT+LEFT ARROW

Return to top

Keys for working in Microsoft Office

10 Keys for menus and toolbars

Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P. ALT+SPACEBAR then X

ALT+SPACEBAR then R

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 CTRL+TAB or CTRL+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 then X

ALT+SPACEBAR then R

Select the next or previous command on the menu or submenu DOWN ARROW or UP ARROW (with the menu or submenu displayed)

Select the menu to the left or right or, with a submenu visible, switch between the main menu and the submenu LEFT ARROW or RIGHT ARROW

Select the first or last command on the menu or submenu HOME or END

Close the visible menu or, with a submenu visible, close the submenu only ESC

Display the full set of commands on a menu CTRL+DOWN ARROW

Tip You can select any menu command on the menu bar or on a visible toolbar with the keyboard. To select the menu bar, press ALT. (Then to select a toolbar, press CTRL+TAB repeatedly until you select the toolbar you want.) Press the underlined letter in the menu name that contains the command you want. In the menu that appears, press the underlined letter in the command name that you want.

11 Keys for windows, dialog boxes, and edit boxes

Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P. ALT+SPACEBAR then X

ALT+SPACEBAR then R

This topic lists shortcut keys for:

Keys for windows

Keys for dialog boxes

Keys for edit boxes in dialog boxes

Keys for windows

Switch to the next program ALT+TAB

Switch to the previous program ALT+SHIFT+TAB

Show the Windows Start menu CTRL+ESC

Close the active workbook window CTRL+W or CTRL+F4

Restore the active workbook window size CTRL+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 CTRL+F6

Switch to the previous workbook window CTRL+SHIFT+F6

Carry out the Move command (workbook icon menu, menu bar), or use the arrow keys to move the window CTRL+F7

Carry out the Size command (workbook icon menu, menu bar), or use the arrow keys to size the window CTRL+F8

Minimize the workbook window to an icon CTRL+F9

Maximize or restore the workbook window CTRL+F10

Copy the image of the screen to the Clipboard PRTSCR

Copy the image of the active window to the Clipboard ALT+PRINT SCREEN

Return to top

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 tab in a dialog box CTRL+TAB or CTRL+PAGE DOWN

Switch to the previous tab in a dialog box CTRL+SHIFT+TAB or CTRL+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 in the option name you want (when a drop-down list box is selected)

Select an option, or select or clear a check box ALT+letter, where letter is the key for the underlined letter in the option name

Open the selected drop-down list box ALT+DOWN ARROW

Perform the action assigned to the default command button in the dialog box (the button with the bold outline — often the OK button) ENTER

Cancel the command and close the dialog box ESC

Return to top

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 ARROW or RIGHT ARROW

Move one word to the left CTRL+LEFT ARROW

Move one word to the right CTRL+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 CTRL+SHIFT+LEFT ARROW

Select or unselect one word to the right CTRL+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

12 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

13 Keys for working with the Open and Save As dialog boxes

Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P. ALT+SPACEBAR + x

ALT+SPACEBAR + R

Display the Open dialog box CTRL+F12 or CTRL+O

Save the active workbook ALT+F2 or F12 or CTRL+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 (Up One Level button ) ALT+2

Close the dialog box, and open your World Wide Web search page (Search the Web button ) ALT+3

Delete the selected folder or file (Delete button ) ALT+4

Create a new subfolder in the open folder (Create New Folder button ) ALT+5

Switch between List, Details, Properties, and Preview views ALT+6

Show the Tools menu (Tools button) ALT+7

14 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. [OE shortcuts]

Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P. ALT+SPACEBAR then X

ALT+SPACEBAR then R

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 CTRL+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 (View menu, Options command in a message) ALT+P

Create a message flag CTRL+SHIFT+G

15 Keys for working with drawing objects, AutoShapes, WordArt, and other objects

Inserting drawing objects

Insert an AutoShape ALT+U

Insert a text box

Insert a WordArt object

Selecting drawing objects

Select a drawing object F10 for toolbar

Editing drawing objects

Rotate a drawing object

Change the size of a drawing object

Copy the attributes of a drawing object

Rotate a drawing object by using the keyboard

1. Use the keyboard to select the drawing object you want to rotate.

2. On the Format menu, select the command for the type of object selected — for example, AutoShape or Text Box — and then select the Size tab.

3. In the Rotation box, enter the amount of rotation you want.

Change the size of a drawing object by using the keyboard

1. Use the keyboard to select the drawing object you want to resize.

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

1. Use the keyboard to 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.

2. to copy the object attributes. Press CTRL+SHIFT+C

3. to select the object you want to copy the attributes to. Press TAB or SHIFT+TAB

4. to copy the attributes to the object. Press CTRL+SHIFT+V

This webpage was created via XL2HTML macro available at 02/27/2001 10:56 via HL2HTML

http://www.mvps.org/dmcritchie/excel/xl2htmlx.txt

Will handle Right Justified, Font Color, bold, italic, Font size, merged cells -- tested only in XL2000. Think vertically merged was added in XL2000.

Will handle hyperlink when it is the only value in a cell.

Will not handle: Interior color, hyperlinks when not only value in a cell

Shortcuts NOT documented in Excel 2000 (see menus) Find [Ctrl+F], Replace [Ctrl+H], GoTo [Ctrl+G] are not found in HELP

Find Ctrl+F

Replace Ctrl+H

xx Shortcuts added in later versions of Excel