Wednesday, June 26, 2013

MS Excel All Usefull shortcuts Keys for the Office interface


      -:      Keys for the Office interface      :-

Display and use windows
TO DO THISPRESS
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 (Windowmenu, Split command).
F6
 NOTE   When the task pane 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 Movecommand (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 Sizecommand (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

Access and use smart tags
TO DO THISPRESS
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
Access and use task panes
TO DO THISPRESS
Move to a task pane from another pane in the program window. (You may need to press F6 more than once.)
F6
 NOTES 
  • If pressing F6 doesn't display the task pane you want, try pressing ALT to place focus on the menu bar, and then pressing CTRL+TAB to move to the task pane.
  • In a worksheet that has been split (Window menu, Splitcommand), F6 includes the split panes when switching between panes.
When a menu or toolbar 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 paneTAB or SHIFT+TAB
Display the full set of commands on the task pane menuCTRL+SPACEBAR
Move among choices in a selected submenu; move among certain options in a group of optionsDOWN ARROW or UP ARROW
Open the selected menu, or perform the action assigned to the selected buttonSPACEBAR or ENTER
Open a shortcut menu; open a drop-down menu for the selected gallery itemSHIFT+F10
When a menu or submenu is visible, select the first or last command on the menu or submenuHOME or END
Scroll up or down in the selected gallery listPAGE UP or PAGE DOWN
Move to the top or bottom of the selected gallery listCTRL+HOME or CTRL+END
Access and use menus and toolbars
TO DO THISPRESS
Select the 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 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

1. Press ALT to select the menu bar.
2. Press CTRL+TAB repeatedly to select the toolbar or task pane you want.3. Do one of the following:
  * Resize a toolbar

  • 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.
  * Move a 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.
  * Resize a task pane
  • 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.
  * Move a task pane
  • 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. 
4. When you are finished moving or resizing, press ESC.
 
Use dialog boxes
TO DO THISPRESS
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 to a folder.
TO DO THISPRESS
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 THISPRESS
Go to the previous folder Button imageALT+1
Up One Level Button image button: open the folder up one level above the open folderALT+2
Search the Web Button image button: close the dialog box and open your Web search pageALT+3
Delete Button image button: delete the selected folder or fileALT+4
Create New Folder Button image button: create a new folderALT+5
Views Button image button: switch among available folder viewsALT+6
Tools button: show the Tools menuALT+7 or ALT+L
Display a shortcut menu for a selected item such as a folder or fileSHIFT+F10
Move between options or areas in the dialog boxTAB
Open the Look in listF4 or ALT+I
Refresh the file listF5
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.

In the Help task pane

TO DO THISPRESS
Display the Help task pane.F1
Switch between the Help task pane and the active application.
F6
 NOTE   In a worksheet that has been split (Window menu, Splitcommand), F6 includes the split panes when switching between panes.
Select the next item in the Helptask pane.TAB
Select the previous item in the Helptask 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 THISPRESS
Select the next hidden text or hyperlink, or Show All or Hide All at the top of a topicTAB
Select the previous hidden text or hyperlink, or the Browser View button at the top of a Microsoft Office Web site articleSHIFT+TAB
Perform the action for the selected Show All, Hide All, hidden text, or hyperlinkENTER
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

0 comments:

Post a Comment