How to Repeat Table Heading In Every Pages in MS Excel

in #technology2 years ago

When we prepare a data sheet in MS Excel, we have to give some table heading name in to the data sheet. Like First Name, Last Name, Address, City, Mobile number Etc. But when the first page data is full in MS Excel, The data heading not automatically goes in to the second page. And for this reason sometime we are miss communicating with the first page.

This is a very common problem in all excel users. But it has a solution also.

Here is the steps:

  1. Open Excel File.

  2. Go to the page layout option

ggn4ne.png

  1. Then go to the print Titles option

bppep8.png

  1. One Page Set up window open

y4190r.png

  1. In Page Set up window go to the Sheet Option

  2. Then click on rows to repeat at top

mehq8b.png

  1. Then click the rows you want to repeat in the every pages

  2. Now click OK

  3. When the first pages data is full, click the print preview option.

mwhbxf.png

  1. You will find Rows Heading are automatically coming in to the second page.

Those are the very simple steps to repeat the page heading in every pages. And it helps you a lot.

Hope this is workable for you.



@impressions



Sort:  

Thanks for using eSteem!
Your post has been voted as a part of eSteem encouragement program. Keep up the good work!
Dear reader, Install Android, iOS Mobile app or Windows, Mac, Linux Surfer app, if you haven't already!
Learn more: https://esteem.app
Join our discord: https://discord.me/esteem

 2 years ago Reveal Comment