To do this | Press |
Switch to the next program. | ALT+TAB |
Switch to the previous program. | ALT+SHIFT+TAB |
Display the Windows Start menu. | CTRL+ESC |
Close the selected workbook window. | CTRL+W or CTRL+F4 |
Restore the window size of the selected workbook window. | CTRL+F5 |
Switch to the next pane in a worksheet that has been split (Window menu, Split command). | F6 Note When the task pane (task pane: A window within an Office application that provides commonly used commands. Its location and small size allow you to use these commands while still working on your files.) is visible, F6 includes that pane when switching between panes. |
Switch to the previous pane in a worksheet that has been split. | SHIFT+F6 Note When the task pane is visible, SHIFT+F6 includes that pane when switching between panes. |
When more than one workbook window is open, switch to the next workbook window. | CTRL+F6 |
Switch to the previous workbook window. | CTRL+SHIFT+F6 |
When a workbook window is not maximized, perform the Move command (on the Control menu for the workbook window). Use the arrow keys to move the window, and when finished press ESC. | CTRL+F7 |
When a workbook window is not maximized, perform the Size command (on the Control menu for the workbook window). Use the arrow keys to resize the window, and when finished press ENTER. | CTRL+F8 |
Minimize a workbook window to an icon. | CTRL+F9 |
Maximize or restore the selected workbook window. | CTRL+F10 |
Copy a picture of the screen to the Clipboard. | PRTSCR |
Copy a picture of the selected window to the Clipboard. | ALT+PRINT SCREEN |
To do this | Press |
Display the menu or message for a smart tag. If more than one smart tag is present, switch to the next smart tag and display its menu or message. | ALT+SHIFT+F10 |
Select the next item in a smart tag menu. | DOWN ARROW |
Select the previous item in a smart tag menu. | UP ARROW |
Perform the action for the selected item in a smart tag menu. | ENTER |
Close the smart tag menu or message. | ESC |
You can ask to be notified by a sound whenever a smart tag appears. To hear audio cues, you must have a sound card. You must also have Microsoft Office Sounds installed on your computer.
If you have access to the World Wide Web, you can download Microsoft Office Sounds from the Microsoft Office Web site. On the Help menu, click Microsoft Office Online and search for "Microsoft Office Sounds." After you've installed the sound files, you need to select the Provide feedback with sound check box on the General tab of the Options dialog box (Tools menu). When you select (or clear) this check box, the setting affects all Office programs that support sound.
To do this | Press |
Move to a task pane (task pane: A window within an Office application that provides commonly used commands. Its location and small size allow you to use these commands while still working on your files.) from another pane in the program window. (You may need to press F6 more than once.) | F6 Notes
|
When a menu or toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.) is active, move to a task pane. (You may need to press CTRL+TAB more than once.) | CTRL+TAB |
When a task pane is active, select the next or previous option in the task pane | TAB or SHIFT+TAB |
Display the full set of commands on the task pane menu | CTRL+SPACEBAR |
Move among choices in a selected submenu; move among certain options in a group of options | DOWN ARROW or UP ARROW |
Open the selected menu, or perform the action assigned to the selected button | SPACEBAR or ENTER |
Open a shortcut menu (shortcut menu: A menu that shows a list of commands relevant to a particular item. To display a shortcut menu, right-click an item or press SHIFT+F10.); open a drop-down menu for the selected gallery item | SHIFT+F10 |
When a menu or submenu is visible, select the first or last command on the menu or submenu | HOME or END |
Scroll up or down in the selected gallery list | PAGE UP or PAGE DOWN |
Move to the top or bottom of the selected gallery list | CTRL+HOME or CTRL+END |
Access and use menus and toolbars
To do this | Press |
Select the menu bar (menu bar: The horizontal bar below the title bar that contains the names of menus. A menu bar can be the built-in menu bar or a custom menu bar.), or close an open menu and submenu at the same time. | F10 or ALT |
When a toolbar is selected, select the next or previous button or menu on the toolbar. | TAB or SHIFT+TAB |
When a toolbar is selected, select the next or previous toolbar. | CTRL+TAB or CTRL+SHIFT+TAB |
Open the selected menu, or perform the action for the selected button or command. | ENTER |
Display the shortcut menu (shortcut menu: A menu that shows a list of commands relevant to a particular item. To display a shortcut menu, right-click an item or press SHIFT+F10.) for the selected item. | SHIFT+F10 |
Display the Control menu for the Excel window. | ALT+SPACEBAR |
When a menu or submenu is open, select the next or previous command. | DOWN ARROW or UP ARROW |
Select the menu to the left or right. When a submenu is open, 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 an open menu. When a submenu is open, close only the submenu. | ESC |
Display the full set of commands on a menu. | CTRL+DOWN ARROW |
Show or hide the Standard toolbar. | CTRL+7 |
Note You can select any menu command on the menu bar or on a displayed 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 that contains the command you want. In the menu that appears, press the underlined letter in the command that you want.
Resize and move toolbars and task panes
- Press ALT to select the menu bar (menu bar: The horizontal bar below the title bar that contains the names of menus. A menu bar can be the built-in menu bar or a custom menu bar.).
- Press CTRL+TAB repeatedly to select the toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.) or task pane (task pane: A window within an Office application that provides commonly used commands. Its location and small size allow you to use these commands while still working on your files.) you want.
- Do one of the following:
- In the toolbar, press CTRL+SPACE to display the Toolbar Options menu.
- Select the Size command, and then press ENTER.
- Use the arrow keys to resize the toolbar.
- In the toolbar, press CTRL+SPACE to display the Toolbar Options menu.
- Select the Move command, and then press ENTER.
- Use the arrow keys to position the toolbar. Press CTRL+ the arrow keys to move one pixel at a time. To undock the toolbar, press DOWN ARROW repeatedly. To dock the toolbar vertically on the left or right side, press LEFT ARROW or RIGHT ARROW respectively when the toolbar is all the way to the left or right side.
- In the task pane, press CTRL+SPACE to display a menu of additional commands.
- Use the DOWN ARROW key to select the Size command, and then press ENTER.
- Use the arrow keys to resize the task pane. Use CTRL+ the arrow keys to resize by one pixel at a time.
- In the task pane, press CTRL+SPACE to display a menu of additional commands.
- Use the DOWN ARROW key to select the Move command, and then press ENTER.
- Use the arrow keys to position the task pane. Use CTRL+ the arrow keys to move one pixel at a time.
- In the toolbar, press CTRL+SPACE to display the Toolbar Options menu.
- When you are finished moving or resizing, press ESC.
To do this | 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 an open drop-down list, or between options in a group of options. | Arrow keys |
Perform the action for the selected button, or select or clear the selected check box. | SPACEBAR |
Open the list if it is closed and move to that option in the list. | First letter of an option in a drop-down list |
Select an option, or select or clear a check box. | ALT+ the underlined letter in an option |
Open the selected drop-down list. | ALT+DOWN ARROW |
Perform the action for 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 |
Use edit boxes within dialog boxes
An edit box is a blank in which you type or paste an entry, such as your user name or the path (path: The route that the operating system uses to locate a folder or file; for example, C:\House finances\March.doc.) to a folder.
To do this | 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 |
Use the Open, Save As, and Insert Picture dialog boxes
The Open, Insert Picture, and Save As dialog boxes support standard dialog box keyboard shortcuts. (To view standard shortcuts for dialog boxes, refer to the Use Dialog Boxes and Use Edit Boxes Within Dialog Boxes sections in the main Keyboard Shortcuts topic.) These dialog boxes also support the shortcuts below.
To do this | Press |
Go to the previous folder | ALT+1 |
Up One Level button: open the folder up one level above the open folder | ALT+2 |
Search the Web button: close the dialog box and open your Web search page (search page: A page from which you can find and go to other Internet sites or to documents on an intranet. Many search pages provide various ways to search, such as by topic, by keyword, or by matches to user queries.) | ALT+3 |
Delete button: delete the selected folder or file | ALT+4 |
Create New Folder button: create a new folder | ALT+5 |
Views button: switch among available folder views | ALT+6 |
Tools button: show the Tools menu | ALT+7 or ALT+L |
Display a shortcut menu (shortcut menu: A menu that shows a list of commands relevant to a particular item. To display a shortcut menu, right-click an item or press SHIFT+F10.) for a selected item such as a folder or file | SHIFT+F10 |
Move between options or areas in the dialog box | TAB |
Open the Look in list | F4 or ALT+I |
Refresh the file list | F5 |
Use 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.
No comments:
Post a Comment