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

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. User Avatar
    April 15, 2023
    Reply

    Well the content was very useful

  2. User Avatar
    April 15, 2023
    Reply

    Thanks for clearing up my doubt.

Leave a Reply

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021