fasadgarden.blogg.se - Excel set print area 2010

EXCEL SET PRINT AREA 2010 HOW TO
EXCEL SET PRINT AREA 2010 CODE

The error is generated when we have not turned on the communication to the printer. Run-time error ‘1004’: Unable to set the FitToPagesTall property of the PageSetup class

EXCEL SET PRINT AREA 2010 CODE

While the above code would work perfectly, in fact, it is more correct to set the FitToPagesTall = 0 to make it Automatic, but this command would generate an error

To set Print Area in Excel VBA, we have to use PageSetup.PrintArea Property.įor example, in order to set Print Area A1:N21, we can write Public Sub printArea()Ī = "$A$1:$N$21"Įnd Sub Excel VBA set page width and heightĪfter we have defined the Print Area, the next step is to set the page width and height.įor most of the time, we want the page Width to be 1 page, while the height is Automatic, meaning we let Excel decide how many pages to print depending on how many rows are in the data, we just need to ensure all the field headers are displayed in one page. To set Print Area in Excel spreadsheet, first select (highlight) Cells that we want to set as Print Area, and then navigate to ribbon Page Layout > Print Area > Set Print Area

EXCEL SET PRINT AREA 2010 HOW TO

Make sure to print the document before you close and reopen it.This Excel VBA tutorial explains how to set print area, page width, Print Title, Orientation in Excel VBA. When you close the Excel file, the print areas will be automatically removed. Make sure to check out our section on printing tutorials for Excel so you can see other tips for making your printed spreadsheets look nice. Setting the print area for a worksheet is one of the most useful tips for printing in Excel, especially when working on large spreadsheets, but it is not the only tip for printing in Excel. Go to Page Layout tab > Print Area > Clear Print Area: Remove a Set Print Area so the Entire Worksheet will Print Again But, how it looks will depend on your data setup and the other print options that you choose. Here, Excel put both sections on different pages and, given that our printed data set is quite small, it doesn't look so great.

Go into Print Preview and you can see how they will print (File > Print in excel 2010 and later - File Print Preview in Excel 2003 - Office Button > Print > Print Preview in Excel 2007):.

Those specific sections are now ready to be printed:.

Now, if you want to select more areas to print, simply repeat steps one and two as much as needed, except that instead of clicking Set Print Area, you will now click Add to Print Area:.

Once you do this, you will see a dotted outline around the area that you just set to be printed:.

Go to the Page Layout tab and click the Print Area button and then click Set Print Area (for Excel 2003, go to the File menu and then Print Area and then click Set Print Area):.

(If you are printing multiple sections on your worksheet, you can select these sections by hitting Ctrl and selecting them now or wait for step 4):

Select the part of your data that you want to print.

Steps to Print Specific Parts of a Worksheet in Excel You can select a single part of a worksheet or multiple parts of a worksheet to print.

This allows you to select sections of important data to print without having to move those sections of data to other spreadsheets in order to print them. In Excel you can select parts of a worksheet to print while ignoring all of the other data on the worksheet.