Print

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 […]

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 >> <<

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

Print Titles in Excel Print titles is used to print rows and columns on every page, making the printed document easier to read. Below are the steps to do this. 1. Click Page Layout and then click Print Titles. 2. In the dialog box, if you want the second row to be printed on each

Insert Page Numbers in Excel To insert page numbers in Excel, follow the steps below. 1. Click View tab -> Page Layout. 2.   Click on the “Click to Add Footer” area at the bottom of the sheet. 3. On the Design tab, click Page Number. Note: Excel adds a Page variable in the footer so

Header and Footer in Excel In this lesson, you will learn how to add header and footer information at the top and bottom of each printed page, respectively. To insert a header, follow the steps below. 1. Click the Page Layout on the View tab. 2. Click Add header and then, from the Design tab,

Insert Page Breaks in Excel Excel page breaks are important when it comes to printing a worksheet. By inserting page breaks, you can define where the next page will start while printing the sheet. To insert a horizontal page break, follow the steps below. 1. Select the row where you want the next page to

Workbook Views in Excel Normal | Page Break Preview | Page Layout In Excel, there are three types of workbook views- Normal, Page Break Preview, and Page Layout. Normal 1. To see your Excel spreadsheet in a normal view, click “Normal” on the View tab. Note: Sometimes, due to switching back and forth to/from different

Print Your Excel Work Entire Worksheet | Current Selection | Multiple Copies | Change Orientation | Adjust Page Margin | Worksheet Scaling In this lesson, you will learn how the print option in Excel works and how to change some of its settings. Print Entire Worksheet Follow the steps below to print an Excel worksheet.