![]() You can see that from the Page Break Preview of the View tab. ➤ Select adjacent cells to the first print area and go to Page Layout > Print Area > Add to Print Area.Īs a result, these cells will be added to the previous print area. Now, if you select adjacent cells to the first print area, the cells can be added with this print area. ➤ Select the cells which you want to set as the print areas. You can also set multiple print areas in excel. ➤ Select the cells which you want to set as the print area and click on the Expand icon in the Page Setup – Print area box. ➤ Go to the Sheet tab in this window and click on the Collapse icon from the end of the Print area box. ➤ Go to the Page Layout tab and click on the little arrow icon from the bottom right corner of the Page Setup ribbon. You can also set the print area from the Page Setup Window. So, when you will give the command to print, this area will be printed on the first page. You will see in this view the cells which you set as the print area are marked as page 1. ![]() ➤ Go to the View tab and select Page Break Preview.Īs a result, your Excel spreadsheet will be shown in Page Break view. ![]() ➤ Go to Print Layout > Print Area and select Set Print Area.Īs a result, the selected cells will be set as the print area. ➤ Select the cells which you want to set as the print area. The easiest way to set the print area is by selecting the Print Area option from the Page Layout tab.
0 Comments
Leave a Reply. |