Excel 2010 View Commands Hot Keys

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 KeyExcel Ribbon CommandFunction
Alt+WLView→Normal ViewReturns the worksheet to normal view from Page Layout or Page
Break Preview
Alt+WPView→Page Layout ViewPuts the worksheet into Page Layout View showing the page
breaks, margins, and rulers
Alt+WIView→Page Break PreviewPuts the worksheet into Page Break Preview showing pages breaks
that you can adjust
Alt+WEView→Full ScreenPuts 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+WVGView→GridlinesHides and redisplays the row and column gridlines that form the
cells in the Worksheet area
Alt+WGView→Zoom to SelectionZooms the Worksheet area in or out to the magnification
percentage needed to display just the cell selection
Alt+WJView→100%Returns the Worksheet area to the default 100% magnification
percentage
Alt+WNView→New WindowInserts a new window in the current workbook
Alt+WAView→Arrange AllOpens the Arrange dialog box where you can select how workbook
windows are displayed on the screen
Alt+WFView→Freeze PanesOpens 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+WSView→SplitSplits 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+WHView→HideHides the current worksheet window or workbook
Alt+WUView→UnhideOpens the Unhide dialog box where you can select the window or
workbook to redisplay
Alt+WBView→View Side by SideTiles two open windows or workbooks one above the other for
comparison — press hot keys again to restore the original
full windows
Alt+WWView→Switch WindowsOpens 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