web analytics

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

First, in your Excel workbook select the sheet that you wish to be printed. The names of the sheets are located in the bottom left corner of the workbook.

02 - print titles group

Then, choose the Page Layout tab from the ribbon and press the Print Titles icon located in the Page Setup group or press Alt + P + I keys.

03 - page setup box

In the appeared Page Setup dialogue box select the Sheet tab if it is not already selected.

04 - columns repeating label

If you want to set particular column as printing title, select the Collapse / expand button in the Columns to repeat at left label from Page Setup dialogue box.

05 - selecting column as printing title

Select the column that you wish to be displayed in all printing pages and press the Collapse / Expand button from the Page Setup collapsed box. You will be returned at the expanded Page Setup dialogue box.

06 - rows repeating label

If you want to set particular row as printing title, select the Collapse / Expand button from the Rows to repeat at top label.

07 - selecting row as printing title

Select the row that you wish to be printing title and press the Collapse / Expand button.

08 - print and preview buttons

In the Page Setup dialogue box you can select Print Preview button to see exactly how the pages will be printed.

09 - backstage screen

If you want to print the pages, select the Print button from the page Setup dialogue box and then select the Print Icon from the backstage screen. To return in the workbook, select the Back button in the backstage screen.

It is important to know that you can set both rows and columns as printing titles on one page in case where the data from the rows and columns spill over to other pages.

10 - page order section

In the Page Order section from Sheet tab in the Page Setup dialogue box you can set the printing order of the pages in the worksheet. Selecting Down, then over prints the pages by vertical order, and selecting Over, then down radio button prints the sheet’s pages by horizontal order.

Press OK from the Page Setup dialogue box if you want to save the changes or press Cancel for canceling the changes and you will get back to the workbook.

Leave a Reply