Set a Print Area in Excel Excel prints the print area set by the user. To learn how to set a print area in Excel, follow the steps below. 1. Select a range of cells. For instance, we select B2:C9. 2. Click Page Layout -> Print Area -> Set Print Area. 3. Click Save to … Read more
Print Gridlines and Headings in Excel To print Excel Gridlines and Headings, follow the steps below. 1. Go to the Page Layout tab. 2. Check Print under both Gridlines and Headings. 3. To see the print preview, click File tab -> Print. 8 of 9 finished! Recommending more on Print Setting: Next Example >> << … Read more
Center on Page in Excel If you want a range of cells to be printed at the center on-page, follow the steps below. 1. Click File tab -> Print -> Normal Margins -> Custom Margins. 2. On the Page Setup dialog box, check Horizontally and Vertically boxes. 3. Click OK. 7 of 9 finished! Recommending … Read more
