How to resize print area and fit to Single page in Excel 2016 ?

When you try to print a worksheet in Microsoft Excel 2016 , you may notice that the content might overflow from the page. You can change the printer settings to resize the print area and fit it to single page in Microsoft Excel 2016.

How to resize print area and fit to Single page in Excel 2016 ?

Follow the below steps to resize the print area and fitting it to one page.

1. Open your workbook in Microsoft Excel 2016 and select the worksheet.

2. Click File -> Print from the Office Ribbon.

image

3. In the settings section , select “Fit Sheet to One page” in the No scaling combo box.

SNAGHTML671383

The print area would be resized and you should see the worksheet fit in to single page now.

    2 Comments

  1. April 15, 2023
    Reply

    Well the content was very useful

  2. April 15, 2023
    Reply

    Thanks for clearing up my doubt.

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this post, you’ll learn how to Find Blank cells in excel so that you can remove or delete the blank cells form...
In this article, you’ll learn what is a Gauge Chart in Microsoft Excel. Also, you will learn how to add...
Microsoft Excel provides a shortcut for the users to move columns in excel using two different ways – using Shift...