If you set a printable area in Excel, only that specified area will be printed. The printable area is preserved when the book is saved.
To set the print area, follow the instructions below:
- Select a range of cells.
- On the Advanced tab Page Layout (Page Layout) click Print Area (Print area) and select Set Print Area (Ask).
- Save, close and reopen the Excel file.
- On the Advanced tab Fillet (File) click on Print (Seal).Result: Look at the preview, which is shown in the figure below. As you can see, only the specified area will be printed.
- Use Name Manager (Name Manager) to edit and delete print areas.
