Shortcut Keys in Excel 2000 (Excel Vers. 9)

Keyboard shortcuts and keyboard help is available in many "Help" files of Microsoft products. To find the keyboard shortcuts, go to Help and in the contents or index area, type in "keyboard".    Tip from Keyboard Assistance

Rather than just telling you to create a Shortcut keys sheet in an Excel file I decided to show you what mine looks like.  You should create your own, of course.

Creation of Shortcut keys spreadsheet

Shortcuts are entirely optional.  In XL95 a shortcut key can be assigned to a macro using: Tools --> Macro --> (select a macro) --> Options.  Excel will Warn you if you attempt to utilize a short cut key already in use -- it will change the form of assignment for instance.  You will have to remember them or write them down somewhere.  I highly recommend creating a sheet for your MS Excel installed shortcut keys so that you can use FIND to find a shortcut yourself.   You could even add your own at the bottom.  Also recommend creating another sheet for function keys.

Create your table of builtin shortcut keys as follows:

• HELP --> Index --> Shortcut keys --> built-in keyboard shortcuts
• copy and paste each category into a ShortCutKeys spreadsheet
• Put topics in Red 12 point bold font, the rest Black 10 point Normal (all Arial)

An alternative to a shortcut key is a Toolbar menu item, which in XL95 is entered on the same window as where a shortcut key is assigned. (see above)

I have assigned a short-cut key [Ctrl+k] or a tool bar menu item [* XL2HTML - simple conversion*] to some of the macros I wrote or use.

Function keys (continued)
Function keys	CTRL	CTRL+SHIFT
F1
F2	Display the Info window
F3	Define a name	Create names from cell text
F4	Close the window
F5	Restore the window size
F6	Go to the next workbook	Go to the previous workbook
F7	Carry out the Move command (Control menu)
F8	Carry out the Size command (document Control menu)
F9	Minimize the workbook
F10	Maximize the document window
F11
F12	Carry out the Open command (File menu)	Carry out the Print command (File menu)

Function keys (continued)
Function keys	ALT+SHIFT	CTRL+ALT
F1	Insert a new worksheet   [Alt+Shift+F1]
F9		Recalculate all cells on all worksheets in all open workbooks  [Ctrl+Alt+F9]

	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 sected 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 messagesl
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
	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.
	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
	To	Press
	Move one cell up, down, left, or right	Arrow keys
	Move to the edge of the current data region	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
	To	Press
	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
	To	Press
	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.
	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
	To	Press
	Complete a cell entry and move down in the selection	ENTER
	Start a new line in the same cell	ALT+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
	To	Press
	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	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+` (single left quotation mark)
	Copy a formula from the cell above the active cell into the cell or the formula bar	CTRL+' (apostrophe)
	Display the AutoComplete list	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.
	To	Press
	Display the Style dialog box	ALT+' (apostrophe)
	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.
	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
	To	Press
	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
	To	Press
	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
	Undo the last action	CTRL+Z
	Insert blank cells	CTRL+SHIFT+PLUS SIGN
	Keys for moving within a selection
	To	Press
	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
	To	Press
	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	CTRL+SPACEBAR
	Select the entire row	SHIFT+SPACEBAR
	Select the entire worksheet   -- or the grey button above to left of column headings (A-B-C), and above row headings (1-2-3)	CTRL+A
	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	CTRL+SHIFT+SPACEBAR
	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
	To	Press
	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
	To	Press
	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
	To	Press
	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
	To	Press
	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.
	This topic lists:
	Keys for working with a data form
	Keys for using AutoFilter
	Keys for working with a data form
	To	Press
	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
	To	Press
	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.
	To	Press
	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.
	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
	To	Press
	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
	To	Press
	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
	To	Press
	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.
	To	Press
	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
	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.
	This topic lists shortcut keys for:
	Keys for windows
	Keys for dialog boxes
	Keys for edit boxes in dialog boxes
	Keys for windows
	To	In a window, press
	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
	To	In a dialog box, press
	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
	To	In an edit box, press
	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
	To	Press
	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
	To	Press
	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.
	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.
	To	Press
	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 http://www.mvps.org/dmcritchie/excel/xl2htmlx.txt	02/27/2001 10:56
	Will handle Right Justified, Font Color, bold, italic, Font size, merged cells -- tested only in XL2000. Think verically merged was added in XL2000.	XL2HTML
	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

Euro Currency Symbol

Excel 2002 additions             Excel 2002 additions

Excel 2002 includes keyboard shortcuts to access the border styles buttons on the Border tab of the Format Cells dialog box.  (Q277581)   Use the following keyboard commands to select the specified border styles:

ALT+T   Top Border     ALT+B   Bottom Border     ALT+L   Left Border

ALT+R   Right Border     ALT+D   Diagonal and Down     ALT+U   Diagonal and Up

ALT+H   Horizontal     ALT+V   Vertical

Q288981 XL2002: How to Use Speech Recognition to Select Cells, Rows, and Columns

Some of my own additions -- Creating your own shortcut keys

Listed above were all of the shortcut keys for Excel.  You can also make your own short cut keys.

To create a shortcut key for a macro
   Alt+F8 (Tools, macro, macros), select the macro, options, key in shortcut key. 

You will get a warning if you attempt to change an existing shortcut.  But there could be
shortcuts in other non open workbooks.

Actually I invoke most of my own macros from menus or toolbar buttons.  Also see summary of how to invoke macros).

AutoFit of Columns and Rows

You can autofit row(s), or column(s) by selecting a range of of either or Select All (Ctrl+a) then double clicking on the boundary between the heading letters or numbers.  There is also a Select All button (gray/grey) located at the intersection of the row number headings and column letter headings.

Calculate and recalculation

Application.Calculate	calculates all open workbooks.
Range.Calculate	calculates the specified range
F9	Calculates all sheets in all open workbooks.
Ctrl+F9	(Minimize the worksheet)
Shift+F9	Calculate the active worksheet.
Ctrl+Alt+F9	Recalculates all cells on all worksheets in all open workbooks.

The common thread running through all but Ctrl+Alt+F9 of the above is that the recalculation occurs *only* on the cells that the Excel calculation engine thinks are dirty.

Since the calculation engine occasionally gets this wrong, we also have
Ctrl+Alt+F9 which forces a recalculation of *everything* in all open workbooks whether or not Excel *thinks* recalculations are needed.

Recalculate all open cells, worksheets, and workbooks
To recalculate all cells on all worksheets in all open workbooks, press CTRL+ALT+F9

Note   Recalculation of all formulas may take considerable time.  To recalculate only the current worksheet, press SHIFT+F9

Warning:  This is one way to learn that the A1 or other cell reference in the formula =CELL("filename",A1) really is needed.  Without the cell reference, recalculate will cause the active worksheet to appear instead of the name of the worksheet where the formula resides.  Another problem with displaying the active sheet instead of the sheet with the formula would be using
    SheetName = ActiveSheet.Name instead of
    SheetName = Application.Caller.Parent.Name
Reference to article posted by John Green.

If you have XL97 and do not have SR-2, checkout   XL97 recalculation problem in the MS KB.

The following is from a posting by Tom Ogilvy (Jun 1, 1999) for code to simulate Ctrl+Alt+F9

Sub tester3()
Application.SendKeys "^%{F9}"
End Sub

Back when the recalc problem was so prevelant, some people mapped this
to the F9 key use
Application.onkey "{F9}","xlmisc68.xls!Tester3"

John Walkenbach then reported that in XL2000 the Ctrl+Alt+F9 gets recorded as:
    Application.CalculateFull

The following summarizes Programming use (Charles Wilson, 2000-11-10 programming)

In Excel 2000:
Application.calculate      ' f9
application.calculatefull  ' ctrl-alt-f9

in Excel 97
application.calculate      ' f9
SendKeys "%^{F9}", True    ' ctrl-alt-f9

For information on XL97 Recalculation patch for SR-1 see
  http://support.microsoft.com/support/kb/articles/Q174/8/68.ASP
problem was corrected in XL97 SR-2.

Q224183 - XL2000: Certain Functions Calculate Differently in Early Versions of Excel
  http://support.microsoft.com/support/kb/articles/Q224/1/83.ASP
Summary: When you use certain functions, you may receive a different value depending on the version of Microsoft Excel that you are using.

CalculateFull Method Example
  http://msdn.microsoft.com/library/officedev/off2000/xlmthcalculatefullx.htm
Summary: MSDN Library - Office Developer Documentation - Office 2000. Excerpt: CalculateFull Method Example This example compares the version of Microsoft Excel with the version of Excel that the workbook was last calculated in.

Auto_Open set to guarantee Calculation is turned on

I had trouble with Recalculation being turned off that I put code into Auto_Open to fix it.  Turned out that it was an Addin that I wasn't even using that was causing this.

    Sub auto_open()
      If Application.Calculation <> -4105 Then
         '-4105 automatic, -4135 manual, 2 semi-automatic
         MsgBox Application.Calculation & "  " & _
            ActiveWorkbook.FullName
         Application.Calculation = xlAutomatic
         MsgBox Application.Calculation
      End IF
    End Sub

Some shortcut techniques, evidently not considered shortcuts

Moving a group of rows or columns to another location

On the worksheet you can, select the row(s) to be moved then Hold the SHIFT key and grab the upper or lower boundary with the left mouse key and drag to between the rows you want to move it to.  Similar for columns instead.

I guess this is not considered a shortcut, and theses tips are not easily shown in the above table.  You will find it in Excel HELP (F1) --> index --> move --> move or copy cells

Important Excel 2000 keys picked by MSDN (Microsoft Developer Network)

	B	C
18	Excel 2000 Shortcut keys in --       http://office.microsoft.com/downloads/2000/O2kkeys.aspx
19	Activity	Shortcut Keys
20	Alternate between displaying cell values and displaying cell formulas	CTRL+` (single left quotation mark)
21	Calculate all sheets in all open workbooks	F9
22	Calculate the active worksheet	SHIFT+F9
23	Copy	CTRL+C
24	Create a chart that uses the current range	F11 or ALT+F1
25	Display the Format Cells dialog box	CTRL+1
26	Display the Go To dialog box	F5
27	Fill the selected cell range with the current entry	CTRL+ENTER
28	Insert the current time	CTRL+:
29	Insert today's date	CTRL+;
30	Move to the beginning of the worksheet	CTRL+HOME
31	Move to the last cell on the worksheet, which is the cell at the intersection of the  rightmost used column and the bottommost used row (in the lower-right corner), or  the cell  opposite the home cell, which is typically A1	CTRL+END
32	Open	CTRL+O
33	Paste	CTRL+V
34	Paste a function into a formula	SHIFT+F3
35	Print	CTRL+P
36	Save	CTRL+S
37	Select all (when you are not entering or editing a formula)	CTRL+A
38	Select the current column	CTRL+SPACEBAR
39	Select the current row	SHIFT+SPACEBAR
40	Undo	CTRL+Z
41	When you enter a formula, display the Formula Palette after you type a  function  name	CTRL+A

Some Interesting Web Searches

• excel icons paste special values

Using the HELP files with your Excel Software

HELP files at Microsoft in HTML universally available

It can be a bit confusing that MS maintains the same information in various web pages and is continually changing the names of those web pages, so I will include some of the multiple places, specifically note some begin with www, some with office, and some with support.
  http://www.microsoft.com/office/techinfo/productdoc/default.htm
  http://support.microsoft.com/support/Office/InProdHlp/contents/Excel/tocxldefault.asp

Excel 2000,  Excel 2002

Once you get the specific HELP file you want you should notice some buttons from left to right.  TOC only, TOC and topics, Topic only; Specific URL (for bookmarking); Show all[/hide all] topics.

Excel HELP information at Microsoft

Excel 2000 Shortcut keys: 
    http://www.microsoft.com/office/techinfo/productdoc/2000/en/excel/xlrefUsingshortcutkeys.htm [former link]
    http://office.microsoft.com/assistance/offhelp/off2000/excel/ -- as seen on 2002-02-10
Excel 2002 Shortcut keys:  http://office.microsoft.com/assistance/offhelp/offxp/excel/default.asp?URL=/assistance/offhelp/offxp/excel/xlmain10/html/xlrefUsingshortcutkeys.htm
-- valid 2002-02-10 but script is broken they just can't get web pages to work properly
 
Excel 2000 Specification:  [What's New] http://www.microsoft.com/office/techinfo/productdoc/2000/en/excel/xldecMicrosoftExcelSpecifications.htm
Excel 2002 Specification:  [What's New]
  http://www.microsoft.com/office/techinfo/productdoc/2002/en/excel/xlrefChartingSpecifications.htm

Related Information

Working with disabilities / accessibility options:  Some documentation found in the Microsoft Knowledge DataBase (MS KB) for Windows 2000 looking for disabilities & mouse turns up some items of interest.

Toolbar menus.  One way to learn most of the important features in Excel or any other software is to become familiar with each of the items in the menus.  Microsoft Excel 97 Menus « provides a description of each menu item. 

Move a Column or Row techniques can be found on the Fill Handle page under topic: Use of Mouse and keys to move, and insert rows or columns.

Navigating within a Sheet

Information from Microsoft

• Description of Windows 2000 Magnifier and Utility Manager Tools
• Microsoft Accessibility Home, information on working with disability, including visual disabilities (impaired, impairment, sight).
  Accessibility:   [Features]  [Index]  [Newsletter]  [Search]  [Products]
• Keyboard Assistance Shortcuts for Win95, Win98, WinNT, choose the Word (.doc) version.  Keyboard Assistance -- Search
• Also see Excel Help (or the Help in any Office Product), answer wizard:  Accessibility for people with disabilities.

• IBM Accessibility Center --
     [Search tips] - "Phrases" plus(+) minus(-),
     [Laws]  [Learning Disabilities]
• Macintosh (Apple) Disability Solutions

Not listed as Accessibility, but appears to fit in category

• Hands Free browser, free Edumedia, adware.  Requirements:  IE (not Netscape), microphone, etc.  Uninstalled after it showed lots and lots of advertising and offered to (or if you accidentally) click to put all your bookmarks onto their site.  NO THANKS!!! Uninstalled and removed DLL's.  Also having seen the ADVERTxxx.DLL's, I also uninstalled WINAMP and I can now work with my own pages on my own disk quickly once more.  You can probably safely use Dragon Naturally Speaking to do hands free web browsing.

How to install/use a macro can be found on my formula page.

How to install toolbar buttons can be found on throughout my Toolbars, Custom Buttons and Menus page.

Worksheet Function names, where to find lists of and examples of usage.

Utilities related to Shortcut Keys and Toolbars

• ASAP Utilities v2.98b [955kb] W9x/NT/2K FREE « [screen shots]
  ASAP Utilities is a set of over 200 Excel 97/2000 add-ins that will revolutionize the way you and your users interact with data.  Everything from formatting text and cells to handling sheets and selections is included and the installation is as simple as pointing the way to the add-in file (.XLA) included in the package [2001-04-11 GnomeREPORT].
• ShortKeys Lite [free], limited to 35 short cuts.

Keyboard things, other than shortcuts

• NumLK, Num Lk, Number Lock key toggled in code.

Additional Shortcut Information «

Please send your comments concerning this web page to: David McRitchie mailto:DMcRitchie@msn.com.