How to Select Column A as Titles to Repeat on Each Page

Get FREE Advanced Excel Exercises with Solutions!

Need to learn how to select column A as titles to repeat on each page in Excel? If you are looking for such unique kinds of tricks, you’ve come to the right place. Here, we will take you through 3 easy and convenient methods on how to select Column A as titles to repeat on each page in Excel.


Select Column A as Titles to Repeat on Each Page: 3 Ways

Suppose we have the Sales Report 2021 of some sales reps of a certain organization. Here, Column A contains the employee ID. Whereas Column B: F refers to Employee Profile. And, Column G: J serves as Quarterly Sales.

Select Column A as Titles to Repeat on Each Page

Select Column A as Titles to Repeat on Each Page

Here, we can notice that the sheet is quite wide horizontally. It is difficult to get it to fit horizontally on one page. So, some portions from the right side will be printed on another page. Let’s give a visual explanation below.

Select Column A as Titles to Repeat on Each Page

While printing, we were able to print till the column of Zip Code on the first page. On this page, we can see employee information based on their employee ID, which is quite easy to understand.
But, the main problem arises on the next page.

Select Column A as Titles to Repeat on Each Page

We cannot be able to match the Sales amount with the respective Sales rep.
To get rid of this problem, we’ll select Column A as the title to repeat on each page. So, without further delay, let’s see the methods one by one.


1. Using Print Titles Option to Select Column A as Titles to Repeat on Each Page

For our first method, we’ll use the Print Titles option to select Column A as the title to repeat on each page. Follow the steps below.

📌 Steps

  • At first, go to the Page Layout tab.
  • Then, select the Print Titles option on the Page Setup group.

Select Column A as Titles to Repeat on Each Page Using Print titles Option

  • After completing the above steps, the Page Setup dialog box appears.
  • Now, move to the Sheet tab.
  • Here, we can select the Print area as the image below.
  • At this point, click on the upside arrow beside the box of Columns to repeat at left.

Select Column A as Titles to Repeat on Each Page Using Print titles Option

  • By our previous action, the Page Setup dialog box becomes minimized. Rather, it opens a new wizard named Page Setup – Columns to repeat at left.
  • Now, select Column A as shown in the image below.
  • Then, click on the upside-down arrow in the newly opened wizard.

Select Column A as Titles to Repeat on Each Page Using Print titles Option

  • It returns us to the Page Setup dialog box again.
  • We can see our selected column is showing in the box.
  • Finally, select the Print Preview option.

Select Column A as Titles to Repeat on Each Page Using Print titles Option

The preview for the first page should look like the image shown below.

Select Column A as Titles to Repeat on Each Page Using Print titles Option

  • Next, click the arrow at the bottom to go to the second page.

Select Column A as Titles to Repeat on Each Page Using Print titles Option

We can clearly see Column A has been repeated on this page also. Now, it becomes quite easy to correlate the Sales amount with the employee.

Read More: [Fixed!] Print Titles Must Be Contiguous and Complete Rows or Columns


2. Select Column A as Titles to Repeat on Each Page Using File Tab

In this method, we’ll utilize the File tab to select Column A as the title to repeat on each page. So, let’s see it in action.

📌 Steps

  • At the very beginning, select the File tab from the top-left corner of the ribbon.

Select Column A as Titles to Repeat on Each Page Using File Tab

  • At this moment, select the Print option.
  • After that, click on Page Setup.

Select Column A as Titles to Repeat on Each Page Using File Tab

  • Again, the Page Setup dialog box appears.
  • Then, select the options just like we did in Method 1.
  • Lastly, click OK.

Select Column A as Titles to Repeat on Each Page Using File Tab

  • Now, go to the Print Preview.
  • You can see Column A on the left side of both pages.

Using File Tab

Using File Tab

Read More: Print Titles in Excel Is Disabled, How to Enable It?


3. Applying Keyboard Shortcut

In this instance, I’m aware of your thoughts. Do shortcut keys exist? You’re lucky! Yes, shortcut keys exist to do this job more quickly. Follow the steps carefully.

📌 Steps

  • Firstly, press the Alt+P on your keyboard.
  • It will automatically get you to the Page Layout tab and show the available shortcut buttons on the ribbon.

Applying Keyboard Shortcut

  • Afterward, press the S key on your keyboard followed by the P key.
  • Instantly, the Page Setup wizard opens.
  • Now, select the options just as we did in Method 1.
  • Then, click on Print Preview.

Applying Keyboard Shortcut

  • Finally, you’ll see the results as shown in the screenshot below.

Applying Keyboard Shortcut

  • Also, you can use the right arrow button to inspect the second page.

Applying Keyboard Shortcut

Read More: How to Print Titles in Excel Except for Last Page


Practice Section

For doing practice by yourself we have provided a Practice section like below in the last sheet of the workbook. Please do it by yourself.

Practice file


Download Practice Workbook

You may download the following Excel workbook for better understanding and practice yourself.


Conclusion

This article provides easy and brief solutions to select Column A as titles to repeat on each page in Excel. Don’t forget to download the Practice file. Thank you for reading this article, we hope this was helpful. Please let us know in the comment section if you have any queries or suggestions.


Related Articles


<< Go Back to Print Titles | Page Setup | Print in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Shahriar Abrar Rafid
Shahriar Abrar Rafid

Shahriar Abrar Rafid, BSc, Naval Architecture and Marine Engineering, Bangladesh University of Engineering and Technology, Bangladesh, has worked with the ExcelDemy project for more than 1 year. He has written over 100+ articles for ExcelDemy. He is a professional visual content developer adept at crafting scripts, meticulously editing Excel files, and delivering insightful video tutorials for YouTube channels. His work and learning interests vary from Microsoft Office Suites and Excel to Data Analysis, VBA, and Video recording and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo