Skip to main content

How to Print Headings on Every Page in Excel?


Repeat Column Headings on Every Page


Sometimes you may need to print same column headers on every page in Microsoft Excel. And to do so, you don't need to manually copy the headers on every page. You can simply set a command from page setup option to print column headers on every page automatically! 

In my previous post, I discussed about how to lock or freeze column headers. By freezing rows or columns, you can just show headers at the time of scrolling. But they will be printed on the first page only.  In this tutorial, you will learn - how to print same column headers on every page automatically .  .  .


Applies to:
  • MS Excel 2000/ XP
  • MS Excel 2007/ 2010/ 2013
Note: This tutorial has been prepared using Excel 2013. So, few options may differ slightly.


Let's start - 
  1. Open a previously saved worksheet or create a new one in MS Excel.
  2. Go to the Page Setup option from Page Layout Tab (Office XP/ 2000 users should find it under Edit Menu).
  3. Go to the Sheet tab from Page Setup.
  4. Look at the Print titles option: Rows to repeat and Columns to repeat.
  5. To repeat the headers at the top, click on the first one. Or click on the second one to repeat the columns.
  6. After clicking the box, select the area of your sheet which needs to be repeated. Follow the image below.
  7. Hit OK to close the Page Setup. Done! Now check by printing or look at the print preview. 

Repeat Headers in Every Page



Here I showed the process for rows only. You can also choose columns to repeat by the same way. And I've also uploaded a same sheet for you. Download the sheet from the link below:






Open the above sheet. You will find a worksheet named Rows to Repeat. I've set top 3 rows to be repeated on every page. You can directly check it by printing this two-page worksheet. Or simply check it in Print Preview. 


Hopefully, today's topic will be helpful for your study or office work . . . :)





Stay with Marks PC Solution to get more interesting IT topics!


Comments

Popular posts from this blog

GTA San Andreas Cheat Code (PDF)

After Vice City, San Andreas is the most popular game released by Grand Theft Auto (GTA). Usually GTA releases role playing game. San Andreas is such a game where you can act like a person. You can do everything. You have to take part in missions and complete them.  To make your missions easier, there are lots of cheat codes. If you can properly apply these codes, the tough parts of the game will be easier. Cheat codes are somewhat like keyboard shortcuts of computer programs.  I've shared 63 cheat codes below. There were more cheat codes in my collection, but I've omitted the less important cheats. Effects or result of the cheats are on the left side, and the codes are on the right side.  You can copy the following codes in your PC. And for your convenience, I've also uploaded a PDF file of these codes. You will find the download link at the bottom.  Effect Cheat Code Adrenaline Mode MUNASEF All Cars Explode ALL...

Office 2016 Activator (KMSPico 10.1.5)

It's been couple of months after the release of final version of Microsoft Office 2016. And maybe you're tired of finding for a working activator for this version. Today I'm gonna share Office 2016 activator with you - no more waiting!! About the Activator   Name: KMSPico 10.1.5 File Size: 3 MB (Approx) File Type: Zipped Folder 100% Neat & Clean - No virus! Activating Capacity . . . KMSPico 10.1.5 is successfully leading the KMS world for last few months. If everything is okay, success rate is 100%. This tool has been tested and verified by Marks PC Solution. With this tool, you can activate -  Office 2016, 2013 & 2010 Windows 10, 8.1 & 8 Hopefully this version will work for both 32 bit & 64 bit versions of Windows. Installing Office 2016 Collect/ Download Office 2016 Professional Plus from Microsoft or somewhere else. Install it as trial version without any key. Use the follow...

Joining Texts from Multiple Cells in Excel

  Programs like MS Excel is full of functions. There are many useful functions that we don't use or we don't know about. One of them is CONCATENATE. It means joining or linking. With this function you can join texts from multiple cells. Let's see how . . . Suppose you're working in an Excel Worksheet where you need to combine texts from different cells. I'm gonna show you an example. Let's consider the image below -    What do you see ? I've imputed First Name and Last Name. In Full Name column I've used the formula i.e. CONCATENATE. And in the last column I've added Mr. with the full name.    So how do you use this formula ? Here it is -  =CONCATENATE(A2," ",B2) Observe it carefully. You can add more than 02 cells with this functions. Here I've just used 02 cells. You may think what is this " " for ? You may notice that there is a space between the two i.e. " & ".  If you don't use " " then you...