![]() When you set a print area in different worksheets, a named range Print_Area is created for each worksheet.The next time you open the workbook, the print area would still be there. When you save the workbook, Excel saves the print area as well.Hence, you can set different print areas in different worksheets. A print area specified using the above steps is specific to that worksheet only.To selected multiple areas, hold the Control Key and make the selection using the mouse. There can be multiple print areas in a worksheet, however, these are printed separately.Here are some important things to know when you set the print area in Excel worksheets. Now when you print this worksheet, only the set print area would be printed. It also creates a named range for the selected area (the name Print_Area would be visible in the Name Box). ![]() This would set the selected cells as the print area.Go to Page Layout –> Page Setup –> Print Area –> Set Print Area.Select the range of cells that you want to set as the print area in that Excel worksheet.Here are the steps to set the print area in Excel: ![]() How to Set the Print Area in Excel Worksheets
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |