Paper Sizes in Excel 13

In the previous post of mine, I mentioned how to change the Margins of our Spreadsheet in Excel 13. What happens though when we want to change the Size of our Paper, change the Orientation or even Scale it down in order for it to Fit when we print it? In this post I will describe these features among with others. All you have to do is to follow the steps below:

First of all we must select the Page Layout tab and from the area of the ribbon named Page Setup we select the command Size as shown in the image below.

Once selected the drop down menu appears where we can select one of the predefined Paper Sizes, with their measurements at the side and which some of them are the following:

  • Letter
  • Tabloid
  • Legal
  • Executive
  • A3
  • A4
  • B4
  • B5
  • Envelope #10
  • Envelope Monarch

At the bottom of the drop down menu we can select the command More Paper Sizes as shown in the image below.

Page Layout - Size

Once the More Paper Sizes command is selected from the drop down menu, the Page Setup dialog box appears with the Page tab activated as shown in the image below.

In this dialog box we can do the following:

Orientation: We can activate either the Portrait or Landscape Mode in order to change the orientation of our worksheet.

Scaling:

  • Adjust To: We can increase or decrease the percentage of our worksheet according to its normal size, so when we print it, it will be printed according to the percentage that we defined with the use of the up and down buttons that are next to the command.
  • Fit To: We can get a worksheet to fit on a single page by selecting the 1 Page Option on the Wide and Tall drop down arrows attached to the command buttons. When we select this option, Excel figures out how much to reduce the size, in order for it to fit all on one page.

Paper Size: We can select from the drop down menu one of the predefined sizes. The procedure is the same as described above but from here we have more options to select from.

Print Quality: We can select the quality of the printed worksheet according to the printers that we have installed.

First Page Number: We can set which number we want our printed worksheet to start from, or we can leave it as it is Auto.

At the bottom right corner of the Page Setup dialog box we can use the following buttons:

Print: Once we select this command, we will be moved to backstage view in order to print our Worksheet.

Print Preview: Once we select this command, we will be moved to backstage view in order to preview our Worksheet.

Options: Once we select this command, the default Printers Setup Options dialog box will appear in order to the arrangements that we want.

Whatever settings we do, at the end we must press the OK button at the end in order for all the settings will be applied.

Page Setup - Page

Below you can check out the video all the features that are available on the Page Setup dialog box and specifically on the Page tab.

Paper Sizes in Excel 13

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on May 1, 2015, in Excel English 2013, Microsoft Office 2013 English and tagged , , , , , , , , , , , , , , , , , , . Bookmark the permalink. Comments Off on Paper Sizes in Excel 13.

Comments are closed.