Print Titles in Excel 13

In Excel we are allowed to Print Titles. What does this mean? We can print particular row and column headings on each page of the report. This feature is quite handy, because Print Titles are important in multi-page reports. Why? Because in multi-page reports, the Print Titles always appears on all the pages of the report. The Rows appear at the top of each page, and the Columns appear at the left of each page. This feature will be described below, all you have to do is to follow the steps:

First, we must select the Page Layout tab and then from the area of the ribbon named Page Setup we select the command Print Titles as shown in the image below.

Page Layout - Print Tiles

Once the Print Titles command is selected, the Page Setup dialog box appears with the Sheet tab activated as shown below.

On the top part of the Sheet tab is the Print Area command, which we can do the following:

We can define any cell selection on a worksheet as the Print Area. All we have to do is to type in the area that we want to define as a Print Area or we can select the Collapse/Expand button at the right of the Print Area command. Once selected the Page Setup dialog box minimizes and the Worksheet becomes activated. Then all we have to do is to select with our mouse the area that we want do define as a Print Area, then select the Collapse/Expand button again and we return to the Page Setup dialog box and we notice the area that we defined in the text box.

Page Setup - Print Area

Once we have defined the Print Area, Excel will print the cell selections every time we decide to print the Worksheet.

Under the Print Area of the Sheet tab, is located the Print Titles area where we can do the following:

  • Rows To Repeat At Top: We can define the Rows to repeat by typing in the text box the Rows that we want to be repeated at the top of each page in the Worksheet, or we can select the Collapse/Expand button on the right of the command. Once selected the Page Setup dialog box minimizes and the Worksheet becomes activated. Then all we have to do is to select with our mouse the Rows that we want to Repeat at Top, then select the Collapse/Expand button again and we return to the Page Setup dialog box and we notice the Rows in the text box.

Columns To Repeat At Left: We can define the Columns to repeat by typing in the text box the Columns that we want to be repeated at the Left of each page in the Worksheet, or we can select the Collapse/Expand button on the right of the command. Once selected the Page Setup dialog box minimizes and the Worksheet becomes activated. Then all we have to do is to select with our mouse the Columns that we want to Repeat at Left, then select the Collapse/Expand button again and we return to the Page Setup dialog box and we notice the Columns in the text box.

Page Setup - Sheet - Print Titles

On the Sheet tab of the Page Setup dialog box is located the Print Area as shown in the image below. In this area we can do the following:

  • Gridlines: We can activate or deactivate the check box in order to print or not the Gridlines of our Worksheet.
  • Black and White: We can activate or deactivate the check box in order to print or not in Black And White.
  • Draft Quality: We can activate or deactivate the check box in order to print in Draft Quality.
  • Row And Column Headings: We can activate or deactivate the check box in order to print or not the Row And Column Headings, meaning A, B, C, D, etc. and 1, 2, 3, 4, etc.
  • Comments: We can select to print the Comments on our Worksheet from None, At The End Of The Sheet and As Displayed on Sheet.
  • Cell Errors As: We can select to print the Cell Errors on our Worksheet from one of the following, Displayed, <Blank>, and #N/A.

Page Setup - Print

On the Sheet tab of the Page Setup dialog box is located the Page Order as shown in the image below. In this area we can activate either to print Down, Then Over or Over, Then Down.

Print Order

At the bottom right corner of the Sheet tab of the Page Setup dialog box, we can select the following buttons:

Print: Once selected we will be transferred to Backstage View in order to Print our Worksheet.

Print Preview: Once selected we will be transferred to Backstage View in order to Preview our Worksheet.

Options: Once selected the Print Options dialog box will appear in order for us to do the adjustments that we want.

Whatever adjustments we do on the Sheet tab of the Page Setup dialog box, we must press the OK button which is located at the bottom in order for them to take place.

Below you can check out the video describing all the features available on the Sheet tab of the Page Setup dialog box in Excel 13.

Print Titles in Excel 13

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on May 5, 2015, in Excel English 2013, Microsoft Office 2013 English and tagged , , , , , , , , , , , , , , , , , , , , , . Bookmark the permalink. Comments Off on Print Titles in Excel 13.

Comments are closed.