![]() ![]() I hope now you know how to set the print area in Excel. Read More: How to Print Multiple Sheets in Excel (6 Suitable Examples) If you open the Page Break Preview of any of these sheets, you will see the selected cell ranges are made as to the print areas. So, Excel is mentioning the module name of the Macro before its name.Īs a result, the selected cells will be set as the print area in all the selected sheets. The Macro, Print_Area was created in Module1 of the VBA sheet but we are using it in other sheets. ➤ Select Module1.Print_Area from the Macro name box and click on Run. ➤ Select the sheets where you want to set the print area by pressing CTRL and clicking on the sheet name from the Status Bar. This Macro will also allow you to set a cell range from multiple sheets as the print area. ➤ Select the cells which you want to set as print areas and click OK in the Input window.Īs a result, Excel will set the selected cells of this sheet as the print area. ➤ Select Print_Area from the Macro name box and click on Run.Īs a result, a window named Input will appear. This Macro will open a window for Input where you can select cells and set the cells as the print area. The code will create a Macro named Print_Area. PrintAreaAddress = PrintArea.Address(True, True, xlA1, False)įor Each Sheet In ActiveWindow.SelectedSheets Set PrintArea = Application.InputBox(" Select a Range for Print Area", Type:=8) ➤ Type the following code in the Module(Code) window, Sub Print_Area() ➤ Go to the Insert tab and select Module. You can create a Macro to set print area in a sheet or multiple sheets by using Microsoft Visual Basic Application (VBA). ![]() Set Print Area in Multiple Sheets Using VBA Read More: How to Set Print Preview in Excel (6 Options)ĥ. ➤ Enclose your desired area to set as print area by dragging the blue lines in your desired location from the outside of the page.Īs a result, Excel will set the boxed area with blue lines as the print area. You can also set the print area from the Page Break Preview option of the View tab. Print Worksheet with Comments in Excel (5 Easy Ways).How to Print Labels in Excel (Step-by-Step Guideline).How to Print Landscape in Excel (3 Easy Methods).Print to PDF in Excel VBA : With Examples and Illustrations.Read More: How to Print Excel Spreadsheet on Multiple Pages (3 Ways) So, in this way you can set multiple print areas in your Excel sheet. You can see that from the Page Break Preview of the View tab. Now, Excel will set these cells as a different print area. ➤ Select cells which are not adjacent to the 1st print area and go to Page Layout > Print Area > Add to Print Area. ➤ Select adjacent cells to the first print area and go to Page Layout > Print Area > Add to Print Area.Īs a result, these cells will be added to the previous print area. Now, if you select adjacent cells to the first print area, the cells can be added with this print area. ➤ Select the cells which you want to set as the print areas. ![]() You can also set multiple print areas in excel. Read More: Excel VBA: How to Set Print Area Dynamically (7 Ways) ➤ Select the cells which you want to set as the print area and click on the Expand icon in the Page Setup – Print area box. ➤ Go to the Sheet tab in this window and click on the Collapse icon from the end of the Print area box. ➤ Go to the Page Layout tab and click on the little arrow icon from the bottom right corner of the Page Setup ribbon. You can also set the print area from the Page Setup Window. Read More: How to Change Print Area in Excel (7 Smart Ways) So, when you will give the command to print, this area will be printed on the first page. You will see in this view the cells which you set as the print area are marked as page 1. ➤ Go to the View tab and select Page Break Preview.Īs a result, your Excel spreadsheet will be shown in Page Break view. ➤ Go to Print Layout > Print Area and select Set Print Area.Īs a result, the selected cells will be set as the print area. ![]() ➤ Select the cells which you want to set as the print area. The easiest way to set the print area is by selecting the Print Area option from the Page Layout tab. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |