The code will create a Macro named Print_Area. This Macro will open a window where you can input the selected cells and set the print area. To apply the Macro for a single sheet, press ALT+F8. Select Print_Area
A print area is a range of cells in Excel, you specify or make it fix for printing. So when you give a print command, it only prints that specific range. You can have multiple print areas in a single sheet and then save that file to save the print area and the file. In Excel, ...
Method 2 – Setting Print Area Dynamically Using VBA FIND Function➤ Follow Step-02 of Method 1. ➤ Enter the following code:Sub setting_printable_area_2() Dim sht As Worksheet Dim last_entry As Integer Set sht = Worksheets("FIND") last_entry = sht.Cells.Find("*", SearchOrder:=xl...
1. Select the cell range to print. 2. Go to the Page Layout Tab. 3. Click the Print Area button. 4. Click Set Print Area. Read more here.
Tip: To set multiple separate print areas at once, hold theCtrlkey and sequentially select each range. The selected ranges will appear in the Print area address box, separated by commas. Click theOKbutton. The specified range is now set as a print area. After that, only this area will be...
To set multiple print areas in your sheet, hold Ctrl as you select each group of cells. Here, we selected cells A1 through F13, held the Ctrl key, and then selected cells H1 through M13. Next, head to the Page Layout tab and pick "Set Print Area" in the Print Area drop-down box...
Follow these steps if you want to expand the existing print area by adding cells: Note: You can only add adjacent cells to an existing print area. Meaning if you wanted to extend the print area, you can only do so by selecting the rows next to the last row of the current selected pr...
Clear a print area Set one or more print areas On the worksheet,select the cellsthat you want to define as the print area. Tip:To set multiple print areas, hold down the Ctrl key and click the areas you want to print. Each print area prints on its own page. ...
In Microsoft Excel 2003/XP/2000/97, I don't want to print all of the data in the sheet. How can I set the print area so that only a portion of the sheet shows up on when I print?
Setting a print area is simple and straightforward. Just open an Excel worksheet and highlight the cells you want to print. Click the “Print Area” option on the Page Layout tab, and in the “Page Setup” section select “Set Print Area.” ...