![]() 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |