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:
At the bottom of the drop down menu we can select the command More Paper Sizes as shown in the image below.
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.
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.
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.
Posted on May 1, 2015, in Excel English 2013, Microsoft Office 2013 English and tagged First Page Number, Landscape Mode, Microsoft Excel 13, Microsoft Office 13, More Paper Sizes, MVP, Office Smart, Office System, Orientation, Page Layout, Page Setup, Paper Size, Paper Sizes, Paper Sizes in Excel 13, Portrait, Print Preview, Print Quality, Scaling, Smart Office. Bookmark the permalink. Comments Off on Paper Sizes in Excel 13.