When we look on a Spreadsheet in Excel on a Monitor, everything looks just perfect. Sometimes though, when we want to Print it, if we are not careful we will be ending up wasting a lot of Paper and we will not have a clue what has been Printed. Data here, Columns there, Rows everywhere. Everything will just be Printed out of order. This is where the Backstage Printing Options comes along, where we can adjust the Paper Size and even the Orientation of the Page. To find out how to Maximize the Printing Options in an Excel Spreadsheet, just keep on reading the post below.
We must select the File tab to move to Backstage View. Once in Backstage View, from the drop-down menu from the left we select the Print command as shown in the image below. In the image below, at the right of the screen we have a Preview of how our Workbook will be printed. We cannot see though the Margins, neither for the Page, neither for the Header and Footer. We also notice in the bottom middle of the Print Preview task pane the Number of the Page and the Total Number of Pages.
For us to be able to see the Margins for our Page and for the Header and Footer, we must select the icon which is located at the bottom right corner of the Print Preview as shown below and it is named Show Margins.
Once the Show Margins command is selected, we can see in the next image the Margins appearing on our screen. We can now use the Margins to adjust the Columns or Rows to fit any Data that may have moved on another page.
If no matter what we try to Adjust the Margins and we cannot fit it on one Page, we can always use the Page Setup dialog box for further adjustments. In the middle of the Print Preview task pane, and at the end of the Settings commands is located the Page Setup command as shown in the image below. All we need to do is to select the Page Setup command, so the Page Setup dialog box to appear.
Once the Page Setup command is selected, the Page Setup dialog box appears, where we make sure the Page tab is activated as shown below. Here we can use the Scaling Menu to Adjust the Size of the Text to fit the Data into one Page. Keep in mind though, that if we Scale the percentage a lot the Data comparing to its Normal Size, the Data will not be so visible and legible.
Below you can check out the video describing How To Maximize The Printing Options in an Excel Spreadsheet?
Don’t Forget To Subscribe To My YouTube Channel.
This entry was posted in Word 365 ProPlus English and tagged Adjust, Backstage Printing, Data, Excel, File, fit any Data, Footer, Header, How To, How To Maximize Printing Options in An Excel Spreadsheet?, Know How, Microsoft Excel, Microsoft Office, Microsoft Outlook, Microsoft PowerPoint, Microsoft Word, My YouTube Channel, Normal Size, Number of the Page, Office Smart, Office System, OfficeSmart, Options, Orientation, Page Setup, philippospan, Print Preview, Scale the Data, Smart Office, smartoffice, Spreadsheet, Subscribe, Text to fit, Tip & Tricks, Total Number of Pages.