web analytics

Tag Archives: PRINTING TITLES IN MS EXCEL

PRINTING TITLES IN MS EXCEL 2013

Microsoft Excel 2013

If you need to print a sheet which is consisted of many rows or columns filed with data, you can use the MS Excel feature that enables you to print particular rows and columns (labels) as headings of the pages. With this feature called Print Titles, you can “freeze” the selected rows or columns and you can make them visible on the other pages from the sheet. Print Title option should not be confused with the printing of the header of the report, which is also printed in the top margin of every page. Print Titles prints the headings at the top if the rows are used as print titles and on the left in the case of printing the columns as headings.

01 - selecting a sheet