#CHANGE PRINT AREA IN EXCEL 2010 DOWNLOAD#
The easiest way is to download our sample workbook with Print Area Macros and run a macro directly from that workbook. SelectedPrintAreaRangeAddress = SelectedPrintAreaRange.Address(True, True, xlA1, False)įor Each Sheet In ActiveWindow.SelectedSheets If Not SelectedPrintAreaRange Is Nothing Then Set SelectedPrintAreaRange = Application.InputBox("Please select the print area range", "Set Print Area in Multiple Sheets", Type:=8) When multiple sheets are selected, the active sheet is the one which is visible when you run the macro.ĭim SelectedPrintAreaRangeAddress As String This macro automatically sets the print area(s) for all selected worksheets the same as on the active sheet. Set print area in selected sheets as on the active sheet If you have to print the same area on multiple sheets regularly, the use of VBA can speed up things.
#CHANGE PRINT AREA IN EXCEL 2010 HOW TO#
Luckily, there is an easy workaround described in How to print the same range in multiple sheets. The problem is that selecting several sheets disables the Print Area button on the ribbon. In case you have a lot of worksheets with exactly the same structure, you will obviously want to output the same rage on paper. How to set print area in Excel for multiple sheets with VBA In the new sheet, press Ctrl + P to print all the copied print areas on one page.Repeat steps 1 and 2 for other print areas.On a new sheet, right click any blank cell and choose Paste Special > Linked Picture.Select the first print area and press Ctrl + C to copy it.With the help of the Paste Special feature, you can link the copied ranges to the original data in this way: If your printer has such an option, lucky you are :) If there is no such option, then the only way I can think of is copying the print ranges to a new sheet. To check if this option is available to you, press Ctrl + P, click the Printer Properties link, and then switch through the available tabs of the Printer Properties dialog box searching for the Pages per Sheet option. The ability to print multiple areas per sheet of paper is controlled by a printer model, not by Excel. Under Settings, click the arrow next to Print Active Sheets and select Ignore Print Area.When you want a hard copy of a whole sheet or entire workbook but do not want to bother clearing all the print areas, just tell Excel to ignore them: Adjacent ranges, even selected separately, will be included in a single print area. This only works for non-contiguous ranges. To select multiple ranges, please remember to hold the Ctrl key. On the Sheet tab, put the cursor in the Print area field, and select one or more ranges in your worksheet.This will open the Page Setup dialog box. On the Page Layout tab, in the Page Setup group, click the dialog launcher.Want to visually see all your settings? Here's a more transparent approach to defining a print area: More informative way to define print area in Excel On the Page Layout tab, in the Page Setup group, click Print Area > Set Print Area.Ī faint gray line will appear denoting the print area.Select the part of the worksheet that you want to print.The quickest way to set a constant print range is this: To instruct Excel which section of your data should appear in a printed copy, proceed in one of the following ways. Without it, you may end up with messy, hard to read pages where some important rows and columns are cut off, especially if your worksheet is bigger than the paper you are using. If you change your mind at a later point, you can clear the print area or change it.ĭefining a print area gives you more control over what each printed page looks like and, ideally, you should always set a print area before sending a worksheet to the printer. Saving the workbook also saves the print area. You can select multiple print areas in a single worksheet, and each area will print on a separate page. When you press Ctrl + P or click the Print button on a sheet that has a defined print area, only that area will be printed.
In case you don't want to print the entire spreadsheet, set a print area that includes only your selection. This feature is known as Print Area.Ī print area is a range of cells to be included in the final printout. But what if you don't really need all the content of a huge worksheet on paper? Luckily, Excel provides the ability define the parts for printing. When you hit the Print button in Excel, the entire spreadsheet is printed by default, which often takes multiple pages. In this tutorial, you will learn how to select print area in Excel manually and how to set print ranges for multiple sheets by using macros.
0 kommentar(er)
