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

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 three easy and convenient methods on how to select Column A as titles to repeat on each page in Excel.


Download Practice Workbook

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


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

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

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 (2 Easy Macros)


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


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. Please visit our website Exceldemy to explore more.


Related Articles

Shahriar

Shahriar

Hello! Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. My last educational degree was BSc in Engineering from the Bangladesh University of Engineering & Technology. I am a Naval Architecture and Marine Engineering graduate with a great interest in research and development. I love reading books & traveling. Always try to gather knowledge from various sources and implement them effectively in my work.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo