When we print this worksheet, only these cells will show. The selected range of cells is now set as the print area.We will click Print Area as shown in figure 2 and select Set Print Area.Select the range of cells that we want to set as the print areaįigure 2: Clicking Page Layout for Setting Print Area.In setting print area, we will do the following: It is also possible to change the print area by adding cells to the print area or clearing the entire print area to print the full worksheet. After we have defined the print area, only that area will be printed. How to set the print area or how to print a rangeįigure 1: How to Set Print Area What is Print Area ?Ī print area consists of a range of cells that we select to print when we don’t want to print the whole worksheet.By following the simple steps below, this tutorial will walk all Excel users through the process of: We can set a print area to print only a certain part of our sheet. How to Set Print Area in Excel – Excelchat
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |