|
You can use shortcut keys for quick access to
frequently used commands or operations. The topics below
list the shortcut keys available in Microsoft Access.
You can also use access keys to move the focus to a
menu, command, or control without using the mouse.
General shortcut keys
 Global
Access shortcut keys
Opening
databases
| To do this |
Press |
|
To open a new database
|
CTRL+N
|
|
To open an existing database
|
CTRL+O
|
|
To quit Microsoft Access
|
ALT+F4
|
Printing
and saving
| To do this |
Press |
|
To print the current or selected object
|
CTRL+P
|
|
To open the Print
dialog box
|
P or CTRL+P
|
|
To open the Page Setup
dialog box
|
S
|
|
To cancel Print Preview or Layout Preview
|
C or ESC
|
|
To save a database object
|
CTRL+S or SHIFT+F12 or ALT+SHIFT+F2
|
|
To open the Save As
dialog box
|
F12 or ALT+F2
|
Finding
and replacing text or data
| To do this |
Press |
|
To open the Find tab in
the Find and Replace
dialog box (Datasheet view and Form view
only)
|
CTRL+F
|
|
To open the Replace tab
in the Find and Replace
dialog box (Datasheet view and Form view
only)
|
CTRL+H
|
|
To find the next occurrence of the text
specified in the Find and
Replace dialog box when the dialog box
is closed (Datasheet view and Form view
only)
|
SHIFT+F4
|
Editing
controls in form and report Design view
| To do this |
Press |
|
To add a control to a section
|
SHIFT+ENTER
|
|
To copy the selected control to the
Clipboard
|
CTRL+C
|
|
To cut the selected control and copy it
to the Clipboard
|
CTRL+X
|
|
To paste the contents of the Clipboard in
the upper-left corner of the selected
section
|
CTRL+V
|
|
To move the selected control to the right
|
CTRL+RIGHT ARROW
|
|
To move the selected control to the left
|
CTRL+LEFT ARROW
|
|
To move the selected control up
|
CTRL+UP ARROW
|
|
To move the selected control down
|
CTRL+DOWN ARROW
|
|
To increase the height of the selected
control
|
SHIFT+DOWN ARROW
|
|
To increase the width of the selected
control
|
SHIFT+RIGHT ARROW
|
|
To reduce the height of the selected
control
|
SHIFT+UP ARROW
|
|
To reduce the width of the selected
control
|
SHIFT+LEFT ARROW
|
Window
operations
| To do this |
Press |
|
To bring the Database window to the front
|
F11
|
|
To cycle between open windows
|
CTRL+F6
|
|
To restore the selected minimized window
when all windows are minimized
|
ENTER
|
|
To turn on Resize mode for the active
window when it’s not maximized; press the
arrow keys to resize the window
|
CTRL+F8
|
|
To display the Control menu
|
ALT+SPACEBAR
|
|
To display the shortcut menu
|
SHIFT+F10
|
|
To close the active window
|
CTRL+W or CTRL+F4
|
|
To switch between the Visual Basic Editor
and the previous active window
|
ALT+F11
|
|
To switch to the Microsoft Script Editor
from the previous active window
|
ALT+SHIFT+F11
|
Working
with Wizards
| To do this |
Press |
|
Move to the Help
button in the wizard
|
TAB
|
|
To move to the next window in the wizard
|
ALT+N
|
|
To move to the previous window in the
wizard
|
ALT+B
|
|
To close the wizard window
|
ALT+F
|
Note You can not use
CTRL+TAB to navigate from one wizard window to
another. CTRL+TAB will move the
cursor between dialog boxes and controls on the
wizard window.
Miscellaneous
| To do this |
Press |
|
To display the complete hyperlink address
for a selected hyperlink
|
F2
|
|
To check spelling
|
F7
|
|
To open the Zoom box to conveniently
enter expressions and other text in small
input areas
|
SHIFT+F2
|
|
To display a property sheet in Design
view
|
ALT+ENTER
|
|
To quit Microsoft Access, close a dialog
box, or close a property sheet
|
ALT+F4
|
|
To invoke a Builder
|
CTRL+F2
|
|
To toggle between a custom menu bar and a
built-in menu bar
|
CTRL+F11
|
|
To toggle forward between views when in a
table, query, form, report, page, view ,
PivotTable list, PivotChart report, stored
procedure, or Access project (.adp)
function. If there are additional views
available, successive keystrokes will move
to the next available view.
|
CTRL+RIGHT ARROW or CRTL+COMMA (,)
|
|
To toggle back between views when in a
table, query, form, report, page, view,
PivotTable list, PivotChart report, stored
procedure, or .adp function. If there are
additional views available, successive
keystrokes will move to the previous view
|
CTRL+LEFT ARROW or CRTL+PERIOD (.)
|
Database
window shortcut keys
Editing
and navigating the Object list
| To do this |
Press |
|
To rename a selected object
|
F2
|
|
To move down one line
|
DOWN ARROW
|
|
To move down one window
|
PAGE DOWN
|
|
To move to the last object
|
END
|
|
To move up one line
|
UP ARROW
|
|
To move up one window
|
PAGE UP
|
|
To move to the first object
|
HOME
|
Navigating
and opening objects
| To do this |
Press |
|
To cycle through the
Objects bar top to bottom
|
CTRL+TAB
|
|
To cycle through the
Objects bar bottom to top
|
SHIFT+CTRL+TAB
|
|
To open the selected table or query in
Datasheet view, or form in Form view
|
ENTER or ALT+O
|
|
To open the selected report in Print
Preview
|
ENTER
|
|
To open the selected data access page in
Page view
|
ENTER
|
|
To run the selected macro
|
ENTER
|
|
To open the selected table, query, form,
report, data access page, macro, or module
in Design view
|
CTRL+ENTER or ALT+D
|
|
To create a new table, query, form,
report, data access page, macro, or module
|
ALT+N
|
|
To refresh the Database window
|
F5
|
|
To display the Immediate window in the
Visual Basic Editor
|
CTRL+G
|
Work
with menus
| To do this |
Press |
|
To show the shortcut menu
|
SHIFT+F10
|
|
To make the menu bar active
|
F10
|
|
To show the program icon menu (on the program
title bar)
|
ALT+SPACEBAR
|
|
With the menu or submenu is visible, to
select the next or previous command
|
DOWN ARROW or UP ARROW
|
|
To select the menu to the left or right; or,
when a submenu is visible, to switch between the
main menu and the submenu
|
LEFT ARROW or RIGHT ARROW
|
|
To select the first or last command on the
menu or submenu
|
HOME or END
|
|
To close the visible menu and submenu at the
same time
|
ALT
|
|
To close the visible menu; or, with a submenu
visible, to close the submenu only
|
ESC
|
Work
with toolbars
| To do this |
Press |
|
To select the next or previous toolbar
|
CTRL+TAB or CTRL+SHIFT+TAB
|
|
When a toolbar is active, to select the next
or previous button or menu on the toolbar
|
TAB or SHIFT+TAB
|
|
When a menu on a toolbar is selected, to open
the menu
|
ENTER
|
|
When a button is selected, to perform the
action assigned to a button
|
ENTER
|
Work
in windows and dialog boxes
Using
a program window
| To do this |
Press |
|
To switch to the next program
|
ALT+TAB
|
|
To switch to the previous program
|
ALT+SHIFT+TAB
|
|
To show the Windows Start
menu
|
CTRL+ESC
|
|
To close the active database window
|
CTRL+W
|
|
To switch to the next database window
|
CTRL+F6
|
|
To switch to the previous database window
|
CTRL+SHIFT+F6
|
|
To restore the selected minimized window
when all windows are minimized
|
ENTER
|
Using
a dialog box
| To do this |
Press |
|
To switch to the next tab in a dialog box
|
CTRL+TAB or CTRL+PAGE DOWN
|
|
To switch to the previous tab in a dialog
box
|
CTRL+SHIFT+TAB or CTRL+PAGE UP
|
|
To move to the next option or option
group
|
TAB
|
|
To move to the previous option or option
group
|
SHIFT+TAB
|
|
To move between options in the selected
drop-down list box, or to move between some
options in a group of options
|
Arrow keys
|
|
To perform the action assigned to the
selected button; select or clear the check
box
|
SPACEBAR
|
|
To move to the option by the first letter
in the option name 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)
|
|
To select the option, or to select or
clear the check box by the letter underlined
in the option name
|
ALT+letter key
|
|
To open the selected drop-down list box
|
ALT+DOWN ARROW
|
|
To close the selected drop-down list box
|
ESC
|
|
To perform the action assigned to the
default button in the dialog box
|
ENTER
|
|
To cancel the command and close the
dialog box
|
ESC
|
|
To close a dialog box
|
ALT+F4
|
Editing
in a text box
| To do this |
Press |
|
To move to the beginning of the entry
|
HOME
|
|
To move to the end of the entry
|
END
|
|
To move one character to the left or
right
|
LEFT ARROW or RIGHT ARROW
|
|
To move one word to the left or right
|
CTRL+LEFT ARROW or CTRL+RIGHT ARROW
|
|
To select from the insertion point to the
beginning of the entry
|
SHIFT+HOME
|
|
To select from the insertion point to the
end of the entry
|
SHIFT+END
|
|
To select one character to the left
|
SHIFT+LEFT ARROW
|
|
To select one character to the right
|
SHIFT+RIGHT ARROW
|
|
To select one word to the left
|
CTRL+SHIFT+LEFT ARROW
|
|
To select one word to the right
|
CTRL+SHIFT+RIGHT ARROW
|
Work
with the Open, File New Database, and Save dialog boxes
| To do this |
Press |
|
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 WebWorld 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
|
Work
with task panes
Keyboard
shortcuts for using the Help task pane
and Help window
The Help Pane is a task pane that provides access to
all Office Help content. As a task pane, the Help Pane
appears as part of the active application. The Help
window displays topics and other Help content and
appears as a window next to, but separate from, the
active application.
In the Help task pane
| To do this |
Press |
|
Display the Help task pane.
|
F1
|
|
Switch between the Help
task pane and the active application.
|
F6
|
|
Select the next item in the
Help task pane.
|
TAB
|
|
Select the previous item in the
Help task pane.
|
SHIFT+TAB
|
|
Perform the action for the selected item.
|
ENTER
|
|
In a Table of Contents, select the next and
previous item, respectively.
|
DOWN ARROW and UP ARROW
|
|
In a Table of Contents, expand and collapse
the selected item, respectively.
|
RIGHT ARROW and LEFT ARROW
|
|
Move back to the previous task Pane.
|
ALT+LEFT ARROW
|
|
Move forward to the next task Pane.
|
ALT+RIGHT ARROW
|
|
Open the menu of Pane options.
|
CTRL+SPACEBAR
|
|
Close and reopen the current task pane.
|
CTRL+F1
|
|
Expand a +/- list.
|
RIGHT ARROW
|
|
Collapse a +/- list.
|
LEFT ARROW
|
In the Help window
| To do this |
Press |
|
Select the next hidden text or hyperlink, or
Show All or Hide
All at the top of a topic
|
TAB
|
|
Select the previous hidden text or hyperlink,
or the Browser View button at
the top of a Microsoft Office Web site article
|
SHIFT+TAB
|
|
Perform the action for the selected
Show All, Hide
All, hidden text, or hyperlink
|
ENTER
|
|
Move back to the previous Help topic.
|
ALT+LEFT ARROW
|
|
Move forward to the next Help topic.
|
ALT+RIGHT ARROW
|
|
Print the current Help topic.
|
CTRL+P
|
|
Scroll small amounts up and down,
respectively, within the currently-displayed
Help topic.
|
UP ARROW AND DOWN ARROW
|
|
Scroll larger amounts up and down,
respectively, within the currently-displayed
Help topic.
|
PAGE UP AND PAGE DOWN
|
|
Change whether the Help window appears
connected to (tiled) or separate from (untiled)
the active application.
|
ALT+U
|
|
Display a menu of commands for the Help
window; requires that the Help window have
active focus (click an item in the Help window).
|
SHIFT+F10
|
Send
e-mail messages
| To do this |
Press |
|
Send the active database object as an e-mail
message
|
ALT+F+D+A
|
|
Open the Address Book
|
CTRL+SHIFT+B
|
|
Check the names in the To,
Cc, and Bcc
boxes against the Address Book
|
ALT+K
|
|
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
|
|
Select the previous field or button in the
e-mail header
|
SHIFT+TAB
|
Keys for working with text and data
Select
text and data
Selecting
text in a field
| To do this |
Press |
|
To extend one character to the right
|
SHIFT+RIGHT ARROW
|
|
To extend one word to the right
|
CTRL+SHIFT+RIGHT ARROW
|
|
To extend one character to the left
|
SHIFT+LEFT ARROW
|
|
To extend one word to the left
|
CTRL+SHIFT+LEFT ARROW
|
Extending
a selection
| To do this |
Press |
|
To turn on 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
|
F8
|
|
To extend a selection to adjacent fields
in the same row in Datasheet view
|
LEFT ARROW or RIGHT ARROW
|
|
To extend a selection to adjacent rows in
Datasheet view
|
UP ARROW or DOWN ARROW
|
|
To undo the previous extension
|
SHIFT+F8
|
|
To cancel Extend mode
|
ESC
|
Edit
text and data
Note If the insertion point isn't visible,
press F2 to display it.
Moving
the insertion point in a field
| To do this |
Press |
|
To move it one character to the right
|
RIGHT ARROW
|
|
To move it one word to the right
|
CTRL+RIGHT ARROW
|
|
To move it one character to the left
|
LEFT ARROW
|
|
To move it one word to the left
|
CTRL+LEFT ARROW
|
|
To move it to the end of the field, in
single-line fields
|
END
|
|
To move it to the end of the field, in
multiple-line fields
|
CTRL+END
|
|
To move it to the beginning of the field,
in single-line fields
|
HOME
|
|
To move it to the beginning of the field,
in multiple-line fields
|
CTRL+HOME
|
Copying,
moving, or deleting text
| To do this |
Press |
|
To copy the selection to the Clipboard
|
CTRL+C
|
|
To cut the selection and copy it to the
Clipboard
|
CTRL+X
|
|
To paste the contents of the Clipboard at
the insertion point
|
CTRL+V
|
|
To delete the selection or the character
to the left of the insertion point
|
BACKSPACE
|
|
To delete the selection or the character
to the right of the insertion point
|
DELETE
|
|
To delete all characters to the right of
the insertion point
|
CTRL+DELETE
|
Undoing
changes
| To do this |
Press |
|
To undo typing
|
CTRL+Z or ALT+BACKSPACE
|
|
To 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
|
Entering
data in Datasheet or Form view
| To do this |
Press |
|
To insert the current date
|
CTRL+SEMICOLON (;)
|
|
To insert the current time
|
CTRL+SHIFT+COLON (:)
|
|
To insert the default value for a field
|
CTRL+ALT+SPACEBAR
|
|
To insert the value from the same field
in the previous record
|
CTRL+APOSTROPHE (')
|
|
To add a new record
|
CTRL+PLUS SIGN (+)
|
|
To delete the current record
|
CTRL+MINUS SIGN (-)
|
|
To save changes to the current record
|
SHIFT+ENTER
|
|
To switch between the values in a check
box or option button
|
SPACEBAR
|
|
To insert a new line
|
CTRL+ENTER
|
Keys for navigating records
Navigate
in Design view
| To do this |
Press |
|
To switch between Edit mode (with insertion
point displayed) and Navigation mode
|
F2
|
|
To switch to the property sheet (Design view
in forms and reports in databases and Access
projects)
|
F4
|
|
To switch to Form view from form Design view
|
F5
|
|
To switch between the upper and lower
portions of a window (Design view of the
Advanced Filter/Sort window only)
|
F6
|
|
To switch to the Code Builder from form or
report Design view (Design view window or
property sheet)
|
F7
|
|
Invokes the field list in a form, report , or
data access page. If field list is already open,
moves focus to field list
|
F8
|
|
To switch from the Visual Basic Editor to
form or report Design view
|
SHIFT+F7
|
|
To switch from a control's property sheet in
form or report Design view to the design surface
without changing the control focus
|
SHIFT+F7
|
|
To display a property sheet in Design view
|
ALT+ENTER
|
|
To open the selected form in Form view
|
ENTER or ALT+O
|
|
To open the selected table, query, form,
report, data access page, macro, or module in
Design view
|
CTRL+ENTER or ALT+D
|
|
With focus set to a section, will move the
focus to a subsection
|
CTRL+TAB
|
|
To add a control to a section
|
SHIFT+ENTER
|
|
To copy the selected control to the Clipboard
|
CTRL+C
|
|
To cut the selected control and copy it to
the Clipboard
|
CTRL+X
|
|
To paste the contents of the Clipboard in the
upper-left corner of the selected section
|
CTRL+V
|
|
To move the selected control to the right by
a pixel along the page's grid
|
RIGHT ARROW
|
|
To move the selected control to the left by a
pixel along the page’s grid
|
LEFT ARROW
|
|
To move the selected control up by a pixel
along the page’s grid
|
UP ARROW
|
|
To move the selected control down by a pixel
along the page’s grid
|
DOWN ARROW
|
|
To move the selected control to the right by
a pixel (irrespective of the page’s grid)
|
CTRL+RIGHT ARROW
|
|
To move the selected control to the left by a
pixel (irrespective of the page’s grid)
|
CTRL+LEFT ARROW
|
|
To move the selected control up by a pixel
(irrespective of the page’s grid)
|
CTRL+UP ARROW
|
|
To move the selected control down by a pixel
(irrespective of the page’s grid)
|
CTRL+DOWN ARROW
|
|
To increase the width of the selected control
(to the right) by a pixel
|
SHIFT+RIGHT ARROW
|
|
To decrease the width of the selected control
(to the left) by a pixel
|
SHIFT+LEFT ARROW
|
|
To decrease the height of the selected
control (from the bottom) by a pixel
|
SHIFT+UP ARROW
|
|
To increase the height of the selected
control (from the bottom) by a pixel
|
SHIFT+DOWN ARROW
|
|
To move the focus from the page design
surface to the address/subject dialog box when
sending a page as an e-mail
|
SHIFT+TAB
|
|
To move the focus from the Field List or Data
Outline back to the data access page design
surface
|
ESC
|
Navigate
in Datasheet view
Navigating
to another screen of data
| To do this |
Press |
|
To go down one screen
|
PAGE DOWN
|
|
To go up one screen
|
PAGE UP
|
|
To go right one screen
|
CTRL+PAGE DOWN
|
|
To go left one screen
|
CTRL+PAGE UP
|
Navigate
in subdatasheets
Navigating
between the datasheet and subdatasheet
| To do this |
Press |
|
To enter the subdatasheet from the last
field of the previous record in the
datasheet
|
TAB
|
|
To enter the subdatasheet from the first
field of the following record in the
datasheet
|
SHIFT+TAB
|
|
To exit the subdatasheet and move to the
first field of the next record in the
datasheet
|
CTRL+TAB
|
|
To exit the subdatasheet and move to the
last field of the previous record in the
datasheet
|
CTRL+SHIFT+TAB
|
|
From the last field in the subdatasheet
to enter the next field in the datasheet
|
TAB
|
|
From the datasheet to bypass the
subdatasheet and move to the next record in
the datasheet
|
DOWN ARROW
|
|
From the datasheet to bypass the
subdatasheet and move to the previous record
in the datasheet
|
UP ARROW
|
Note You can navigate between fields and
records in a subdatasheet with the same shortcut
keys used in Datasheet view.
Navigate
in Form view
Navigating
in forms with more than one page
| To do this |
Press |
|
To go down one page; at the end of the
record, moves to the equivalent page on the
next record
|
PAGE DOWN
|
|
To go up one page; at the end of the
record, moves to the equivalent page on the
previous record
|
PAGE UP
|
Navigating
between the main form and subform
| To do this |
Press |
|
To enter the subform from the preceding field
in the main form
|
TAB
|
|
To enter the subform from the following field
in the main form
|
SHIFT+TAB
|
|
To exit the subform and move to the next
field in the master form or next record
|
CTRL+TAB
|
|
To exit the subform and move to the previous
field in the main form or previous record
|
CTRL+SHIFT+TAB
|
Navigate
in Print Preview and Layout Preview
Dialog
box and window operations
| To do this |
Press |
|
To open the Print
dialog box
|
P or CTRL+P
|
|
To open the Page Setup
dialog box
|
S
|
|
To zoom in or out on a part of the page
|
Z
|
|
To cancel Print Preview or Layout Preview
|
C or ESC
|
Viewing
different pages
| To do this |
Press |
|
To move to the page number box; then type
the page number and press ENTER
|
F5
|
|
To view the next page (when
Fit To Window is selected)
|
PAGE DOWN or DOWN ARROW
|
|
To view the previous page (when
Fit To Window is selected)
|
PAGE UP or UP ARROW
|
Navigating
in Print and Layout Preview
| To do this |
Press |
|
To scroll down in small increments
|
DOWN ARROW
|
|
To scroll down one full screen
|
PAGE DOWN
|
|
To move to the bottom of the page
|
CTRL+DOWN ARROW
|
|
To scroll up in small increments
|
UP ARROW
|
|
To scroll up one full screen
|
PAGE UP
|
|
To move to the top of the page
|
CTRL+UP ARROW
|
|
To scroll to the right in small
increments
|
RIGHT ARROW
|
|
To move to the right edge of the page
|
END or CTRL+RIGHT ARROW
|
|
To move to the lower-right corner of the
page
|
CTRL+END
|
|
To scroll to the left in small increments
|
LEFT ARROW
|
|
To move to the left edge of the page
|
HOME or CTRL+LEFT ARROW
|
|
To move to the upper-left corner of the
page
|
CTRL+HOME
|
Navigate
in the Database Diagram window in a Microsoft Access
project
| To do this |
Press |
|
Move from a table cell to the table’s title
bar
|
ESC
|
|
Move from a table’s title bar to the last
cell you edited
|
ENTER
|
|
Move from table title bar to table title bar,
or
from cell to cell inside a table
|
TAB
|
|
Expand a list inside a table
|
ALT + DOWN ARROW
|
|
Scroll through the items in a drop-down list
from top to bottom
|
DOWN ARROW
|
|
Move to the previous item in a list
|
UP ARROW
|
|
Select an item in a list and move to the next
cell
|
ENTER
|
|
Change the setting in a check box
|
SPACEBAR
|
|
Go to the first cell in the row, or
to the beginning of the current cell
|
HOME
|
|
Go to the last cell in the row, or
to the end of the current cell
|
END
|
|
Scroll to the next "page" inside a table, or
to the next "page" of the diagram
|
PAGE DOWN
|
|
Scroll to the previous "page" inside a table,
or
to the previous "page" of the diagram
|
PAGE UP
|
Navigate
in the Query Designer in an Access project
Any
Pane
| To do this |
Press |
|
Move among the Query Designer panes
|
F6, SHIFT+F6
|
Diagram
Pane
| To do this |
Press |
|
Move among tables, views, and functions,
(and to join lines, if available)
|
TAB, or SHIFT+TAB
|
|
Move between columns in a table, view, or
function
|
Arrow keys
|
|
Choose the selected data column for
output
|
SPACEBAR or PLUS key
|
|
Remove the selected data column from the
query output
|
SPACEBAR or MINUS key
|
|
Remove the selected table, view, or
function, or join line from the query
|
DELETE
|
Note If multiple items are selected,
pressing SPACEBAR affects all selected items. Select
multiple items by holding down the SHIFT key while
clicking them. Toggle the selected state of a single
item by holding down CTRL while clicking it.
Grid
Pane
| To do this |
Press |
|
Move among cells
|
Arrow keys or TAB or SHIFT+TAB
|
|
Move to the last row in the current
column
|
CTRL+DOWN ARROW
|
|
Move to the first row in the current
column
|
CTRL+UP ARROW
|
|
Move to the top left cell in the visible
portion of grid
|
CTRL+HOME
|
|
Move to the bottom right cell
|
CTRL+END
|
|
Move in a drop-down list
|
UP ARROW or DOWN ARROW
|
|
Select an entire grid column
|
CTRL+SPACEBAR
|
|
Toggle between edit mode and cell
selection mode
|
F2
|
|
Copy selected text in cell to the
Clipboard (in edit mode)
|
CTRL+C
|
|
Cut selected text in cell and place it on
the Clipboard (in edit mode)
|
CTRL+X
|
|
Paste text from the Clipboard (in edit
mode)
|
CTRL+V
|
|
Toggle between insert and overstrike mode
while editing in a cell
|
INS
|
| Toggle the check box in the Output
column
Note If
multiple items are selected, pressing this
key affects all selected items.
|
SPACEBAR |
|
Clear the selected contents of a cell
|
DELETE
|
| Remove row containing selected data
column from the query
Note If
multiple items are selected, pressing this
key affects all selected items.
|
DELETE |
|
Clear all values for a selected grid
column
|
DELETE
|
|
Insert row between existing rows
|
INS ( after you select grid row)
|
|
Add an Or … column
|
INS ( after you select any Or ... column)
|
SQL
Pane
You can use the standard Windows editing keys
when working in the SQL pane, such as CTRL+Arrow
keys to move between words, and the Cut, Copy, and
Paste commands on the Edit menu.
Note You can only insert text;
there is no overstrike mode.
Navigate
in Page view
Note To use the following keys, press the TAB
key repeatedly until the
expand indicator (expand
indicator: A button that is used to expand or collapse
groups of records; it displays the plus (+) or minus (-)
sign.) or record navigation toolbar
has the
focus (focus:
The ability to receive user input through mouse or
keyboard actions or the SetFocus
method. Focus can be set by the user or by the
application. The object that has focus is usually
indicated by a highlighted caption or title bar.).
If a
PivotTable list (PivotTable
list: A Microsoft Office Web Component that is used to
analyze data interactively on a Web page. Data displayed
in a row and column format can be moved, filtered,
sorted, and calculated in ways that are meaningful for
your audience.) or
spreadsheet (Spreadsheet
Component: A Microsoft Office Web Component that
provides the interactive functionality of a spreadsheet
on a Web page.You can enter data, add formulas and
functions, apply filters, change formatting, and
recalculate.) control currently has
the focus, press ESC.
Work
with PivotTable views
PivotTable
view
Keys
for selecting elements in PivotTable view
| To do this |
Press |
|
Move the selection from left to
right, and then down
|
The TAB key
|
|
Move the selection from top to
bottom, and then to the right
|
ENTER
|
|
Select the cell to the left. If the
current cell is the leftmost cell,
SHIFT+TAB selects the last cell in the
previous row.
|
SHIFT+TAB
|
|
Select the cell above the current
cell. If the current cell is the topmost
cell, SHIFT+ENTER selects the last cell
in the previous column.
|
SHIFT+ENTER
|
|
Select the detail cells for the next
item in the row area
|
CTRL+ENTER
|
|
Select the detail cells for the
previous item in the row area
|
SHIFT+CTRL+ENTER
|
|
Move the selection in the direction
of the arrow key. If a row or column
field is selected, press DOWN ARROW to
move to the first item of data in the
field, and then press an arrow key to
move to the next or previous item or
back to the field. If a detail field is
selected, press DOWN ARROW or RIGHT
ARROW to move to the first cell in the
detail area.
|
Arrow keys
|
|
Extend or reduce the selection in the
direction of the arrow key
|
SHIFT+arrow key
|
|
Move the selection to the last cell
in the direction of the arrow key
|
CTRL+arrow key
|
|
Move the selected item in the
direction of the arrow key
|
SHIFT+ALT+arrow key
|
|
Select the leftmost cell of the
current row
|
HOME
|
|
Select the rightmost cell of the
current row
|
END
|
|
Select the leftmost cell of the first
row
|
CTRL+HOME
|
|
Select the last cell of the last row
|
CTRL+END
|
|
Extend selection to the leftmost cell
of the first row
|
SHIFT+CTRL+HOME
|
|
Extend selection to the last cell of
the last row
|
SHIFT+CTRL+END
|
|
Select the field for the currently
selected item of data, total, or detail
|
CTRL+SPACEBAR
|
|
Select the entire row containing the
currently selected cell
|
SHIFT+SPACEBAR
|
|
Select the entire
PivotTable view (PivotTable
view: A view that summarizes and
analyzes data in a datasheet or form.
You can use different levels of detail
or organize data by dragging the fields
and items or by showing and hiding items
in the drop-down lists for the fields.)
|
CTRL+A
|
|
Display the next screen
|
PAGE DOWN
|
|
Display the previous screen
|
PAGE UP
|
|
Extend a selection down one screen
|
SHIFT+PAGE DOWN
|
|
Reduce a selection by one screen
|
SHIFT+PAGE UP
|
|
Display the next screen to the right
|
ALT+PAGE DOWN
|
|
Display the previous screen to the
left
|
ALT+PAGE UP
|
|
Extend selection to the page on the
right
|
SHIFT+ALT+PAGE DOWN
|
|
Extend selection to the page on the
left
|
SHIFT+ALT+PAGE UP
|
Keys
for displaying, hiding, filtering, or sorting
data
| To do this |
Press |
|
Show or hide the expand indicators (
and
boxes) beside items
|
CTRL+8
|
|
Expand the currently selected item
|
CTRL+PLUS SIGN
|
|
Hide the currently selected item
|
CTRL+MINUS SIGN
|
|
Open the list for the currently
selected field
|
ALT+DOWN ARROW
|
|
Alternately move to the most recently
selected item, the OK
button, and the Cancel
button in the drop-down list for a field
|
The TAB key
|
|
Move to the next item in the
drop-down list for a field
|
Arrow keys
|
|
Select or clear the check box for the
current item in the drop-down list for a
field
|
SPACEBAR
|
|
Close the drop-down list for a field
and apply any changes you made
|
ENTER
|
|
Close the drop-down list for a field
without applying your changes
|
ESC
|
|
Turn AutoFilter on or off
|
CTRL+T
|
|
Sort data in the selected field or
total in ascending order (A – Z 0 – 9)
|
CTRL+SHIFT+A
|
|
Sort data in the selected field or
total in descending order (Z – A 9 – 0)
|
CTRL+SHIFT+Z
|
|
Move the selected member up or left
|
ALT+SHIFT+UP ARROW or ALT+SHIFT+LEFT
ARROW
|
|
Move the selected member down or
right
|
ALT+SHIFT+DOWN ARROW or
ALT+SHIFT+RIGHT ARROW
|
|
