There are several ways to change the way your worksheet is displayed in Excel 2010. You can change to a number of predefined views or create your own custom view with specific settings that suit the way you work. In this tutorial, we will look at the built in views available in Excel 2010.
- Open a new workbook in Excel 2010.
- On the View tab, click one of the view options in the Workbook Views group.
Normal View: displays the content in normal view. This is usually the view that is used when creating your worksheet.
Page Layout View: displays the content as it would appear on a page if printed. It’s similar to Print Preview, but you can still edit the content in this view.
Page Break Preview: displays the content as it would appear over several pages. The blue lines can be dragged to reduce the printed size of the content and force it to fit a specific number of pages.
Full Screen View: displays only the worksheet – no formula bar, ribbon or status bars are visible. This allows you to maximise the amount of content you see in your worksheet.
NOTE: Another way to toggle your worksheet view is to click the View buttons in the bottom right-hand corner of your Excel 2010 window next to the Zoom slider. The Normal, Page Layout and Page Break View buttons are displayed.
That’s it for changing your worksheet view. Hope you found it useful – don’t forget to take a look at some of the other tutorials about working in Excel 2010.