How To Maximize Printing Options in An Excel Spreadsheet?

Posted on

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.

How To Maximize Printing Options in Excel

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.

How To Insert A Watermark on a Spreadsheet in Excel

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.

How To Insert A Watermark on a Spreadsheet in Excel

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.

How To Insert A Watermark on a Spreadsheet in Excel

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.

How To Insert A Watermark on a Spreadsheet in Excel

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.

How To Insert A Watermark on a Spreadsheet in Excel

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.

YouTube Channel

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s