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