PRINT TITLE, SHEET OPTION, PRINT AREA

Print Title:
MS-Excel provides another awesome feature to helping for print every single page with heading on it. Let me explain about it, most often, we make some quite long workbooks, and they overflow to several pages. Normally we can freeze the top row or top column to view the overflowed data in workbook on every page. However, when we print these long workbooks, the title (top row) disappears and will not be printed in all pages except the first one. Actually, we can specify the Page Setup settings, and print the title (top row) on every page repeatedly.

When a worksheet spans more than one printed page, you can label data by adding row and column headings that will appear on each print page. These labels are also known as print titles. In MS-Excel 2016, Print Titles command will appear inactive if you are in cell editing mode, if a chart is selected on the same worksheet, or if you don’t have a printer installed.

How to get print out with same heading on each and every single page in the worksheet?
Select Page Layout Menu =>
Click Print Titles Tool =>
Keep the cursor in the box “rows to repeat at top” =>
Select your heading or first row (to print on each page) =>
Click OK.

For more understanding, look at the screenshot please:

Sheet Options:
MS Excel provides various sheet options for printing purpose like generally cell gridlines aren’t printed. If you want your printout to include the gridlines, columns titles, and row titles, you can use this tool.

How to choose to get print out data worksheet with columns name and rows numbers?
Select Page Layout Tab =>
Select Print Check boxes such as Gridlines and Headings at the Sheet Options section (Now, you can go and have a look at the print preview).

For more understanding, look at the screenshot please:

Print Area:
When you need to print a specific selection on a worksheet frequently, you can define a print area that includes just that selection. A print area is one or more ranges of cells that you designate to print when you don't want to print the entire worksheet. When you print a worksheet after defining a print area, only the print area will be printed. You can add cells to expand the print area as needed, and you can clear the print area to print the entire worksheet.
 
A worksheet can have multiple print areas. Each print area will print as a separate page.
 
How to set the print area on my current data worksheet?
Select the area of columns and rows in the data sheet that you want to get the print out =>
Select Page Layout Ribbon =>
Click Print Area =>
Click Set Print Area.

For more understanding, look at the screenshot please:

If you have any questions about tools in the Page Layout tab/menu, please state all in the comment box