![google excel set print area google excel set print area](https://deasilex.com/wp-content/uploads/2021/11/Indo-pacific-regional-webinar-Responses-Google-Sheets-Google-Chrome-11_5_2021-9_24_33-AM-1024x459.png)
Now, back on the Home tab, let’s switch to a more demanding worksheet – this sheet has a large Pivot Table on it. I can also adjust the Scaling to fully utilize the width of the page. To quickly make all of this worksheet fit on one page, all I have to do is drag the dashed line to the far left (note my 2-headed mouse pointer as I point to that dashed line), telling Excel to make all of the columns fit on one page.Ī quick switch to the Print Preview on the File tab shows me more clearly how my changes will affect the printout of my worksheet, and I can make one change here – switching to Landscape orientation to let the columns spread out over a larger area horizontally. The watermarks and in gray also show you how many pages you’ll print out on. Here, as I switch to that view, you can see the same workbook, and the dashed line showing where that split, which puts the last 5 columns of the worksheet on page 2, occurs.
![google excel set print area google excel set print area](https://i.ytimg.com/vi/9xUnY3taj78/mqdefault.jpg)
As you can see here, my worksheet is too wide to fit entirely on a sheet of 8.5 x 11 paper, so it’ll take 2 sheets, and about half of the columns are going to end up on page 2.Īs I demonstrate in our video on Printing, you can use the various settings here in the Print view to change your paper size, reduce the margins, switch the orientation of the pages, even apply scaling to shrink your content to fit on the desired number of pages.Īnother way to (A) find out how your worksheet will print out and (B) make changes to how the content spreads out over one or more sheets of paper is to work in Page Break Preview, one of your view options on the View tab. (In place of the Sheet1 sheet used in the example.When you go to print one of your worksheets – or even an entire workbook – it’s the Print preview through the File tab’s Print command that tells you how your data will lay out on the pages. Note that you should change the formula, in step 5, to use whatever sheet name you specified in step 4. Now, anytime you print, the print range will be grabbed from whatever is in cell C7.
![google excel set print area google excel set print area](https://cdn.allthings.how/wp-content/uploads/2021/05/allthings.how-how-to-set-print-area-in-google-sheets-image.png)
GOOGLE EXCEL SET PRINT AREA HOW TO
If the cell being changed is C7, then the PrintArea property is updated to reflected whatever is in cell C7.Įven though Grahame asked for how to set the print range in a macro, it should be noted that you can automatically set the print range without using a macro. The Worksheet_Change event handler is automatically run every time there is a change in the worksheet. Private Sub Worksheet_Change(ByVal Target As Range)Ī = Target.Value (Just right-click the sheet tab and choose View Code, then add the macro there.) To do so, just add this to the VBA module for the worksheet. You can, if you desire, create an event handler that will change the print area every time that cell C7 is changed. Thus, if cell C7 contains a range (like B8:B207), you could do it in this manner:Ī = Range("C7").Value Note that all you need to do is to assign to the PrintArea property a range that you want used for your print range. Setting a print range within a macro is quite easy you can do it in this manner:Ī = "$A$1:$D$23" However, Grahame is unsure of how to set the print range within the macro code. Whenever the range changes in C7, he needs a way to change the print range to match what is in that cell. Grahame has a cell (C7) that contains a range, such as B8:B207.