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.

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Reply


x

Interesting BlogPosts to read

How to quickly remove multiple line breaks in Excel using VBA code?
There are times when you might copy few data from different source and you would end up getting unne...
How to change orientation of the worksheets in Microsoft Excel ?
This blog post will show the steps that are needed to change the orientation of the current workshee...
How to hide page breaks in worksheets in Microsoft Excel ?
When the page breaks is used to adjust the print area in a worksheet in excel , this would show up a...