Shahriar Abrar Rafid
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.
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.
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.
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.
- 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.
- 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.
- 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.
The preview for the first page should look like the image shown below.
- Next, click the arrow at the bottom to go to the second page.
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.
- At this moment, select the Print option.
- After that, click on Page Setup.
- Again, the Page Setup dialog box appears.
- Then, select the options just like we did in Method 1.
- Lastly, click OK.
- Now, go to the Print Preview.
- You can see Column A on the left side of both pages.
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.
- 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.
- Finally, you’ll see the results as shown in the screenshot below.
- Also, you can use the right arrow button to inspect the second page.
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.
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.
