| Task Pane | |
|---|---|
| F1 | - display the Help task pane |
| CTRL + F1 | - open or close the current task pane |
| Workbook Window | |
| CTRL + F4 | - close the selected workbook window |
| CTRL + F5 | - restore the window size of the selected workbook window |
| CTRL + F6 | - switch to next workbook window when more than one workbook window is open - When the task pane is visible, the next workbook will include that pane when switching between panes |
| CTRL + F7 | - move the workbook window when it is not maximized - use ARROW keys to move the window - press ESC key when finished |
| CTRL + F8 | - resize the workbook window by ARROW keys when it is not maximized |
| CTRL + F9 | - minimize a workbook window to an icon |
| CTRL + F10 | - maximize or restore the selected workbook window |
| Worksheets | |
| ALT + SHIFT + F1 SHIFT + F11 | - insert a new worksheet |
| Cells | |
| F2 | - edit the active cell - point the cursor at the end of the cell contents |
| SHIFT + F2 | - create or edit a cell comment |
| F8 | - select multiple cells by ARROW keys |
| Dialog Box | |
| SHIFT + F3 | - display the Insert Function dialog box |
| F5 | - display the Go To dialog box |
| F7 | - display the Spelling dialog box to check spelling in the active worksheet or selected cells |
| ALT + F8 | - display the Macro dialog box to run, edit, or delete a macro |
| ALT + F11 | - open the Visual Basic Editor which you can create a macro by using Visual Basic for Applications (VBA) |
| ALT + SHIFT + F11 | - open the Microsoft Script Editor, where you can add text, edit HTML tags, and modify any script code |
| F12 | - display the Save As dialog box |
| Menu | |
| F10 | - select the toolbar - close an open menu and submenu at the same time |
| SHIFT + F10 | - display the shortcut menu for a selected cell |
| Chart | |
| ALT + F1 F11 | - create a chart for the selected cells |
| Split Window | |
| F6 | - switch to next pane in a worksheet that has been split (Window > Split command) |
| SHIFT + F6 | - switch to previous pane in a worksheet that has been split |
May 19, 2009
Excel Shortcut Key
Labels:
Excel

1 comments:
i want vs thank.. especially tat day i ask u d.. how to get preloaded
Post a Comment