Saturday, September 13, 2014

Divide Excel Worksheet into Pages!!

Excel Page Layout View

If you're using Excel 2010/ 2013, you can divide your worksheet into individual pages. This exciting feature was unthinkable even on Excel 2003. At first, Microsoft introduced this Page Layout feature in Excel 2007. And it's available in Excel 2010 and 2013 too. 

Almost all of you are familiar with the Print Layout view of Microsoft Word. Excel Page Layout view does the same job here. If you enable Page Layout view in a worksheet, you can easily understand your print area with header and footer. And it also makes your printing task easier

Excel 2013 Page Layout View

Applies to:
  • Excel 2007
  • Excel 2010
  • Excel 2013

Advantages of Page Layout

  • You can view how your printed document will look
  • Check where your page begins and ends
  • View headers and footers of the page
  • Print the worksheet page by page

How to Enable Page Layout View

You can enable page layout view as below:
  1. Open any worksheet or create a new one
  2. Go to the View Tab > Workbook Views > Page Layout 

Page Layout Option in View Menu

You can also use the keyboard shortcuts:

Press Alt Key > Then type WP 

If you would like to back to the Normal View then:

Press Alt Key > Then type WL 

You can also enable Page Layout view from Status Bar. I think it's the most handy option. Follow the image below:

Excel 2013 Page Layout Icon

The selected icon in the middle is Page Layout icon. The left one is for Normal View. And the right one is for Page Break Preview. 

Stay with Marks PC Solution to get more interesting IT topics!

No comments:

Post a Comment