You can activate the Excel 2010 hot keys by pressing the Alt key before you type the mnemonic letters for a particular task. The mnemonic letter for all view-related commands in Excel 2010 is W (the last letter you see in vieW). Therefore, all the hot keys for switching the Excel worksheet into a new view begin with Alt+W. Remember that, and you’ll find most of the subsequent letters fairly easy to deal with.
Hot Key | Excel Ribbon Command | Function |
---|---|---|
Alt+WL | View→Normal View | Returns the worksheet to normal view from Page Layout or Page Break Preview |
Alt+WP | View→Page Layout View | Puts the worksheet into Page Layout View showing the page breaks, margins, and rulers |
Alt+WI | View→Page Break Preview | Puts the worksheet into Page Break Preview showing pages breaks that you can adjust |
Alt+WE | View→Full Screen | Puts the worksheet in full-screen mode which hides the File Menu, Quick Access toolbar, and Ribbon — press the Esc key to restore previous viewing mode |
Alt+WVG | View→Gridlines | Hides and redisplays the row and column gridlines that form the cells in the Worksheet area |
Alt+WG | View→Zoom to Selection | Zooms the Worksheet area in or out to the magnification percentage needed to display just the cell selection |
Alt+WJ | View→100% | Returns the Worksheet area to the default 100% magnification percentage |
Alt+WN | View→New Window | Inserts a new window in the current workbook |
Alt+WA | View→Arrange All | Opens the Arrange dialog box where you can select how workbook windows are displayed on the screen |
Alt+WF | View→Freeze Panes | Opens the Freeze Panes drop-down menu where you select how to freeze rows and columns in the Worksheet area: Freeze Panes (to freeze all the rows above and columns to the left of the cell cursor); Freeze Top Row; or Freeze First Column |
Alt+WS | View→Split | Splits the worksheet into four panes using the top and left edge of the cell cursor as the vertical and horizontal dividing lines — press hot keys again to remove all panes |
Alt+WH | View→Hide | Hides the current worksheet window or workbook |
Alt+WU | View→Unhide | Opens the Unhide dialog box where you can select the window or workbook to redisplay |
Alt+WB | View→View Side by Side | Tiles two open windows or workbooks one above the other for comparison — press hot keys again to restore the original full windows |
Alt+WW | View→Switch Windows | Opens the Switch Windows drop-down menu where you can select the open window or workbook to make active |
dummies
Source:http://www.dummies.com/how-to/content/excel-2010-view-commands-hot-keys.html
No comments:
Post a Comment