Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Print a Part of a Spreadsheet in Microsoft Excel

Date:2019-8-23 Author:Cordelia

Printing out a spreadsheet in Excel may not be a hard thing for you, but there’re also some tips can make you do the job better. For example, if you just want to print a part of the table in the worksheet, and it can hardly fill the width of a A4 paper, you’d better make some adjustments before simply hitting print button.

First, switch the worksheet to PageLayout in View tab. Thus you can see the layout of the spreadsheet in the whole page.

How to Print a Part of a Spreadsheet in Microsoft Excel

Here you can also click Header area to add a proper header. It will always show in the paper even if you only print out a part of the spreadsheet.

How to Print a Part of a Spreadsheet in Microsoft Excel

Then switch back to the Normal mode.

How to Print a Part of a Spreadsheet in Microsoft Excel

You’ll find a dotted line suddenly appears on the page. It’s actually the border of printed area. So if you want the table to cover the width of the whole paper, you need adjust the size of cells to finally meet the dotted line.

How to Print a Part of a Spreadsheet in Microsoft Excel

How to Print a Part of a Spreadsheet in Microsoft Excel

Then select the whole table or the range of cells you want to print. Switch to Page Layout and click Print AreaSet Print Area. You can also reset the print area by clicking Clear Print Area.

How to Print a Part of a Spreadsheet in Microsoft Excel

Click File tab on the upper left corner of Excel.

How to Print a Part of a Spreadsheet in Microsoft Excel

Click Print in the left sidebar. You can then see the preview of the printed paper on the right part.

How to Print a Part of a Spreadsheet in Microsoft Excel

Adjust the settings according to the preview. For example, you can change the paper to Landscape Orientation.

How to Print a Part of a Spreadsheet in Microsoft Excel

After finishing the settings. Click Print button the print the spreadsheet out.

How to Print a Part of a Spreadsheet in Microsoft Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

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