This is useful for printing data with a large number of columns, but few rows.
HOW DO I CHANGE PRINT AREA IN EXCEL HOW TO
How to Adjust the Scale and Margin to Fit
![how do i change print area in excel how do i change print area in excel](https://01090035loroy6ppi1.files.wordpress.com/2012/04/10print.png)
The printed spreadsheet will now feature the frozen header row on top of the data on each page. In most cases, you’re going to be using “1 row.” Then choose your header dimensions from the options list.
![how do i change print area in excel how do i change print area in excel](https://d1rytvr7gmk1sx.cloudfront.net/wp-content/uploads/2020/03/hero-printgooglesheet.jpg)
In many cases, it’s easy enough to know what you’re looking at, but having headers on all pages is generally a better experience, especially if you’re going to be looking at pages individually.
![how do i change print area in excel how do i change print area in excel](https://image.slidesharecdn.com/howtosetprintareainmicrosoftexcel-171130032045/95/how-to-set-print-area-in-microsoft-excel-3-638.jpg)
You can set Google Sheets to print header rows on each page to help contextualize cell values. How to Print the Header Row(s) on Each Page
HOW DO I CHANGE PRINT AREA IN EXCEL WINDOWS 10
Usually, this just involves selecting the desired printer and hitting the “Print” button, but you may need to change things like color settings here.įor example, on this Windows 10 system, I’ve selected to print the spreadsheet from the “HP ENVY Photo 7100” destination.Īfter following these steps, you’ll soon have a physical printed copy of your spreadsheet. This is what the preview looks like in the example: