Work in windows and dialog boxes using shortcut keys:Work in windows and dialog boxes using shortcut keys:The following are tables of shortcut keys available in Microsoft Excel for:
In each table, the left column gives the desired action and the right column gives the associated shortcut key.
| Desired Action | Shortcut Key |
|---|---|
| Switch to the next program. | ALT+TAB |
| Switch to the previous program. | ALT+SHIFT+TAB |
| Show the Windows Start menu. | CONTROL+ESC |
| Close the active workbook window. | CONTROL+W |
| Restore the active workbook window. | CONTROL+F5 |
| Switch to the next workbook window. | CONTROL+F6 |
| Switch to the previous workbook window. | CONTROL+SHIFT+F6 |
| Carry out the Move command (workbook icon menu, menu bar). | CONTROL+F7 |
| Carry out the Size command (workbook icon menu, menu bar). | CONTROL+F8 |
| Minimize the workbook window to an icon. | CONTORL+F9 |
| Maximize or restore the workbook window. | CONTROL+F10 |
| Select a folder in the Open or Save As dialog box (File menu). | ALT+0 to select the folder list; arrow keys to select a folder |
| Choose a toolbar button in the Open or Save As dialog box (File menu). | ALT+number(1 is the leftmost button, 2 is the next, and so on) |
| Update the files visible in the Open or Save As dialog box (File menu). | F5 |
| Desired Action | Shortcut Key |
|---|---|
| Switch to the next tab in a dialog box. | CONTROL+TAB or CONTROL+PAGE DOWN |
| Switch to the previous tab in a dialog box. | CONTROL+SHIFT+TAB or CONTROL+PAGE UP |
| Move to the next option or option group. | TAB |
| Move to the previous option or option group. | SHIFT+TAB |
| Move between options in the active drop-down list box or between some options in a group of options. | ARROW KEYS |
| Perform the action assigned to the active button (the button with the dotted outline), or select or clear the active check box. | SPACEBAR |
| Move to an option in a drop-down list box. | Letter key for the first letter in the option name you want (when a drop-down list box is selected) |
| Select an option, or select or clear a check box. | ALT+letter, where letter is the key for the underlined letter in the option name |
| Open the selected drop-down list box Open the selected drop-down list box. | ALT+DOWN ARROW |
| Close the selected drop-down list box. | ESC |
| Perform the action assigned to the default command button in the dialog box (the button with the bold outline; often the OK button). | ENTER |
| Cancel the command and close the dialog box. | ESC |
| Desired Action | Shortcut Key |
|---|---|
| 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 or right. | CONTROL+LEFT ARROW or CONTROL+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 |
| 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. | CONTROL+SHIFT+LEFT ARROW |
| Select or unselect one word to the right. | CONTROL+SHIFT+RIGHT ARROW |
Contact us at infotechaccess@server.rehab.uiuic.edu