Microsoft Access 2000 keyboard shortcuts

List of shortcut keys for Microsoft Access 2000 keyboard shortcuts

Microsoft Access 2000 file menu keyboard shortcuts keys

Shortcut	Command
ALT	Close the visible menu and submenu at the same time; works with menu commands.
ALT+ letter key, where key is the underlined letter in the field or menu cmnd	Select a menu or select or clear the check box by the letter underlined in the menu command; works within windows and dialog boxes.
ALT 1	Go to previous folder; use within the Open, File New Database and Export dialog boxes in Microsoft Access.
ALT+2	Open the folder one level up from the open folder (Up One Level button); use within the Open, File New Database and Export dialog boxes.
ALT+3	Close the open dialog box and opens your World Wide Web search page (Search the Web button); use when working in the Open, File New Database and Export dialog boxes.
ALT+4	Delete the selected folder or file; use within the Open, File New Database and Export dialog boxes.
ALT+5	Create a new subfolder in the open folder; use within the Open, File New Database and Export dialog boxes.
ALT+6	Switch between List, Details, Properties, and Preview views (click the arrow next to Views); use within the Open, File New Database and Export dialog boxes.
ALT 7	Display the Tools menu; use within the Open, File New Database and Export dialog boxes in Microsoft Access.
ALT+A	Open Answer Wizard (In Help menu); use within Help menu.
ALT+A and ENTER	Use from the field list to add table and fields to the data access page when working in Design view.
CTRL+SHFT+RIGHT ARROW	Select or unselect one word to the right of the cursor.
CTRL SHFT TAB	Exit the subform and move to the previous field in the main form or previous record in Microsoft Access.
CTRL+SHFT+F8+LEFT ARROW	Activate Move mode; then press the LEFT ARROW key to move selected columns to the left.
CTRL SHFT TAB	Go to the previous tab when working in Help dialog box in Microsoft Access.
CTRL+SHFT+TAB	Exit the subdatasheet and move to the first field of the following record in the datasheet.
CTRL+SHFT+TAB or CTRL+PAGE UP	Go to the previous tab when working in a tabbed dialog box.
CTRL SHFT UP ARROW	Collapse the subdatasheet in Microsoft Access.
ALT+C	Display Contents dialog box; use within Help menu.
ALT+DOWN ARROW	Display more Help topics; works when using Office Assistant.
ALT+DOWN ARROW	Expand a list inside a table while working in a Database Diagram.
ALT+DOWN ARROW	Open a selected drop-down menu; works within a dialog box.
ALT+ENTER	Display the properties of a selected item while working in a window.
ALT ENTER	Display the PivotTable Property Toolbar in Microsoft Access.
ALT+F+D+A	Send the active database object as an E-Mail message.
ALT+F11	Switch between the Visual Basic Editor and the previous window; works within a window.
ALT+F4	Quit Microsoft Access, close a dialog box, or close a property sheet; works within an open window.
ALT F4	Close the active Help window in Microsoft Access.
ALT+F4	Close the PivotTable Property Toolbar.
ALT I	Switch to Index tab while working in Help menu in Microsoft Access.
ALT+K	Check the names in the To, Cc and Bcc fields against the Address Book while sending an E-Mail.
ALT LEFT ARROW	Go to a previously viewed Help topic in Microsoft Access.
ALT+N	Create a new table, query, form, report, data access page, macro, or module when working with a database or spreadsheet.
ALT+number	Select a Help topic while using Office Assistant. (where hitting key for 1 selects the leftmost option, 2 the next, and so on)
ALT+O	Display Options dialog box (in Help menu).
ALT+PAGE DOWN	Display the next screen to the right while working within Pivot Table Wizard.
ALT+PAGE UP	Display the previous screen to the left while working within Pivot Table Wizard.
ALT RIGHT ARROW	Go to a previously viewed a Help topic while in the Help dialog box in Microsoft Access.
ALT+SHFT+F11	Move between the Microsoft Script Editor window and the previous window.
ALT+SHFT+TAB	Move from active application window to previously active application window.
ALT+SPACEBAR	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	Display the Control menu while working from Help menu.
ALT SPACEBAR	Display the Control menu while working from Help menu in Microsoft Access.
ALT+TAB	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+UP ARROW	Display previously viewed Help topics while using Office Assistant.
CTRL+SHFT+B	Open the Address Book when sending an E-Mail.
CTRL SHFT DOWN ARROW	Expand a record's subdatasheet from the datasheet in Microsoft Access.
CTRL+SHFT+F6	Go to the previous database window.
CTRL+SHFT+F8+RIGHT ARROW	Activate Move mode; then press the RIGHT ARROW key to move selected columns to the right.
CTRL+SHFT+LEFT ARROW	Select or unselect one word to the left of the cursor.
CTRL+SHFT+LEFT ARROW	To extend selection one word to the left.
CTRL+SPACEBAR	Select or unselect the active column, in Navigation mode only.
CTRL+SPACEBAR	Select an entire grid column while navigating in the Query Designer - Grid Panes mode.
CTRL SPACEBAR	Select the field for the currently selected item of data, total or detail cell when working in a Pivot Table list in Microsoft Access.
CTRL+TAB	Move through the tabs of each object's type when navigating and opening objects in Access.
CTRL+TAB	Exit the subform and move to the next field in the master form or next record when working in Form view.
CTRL+TAB	Move to the next tab on a tabbed, Help dialog box.
CTRL+TAB	Exit the subdatasheet and move to the last field of the previous record in the datasheet.
CTRL+TAB or CTRL+PAGE DOWN	Move to the next tab on a tabbed dialog box.
CTRL TAB or CTRL SHFT TAB	Select the next or previous toolbar in Microsoft Access.
CTRL+UP ARROW	Move to the current field in the first record, in Navigation mode.
CTRL+UP ARROW	Move to the top of the active page when working in Access Print Preview and Layout Preview mode.
CTRL+UP ARROW	Move the selected control up when working in Access Form and Report Design view.
CTRL+UP ARROW	Move to the first row in the current column when working in Access Query Designer -Grid Panes mode.
CTRL+UP ARROW	Move the selected control up by a pixel (regardless of the page's grid) when working in Access Design view.
CTRL+V	Paste a copied item(s) from the Clipboard into a selected location (You also can choose Paste from the Edit menu.).
CTRL V	Paste the contents of the Clipboard in the upper-left corner of the selected section when working in Form and Report Design view in Microsoft Access.
CTRL+V	Paste a copied item(s) from the Clipboard into a selected location when working in Query Designer-Grid Panes (You also can choose Paste from the Edit menu.).
CTRL+V	Paste a copied item(s) from the Clipboard into a selected location when working in dat access page Design view (You also can choose Paste from the Edit menu).
CTRL+W or CTRL+F4	Close the active datasheet window.
CTRL+X	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+Z or ALT+BACKSPACE	Undo the last action; note: some actions, like Shutdown, cannot be undone (You also can choose Undo from the Edit menu.).
DELETE	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	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.
DOWN ARROW	To move down one line in a Combo box, list box or Database window in Microsoft Access.
DOWN ARROW	Move to the same field in the next record when navigating in Access Datasheet view.
DOWN ARROW	Scroll down a window or document in small increments when working in Access Print Preview or Layout Preview.
DOWN ARROW	Select the next book or Help topic in Microsoft Access.
DOWN ARROW	Scroll toward the end of a Help topic.
DOWN ARROW	Scroll through the items in a drop-down list, moving from top to bottom.
DOWN ARROW	Use when starting from the datasheet in order to bypass the subdatasheet and move to the next record in the datasheet.
DOWN ARROW or UP ARROW (with the menu or submenu displayed)	Select the next or previous command on the menu or submenu.
END	Go to the end of the entry when editing a text box.
END	Go to the last object in database window in Microsoft Access.
END	Go to the end of the field, in single-line fields.
END	Go to the last field in the current record, when working in Access Navigation mode.
END	Go to the end of a Help topic.
END	Go to the last cell in the row or to the end of the active cell.
END OR CTRL+RIGHT ARROW	Move to the right edge of the page when working in Access Print Preview and Layout Preview.
ENTER	Perform the action assigned to the selected default button in a dialog box.
ENTER	Restore a selected minimized program window when all windows are minimized.
ENTER	Open the selected table or query in Datasheet view, or form in Form view.
ENTER	Open the selected report in Print Preview in Microsoft Access.
ENTER	Run a selected macro.
ENTER	Open the selected data access page in Page Preview.
ENTER	Open or close a selected book, or open a selected Help topic.
ENTER	Activate a selected hyperlink in Microsoft Access.
ENTER	Move from a table's title bar to the last cell edited in a Database Diagram.
ENTER	Select an item in a list and move to the next cell in a Database Diagram.
ENTER	Perform the action assigned to a selected button on a toolbar.
ENTER	Open a selected menu on a toolbar.
ENTER	Enter text in a selected text box.
ENTER or ALT+O	Open the selected table or query in Datasheet view, or form in Form view.
ESC	Close the visible menu; or, with a submenu visible, close the submenu only.
ESC	Cancel a command and close the dialog box in Microsoft Access.
ESC	Close an Office Assistant message or tip.
ESC	Cancel Extend mode command.
ESC	Undo changes in the current field or current record; if both have been changed, press ESC twice to undo changes first in the current field and then in the current record.
ESC	Close a pop-up window in Help in Microsoft Access.
ESC	Move from a table cell to the table's title bar when working in database Diagram.
ESC	Close a shortcut menu without carrying out a command when working in a Pivot Table.
ESC	Cancel a Refresh command in progress when working in a Pivot Table.
ESC (when a drop-down list box is selected)	Close a selected drop-down list in a dialog box.
F1	Display Help or the Office Assistant in Microsoft Access.
F1	Display the Office Assistant or Microsoft Access Contents and Index; context-sensitive help about the selected property, control, macro action, or Visual Basic keyword; or alerts with a Help button.
F1	Display Help topics when working in a Pivot Table.
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
F11 or ALT+F1	Bring the Database window to the front.
F12 or ALT+F2	Display Save As dialog box (file menu).
F2	Display the complete hyperlink address for a selected hyperlink.
F2	Rename a selected object when working in Database window.
F2	Move between Edit mode (with insertion point displayed) and Navigation mode when working in Design view.
F2	Move between Edit mode and Cell Selection mode when navigating in the Query Designer -Grid Panes.
F4 or ALT+DOWN ARROW	Open a combo box.
F5	Update the files visible in the Open or Save As dialog box (File menu).
F5	Move to Form view from Form design or a Form module when working in Access Design view.
F5	Navigate through records by moving cursor to the record number box, typing the record number and pressing ENTER when working in Datasheet view.
F5	Navigate through records by moving cursor to the record number box, typing the record number and pressing ENTER when working in Form view.
F5	Navigate through pages by moving cursor to the page number box, typing the page number and pressing ENTER when working in Print Preview and Layout.
F5	Refresh the current window (You also can choose Refresh from the View menu.).
F5	Navigate in subdatasheet records by moving to the record number box, typing the record number and pressing ENTER.
F6	Move between the upper and lower portions of a window when working in Design view of tables, macros, and queries and the Advanced Filter/Sort window only.
F6	Move between the navigation pane and topic pane when working with Help menu in Microsoft Access.
F6,SHFT+F6	Use by pressing and then clicking anywhere in the target pane when navigating the Query Designer - Any Pane.
F7	Display Spelling and Grammar dialog box (Tools Menu).
F8	Activate Extend mode; EXT appears in the lower right corner of the window; pressing F8 repeatedly extends the selection to the word, the field, the record (in Datasheet view only), and all records; press ESC to cancel.
F9	Refresh the contents of a Lookup field list box or combo box.
F9	Recalculate the fields in the window in Microsoft Access.
F9	Refresh the PivotTable list from the source data.
HOME	Go to the beginning of the current entry.
HOME	Go to the first object.
HOME	Go to the beginning of the current field, in single-line fields.
HOME	Go to the first field in the current record, when in Access Navigation mode.
HOME	Go to the beginning of a Help topic, with Help dialog box open.
HOME	Go to the first cell in the row, or to the beginning of the current cell.
HOME or CTRL LEFT ARROW	Go to the left edge of the current page in Microsoft Access.
HOME or END	Select the first or last command on the menu or submenu.
INSERT	Toggle between insert and overstrike mode while editing a cell.
INSERT after you select any Or... column	Insert an Or... column when navigating the Access Query Designer - Grid Panes mode.
INSERT after you select grid row	Insert a row between existing rows when navigating the Access Query Designer - Grid Panes mode.
LEFT ARROW	Go one character to the left of the cursor's current position in the field.
LEFT ARROW	Scroll to the left of the cursor's current position in small increments when working in Print Preview and Layout Preview.
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	Extend a selection to adjacent fields in the same row in Microsoft Access Datasheet view.
LEFT or RIGHT ARROW	Select a button on the record navigation toolbar when working in Access Page View.
Letter key, where the letter is the same as the first letter in optn you want on a selected menu,	Choose a selected menu, drop-down list, or dialog box option by typing the first letter in the option name.
P or CTRL+P	To open the Print dialog box from Print Preview or Layout Preview.
PAGE DOWN	Move down one page when using a Combo box or list box.
PAGE DOWN	Move down one window when working in Database view in Microsoft Access.
PAGE DOWN	Scroll down one full screen when working in Print Preview and Layout Preview.
PAGE DOWN	Scroll toward the end of a Help topic in larger increments.
PAGE DOWN	When navigating a Database Diagram, scroll to the next page inside a table or the next page of the diagram.
PAGE DOWN	When working in a Pivot Table list, display the next screen.
PAGE DOWN	When navigating in Form view, go down one page; at the end of the record, moves to the equivalent page on the next record.
PAGE DOWN or DOWN ARROW	In Print Preview and Layout Preview, view the next page (when Fit To Window is selected).
PAGE UP	Move up one page when using a combo box or list box.
PAGE UP	Move up one window when working in Database.
PAGE UP	Go up one screen when working in Datasheet view in Microsoft Access.
PAGE UP	Go up one page when working in Form view; at the end of the record, use to move to the equivalent page on the previous record.
PAGE UP	Scroll up one full screen when working in Print Preview and Layout Preview.
PAGE UP	Scroll toward the beginning of a Help topic in larger increments.
PAGE UP	When navigating a Database diagram, scroll to the previous page inside a table or the previous page of the diagram.
PAGE UP	Display the previous screen when working with a Pivot Table list in Microsoft Access.
PAGE UP or UP ARROW	In Print Preview and Layout Preview, view the previous page (when Fit To Window is selected).
RIGHT ARROW	Move one character to the right of the cursor's current position in a field.
RIGHT ARROW	In Print Preview and Layout Preview, scroll to the right in small increments.
S	In Print Preview and Layout Preview, open the Page Setup dialog box.
SHFT+ARROW KEY	Extend or reduce a selection in a Pivot Table list, depending on the direction of the arrow key chosen.
SHFT+CTRL+TAB	Cycle through the tab of each object's type moving right to left.
SHFT DOWN ARROW	Extend selection to the next record, if the current record is selected in Microsoft Access.
SHFT+DOWN ARROW	Increase the height of the selected control when working in Form and Report Design view.
SHFT+END	Select from the insertion point to the end of the text box entry.
SHFT+ENTER	Add a control to a section when working in Form and Report Design view only.
SHFT+ENTER	Save changes to the current record when entering data in the Datasheet or Form view.
SHFT ENTER	Add a control to a section when working in data access page Design view in Microsoft Access.
SHFT+F1	Display What's This? help; after pressing SHFT+F1, move the pointer to the menu command, toolbar button, dialog box option, or screen region to see definitions.
SHFT+F10	Display a shortcut menu that shows a list of commands relevant to the selected object.
SHFT+F10	Display a shortcut menu that shows a list of commands relevant to the selected object.
SHFT+F10	Display the shortcut menu for the selected element of the PivotTable list.
SHFT+F2	Open the Zoom box to conveniently enter expressions and other text in small input areas.
SHFT+F4	Find the previous occurrence of the text specified in the Find or Replace dialog box when the dialog box is closed.
SHFT F8	Undo a previous selection extension in Microsoft Access.
SHFT+F9	Requery the underlying tables; in a subform, this requeries the underlying table for the subform only.
SHFT+HOME	Select from the insertion point in the text box to the beginning of the text box entry.
SHFT+LEFT ARROW	Select or unselect one character to the left of the cursor's position.
SHFT+LEFT ARROW	Reduce the width of the selected control when working in Form an Report Design view.
SHFT+LEFT ARROW	Select the column to the left, if the current column is selected, when working in Datasheet view.
SHFT+PAGE DOWN	Extend the selection one screen down.
SHFT PAGE UP	Reduce a selection by one screen when working with a Pivot Table list in Microsoft Access.
SHFT+RIGHT ARROW	Select or unselect by one character to the right of the cursor's current position.
SHFT+RIGHT ARROW	Increase the width of the selected control when working in Form and Report Design view.
SHFT+RIGHT ARROW	Select the column to the right, if the current column is selected, when working in Datasheet view.
SHFT+SPACEBAR	Switch between selecting the current record and the first field of the current record, when working in Navigation mode.
SHFT+SPACEBAR	Select the entire row containing the currently selected cell when working in a Pivot Table list.
SHFT TAB	Move to the previous option or option group in a dialog box in Microsoft Access.
SHFT+TAB	Move to the previous field when navigating in Form view.
SHFT+TAB	Enter the subform from the following field in the main form when navigating in Form view.
SHFT+TAB	Go to the last or previous hyperlink in Help.
SHFT+TAB	Select the previous field or button in the E-Mail header.
SHFT+TAB	Enter the subdatasheet from the first field of the following record in the datasheet.
SHFT+TAB	Select the previous field or the entire Pivot Table list.
SHFT+TAB, or LEFT ARROW	Move to the previous field when navigating in Datasheet view.
SHFT UP ARROW	Extend selection to the previous record, if the current record is selected in Microsoft Access.
SHFT+UP ARROW	Reduce the height of the selected control when working in Form and Report Design view.
SPACE or ENTER	Expand or collapse a group of records corresponding to the expand indicator in a grouped data access page.
SPACE or ENTER	Activate the selected button on the record navigation toolbar when working in Page view.
SPACEBAR	Perform the action assigned to the active button, or select or clear the active check box in the dialog box.
SPACEBAR	Switch between the values in a check box or option button.
SPACEBAR	Change the setting in a check box when navigating a Database Diagram in Microsoft Access.
SPACEBAR	Toggle the check box in the Output column when navigating the Query Designer-Grid Panes.
SPACEBAR or MINUS SIGN	Remove the selected data column form the query output when navigating the Query Designer-Diagram Pane.
SPACEBAR or PLUS SIGN	Choose the selected data column form the query output when navigating the Query Designer-Diagram Pane.
TAB	Move to the next option or option group in a dialog box.
TAB	Exit the combo box or list box.
TAB	Select the next field in Microsoft Access.
TAB	Move to the next field when working in Form view.
TAB	To enter the subform from the preceding field in the main form when working in Form view.
TAB	Go to the first or next hyperlink in Help.
TAB	Select the next box in the E-Mail header, or the body of the message when the last box in the E-Mail header is active.
TAB	Move from table title bar to table title bar, or from cell to cell inside a table, when navigating a Database Diagram.
TAB	Enter the subdatasheet from the last field of the previous record in the datasheet in Microsoft Access.
TAB	Move from the last field in the subdatasheet to the next field in the datasheet.
TAB	Select each field and then the entire Pivot Table list, going through these selections in sequence.
TAB or SHFT+TAB (when a toolbar is active)	When a toolbar is active, select the next or previous button or menu on the toolbar.
TAB, ENTER, or RIGHT ARROW	Move to the next field when navigating in Datasheet view in Microsoft Access.
TAB, SHFT+TAB	Move between input source windows (and to join lines, if available) when navigating the Query Designer-Diagram Pane.
LETTER KEY, where the key corresponds with the underlined letter in an optn name	Select and choose a command on the shortcut menu when working in a Pivot table.
UP ARROW	Move up one line in a combo box or list box.
UP ARROW	Move up one line in a database window.
UP ARROW	Move to the current field in the previous record when navigating in Datasheet view.
UP ARROW	Scroll up in small increments when working in Print Preview and Layout Preview.
UP ARROW	Select the previous book or topic in Help in Microsoft Access.
UP ARROW	Scroll toward the beginning of a Help topic.
UP ARROW	Move to the previous item in a list when navigating in a Database Diagram.
UP ARROW	Use from the datasheet to bypass the subdatasheet and move to the previous record in the datasheet.
UP ARROW or DOWN ARROW	Move up or down in a drop-down list when navigating the Query Designer - Grid Panes in Microsoft Access.
UP ARROW, DOWN ARROW	Extend a selection to adjacent rows in Datasheet view.
Z	Zoom in or out on a part of the page when working in Print Preview and Layout Preview.
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 columns in an input source window when working in the Query Designer-Diagram Pane.
ARROW KEY	Move selected elements in the given direction of the arrow key while working within a Pivot Table.
ARROW KEYS or TAB or SHFT TAB	Move between cells when working in the Query Designer-Diagram Pane in Microsoft Access.
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.
BACKSPACE	Delete selected text or to delete the character to the left of where the cursor is positioned within a document while editing.
C or ESC	Cancel Print Preview or Layout Preview and return to Normal view.
CTRL+7	Display or hide the main toolbar of the active window.
CTRL+A	Select the entire Help topic when working in the Help menu or dialog box.
CTRL A	Select the entire active Pivot Table list in Microsoft Access.
CTRL+A or CTRL+SHFT+SPACEBAR	Select all records in an active database.
CTRL+ALT+SPACEBAR	Insert the default value for a selected field when entering data in a Datasheet or Form view.
CTRL+APOSTROPHE (')	Insert the value from the same field in the previous record to the selected field in the current record within a database.
CTRL C	Copy selection to the Windows Clipboard in Microsoft Access.
CTRL+C	Copy the selected control to the Windows Clipboard.
CTRL+C	Copy the selected Help items to the Windows Clipboard when working in Help menu.
CTRL+C	Copy selected text to the Windows Clipboard when working in the Query Designer - Grid Panes.
CTRL C	Copy selected text to the Windows Clipboard when working in Design View in Microsoft Access.
CTRL+C	Copy selected data from the Pivot Table list to the Windows Clipboard when working in a Pivot Table.
CTRL+COLON (:)	Insert the current time at the cursor's current position.
CTRL+DELETE	Delete text to the end of the line in which the cursor is positioned.
CTRL+DOWN ARROW	Move to the same field in the last record while in Navigation mode in Datasheet view.
CTRL+DOWN ARROW	Move to the bottom of current page in which you are working while in Print Preview and Layout Preview.
CTRL DOWN ARROW	Move the selected control down in the presentation while in Form and Report Design view in Microsoft Access.
CTRL+DOWN ARROW	Move to the last row in the current column while working in Query Designer-Grid Panes mode.
CTRL+DOWN ARROW	Move the selected control down by a pixel (irrespective of the page's grid) while working in Data Access page in Design View.
CTRL E	Export the selected Pivot Table list to a Microsoft Excel document in Microsoft Access.
CTRL+END	Move to the end of the active field, while working working with multiple-line fields in Access.
CTRL+END	Move to the last field in the last record while in Navigation mode in Access.
CTRL+END	To move to the last field in the last record while in Navigation mode and Form view in Access.
CTRL+END	Move to the lower-right corner of the page while working in Print Preview and Layout Preview.
CTRL+END	Move to the last position in the current cell or the last column in the active window while in Query Designer - Grid Panes view in Access.
CTRL ENTER	Insert a new line when entering data in Datasheet or Form view in Microsoft Access.
CTRL+ENTER or ALT+D	To open the selected table, query, form, report, macro, or module while working in Design view in Access.
CTRL+ESC	Display Windows Start menu.
CTRL+F	Display the Find dialog box while working in Access Datasheet view, Form view or Module Window only.
CTRL+F11	Toggle between a custom menu bar and a built-in menu bar while working in Access.
CTRL F2	Invoke a Builder while working in Microsoft Access.
CTRL+F6	Go to the next database window in the active application.
CTRL F6	Move between open windows in Microsoft Access.
CTRL+F8	Activate Resize mode for the active window when it is not maximized; press the arrow keys ro resize the window.
CTRL+G	Display the Immediate window in the Visual Basic Editor.
CTRL+H	To open the Replace dialog box (while in Datasheet view, Form view, and Module Window only).
CTRL+HOME	Go to the beginning of the field, in multiple-line fields, when workin in Access.
CTRL+HOME	Go to the first field in the first record when working in Navigation mode in Datasheet view.
CTRL+HOME	Go to the first field in the first record when working in Navigation mode in Form view.
CTRL+HOME	Go to the upper-left corner of the page when in Print Preview and layout Preview mode.
CTRL+HOME	Go to the first position in the active cell or the first column in the active window when working in the Query Designer -Grid Panes.
CTRL LEFT ARROW	Move cursor's position one word to the left in Microsoft Access.
CTRL+LEFT ARROW	Move the selected control to the left when working in Form and Report Design view.
CTRL+LEFT ARROW	Move the selected control to the left by one pixel (irrespective of the page's grid) when working in data access page Design view.
CTRL+LEFT ARROW or CTRL+RIGHT ARROW	Move cursor's position one word to the left or right.
CTRL+MINUS SIGN (-)	Delete the current record when working in Datasheet or Form view.
CTRL N	Open a new, blank, database in Microsoft Access.
CTRL+O	Display the Open dialog box in order to find and open an existing database.
CTRL+P	Display the Print dialog box in order to print the active selection.
CTRL+P	Print the active Help topic.
CTRL+PAGE DOWN	Go right one screen.
CTRL PAGE DOWN	Go to the same field in the next record in Microsoft Access.
CTRL+PAGE UP	Go left one screen when working in datasheet view in Access.
CTRL+PAGE UP	Go to the same field in the previous record.
CTRL+PLUS SIGN (+)	Add a new record while working in Datasheet or Form view in Access.
CTRL+RIGHT ARROW	Move cursor one word to the right.
CTRL+RIGHT ARROW	Move the selected control to the right when editing controls in Form and Report Design view.
CTRL+RIGHT ARROW	Move the selected control to the right by a pixel (irrespective of the page's grid) when working in data access page Design view.
CTRL S or SHFT F12 or ALT SHFT F2	Save a database object in Microsoft Access.
CTRL+SEMICOLON (;)	Insert the current date into active Datasheet or Form view.

Microsoft Money 2003 keyboard shortcuts

List of shortcut keys for Microsoft Money 2003.Navigation keyboard shortcuts keys,Main Sections keyboard shortcuts keys,Money Browser keyboard shortcuts keys,Accounts & Bills keyboard shortcuts keys,File commands keyboard shortcuts keys,Editing keyboard shortcuts keys,Navigation keyboard shortcuts keys

Microsoft Money 2003 Navigation keyboard shortcuts keys Shortcut                                                               Command
ALT + RIGHT ARROW	Forward
ALT + LEFT ARROW	Back
ALT + HOME	My Money Home page

Microsoft Money 2003 Main Sections keyboard shortcuts keys Shortcut                                                            Command
CTRL + SHFT + A	Accounts List
CTRL + SHFT + B	Bills & Deposits List
CTRL + SHFT + C	Categories & Payees List
CTRL + SHFT + I	Investment Portfolio
CTRL + SHFT + P	Lifetime Planner
CTRL + SHFT + T	Tax Estimator
CTRL + SHFT + R	Reports Gallery
CTRL + SHFT + W	Web browser

Microsoft Money 2003 Money Browser keyboard shortcuts keys Shortcut                      Command
F5	Refresh the Money browser
F11	Launch Internet Explorer

Microsoft Money 2003 Accounts & Bills keyboard shortcuts keys Shortcut                                                     Command
CRTL + F	Find a transaction/td>
F3 or CRTL + H	Find and replace
CRTL + D	Insert today's date in the date field
PLUS SIGN (+)	Increase date by one day
MINUS SIGN (-)	Decrease date by one day
CRTL + S	Split a transaction
CRTL + M	Mark transaction cleared (C)
CTRL+SHFT+M	Mark transaction reconciled (R)
ESC	Cancel changes
CRTL + Z	Undo delete in account register

Microsoft Money 2003 File commands keyboard shortcuts keys Shortcut                                                     Command
CRTL + O	Open file
CRTL + N	Create a new file

Microsoft Money 2003 Editing keyboard shortcuts keys Shortcut                                                                                Command
CRTL + C or CRTL + INSERT	Copy
CRTL + X	Cut
CRTL + V or SHFT + INSERT	Paste
CRTL + Z or ALT + BACKSPACE	Undo last entry

Microsoft Money 2003 Navigation keyboard shortcuts keys Shortcut                                                 Command
F1	Help
CRTL + P	Print
CTRL + K	Calculator
ALT + F4	Close Money

Microsoft Excel 2000 keyboard shortcuts

List of shortcut keys for Microsoft Excel 2000

Microsoft Excel 2000 File menu keyboard shortcuts keys

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