EXCEL REPEAT COLUMN HEADING ON EACH PAGE...( HOW TO REPEAT EXCEL SHEET COLUMN HEADING AT TOP OF THE PAGE )

HOW TO REPEAT EXCEL SHEET COLUMN HEADING AT TOP OF THE PAGE 

This is one excel features available for formatting in  Excel sheet. use this features if  you want to repeat title of row or a column heading.this is use like a header format in print of excel sheet.

If you would like a title row (or rows) to print at the top of every page of your data in Excel use this function.

1. Click on the [Page Layout] tab > in the "Page Setup" group, click on [Print Titles].

2. Under the [Sheet] tab, in the "Rows to repeat at top" field, click the sheet icon.

3. Click and select the row you wish to appear at the top of every page.

4. Press the [Enter] key, and then click [OK].

5. Select File > Print > "Show Print Preview" to see what the printed spreadsheet will look like.

6.Click on [PRINT] button and see the heading on top.


NOTES:

  • If you want column headings to remain at the top of your sheet when scrolling within a spreadsheet, you will need to freeze the top row
  • If the [Print Titles] button is locked (grayed out), it may be because you are currently editing a cell or you have chart selected. If the "Rows to repeat at top" spreadsheet icon is locked, it may be because you have more than one worksheet selected within your workbook. To unlock either button, you can also try clicking [File] > "Print" > "Page Setup."


Comments

Post a Comment

Popular posts from this blog

How to keep yourself always positive

Image
  How to keep yourself always positive Guys, it is very important to always be positive in our life because bad times are sure to come in this run of life. Whether you want it or not, bad times do come. There are ups and downs in everyone's life, at times, the situation becomes such that negativity fills in you and you stop thinking about your success because you find it very difficult and difficult to achieve success and you get frustrated and that does not allow you to move forward. Then also it also keeps you backwards but by keeping yourself positive even during difficult times, you can stay away from negative thoughts and think about your success. How to Stay always Positive Stay Positive Nowadays, it is also said that a person is identified only in his bad and difficult times because in the good times of life, everyone is able to take the right decision but in the bad time who chooses the right decision. From this type of situation, the right talent of a person can
Read more

A. P. J. Abdul Kalam Biography (11TH PRESIDENT OF INDIA):

Image
  A. P. J. Abdul Kalam Biography Dr. APJ Abdul Kalam Azad was the 11th and first non-politician president of India. The country still remembers him because of the important and outstanding work done by him for the progress of the country of India, APJ Abdul Kalam still has a rare respect in the heart of all the countrymen. He was the most popular and popular president of the public. Along with this, APJ Abdul Kalam was also a famous Indian aerospace scientist who gave a new direction to India by making his significant contribution in the field of technical and science. Dr. APJ Abdul Kalam Azad was such a great man of the country who first flew 'Agni' missile in the country. Hence he is also known as Missile Man of India. APJ Abdul Kalam was an eminent scientist with visionary thinking, an influential orator with a great personality and an honest and skilled politician. He is an inspiration to everyone's life, he has touched immense heights of success in his life by go
Read more

BIOGRAPHY OF DALAI LAMA

Image
BIOGRAPHY OF DALAI LAMA 14th RELIGIOUS GURU Dalai Lama:  14th follower of Buddhism and the 14th religion Guru  There are some people in the world, whose personality affects not only the people around them, but also people all over the world. The Dalai Lama is one of them. Today most of the people of the world know him. He travels all over the world and gives a message of peace to the people. Many people know the Dalai Lama as a religious teacher, but very few people know him personally. The Dalai Lama is the 14th religious leader of Tibet and the biggest follower of Buddhism. His name is Tenjin Gyasto, who is currently the national president of Tibet. Apart from this, he is also known as the patron saint of Tibet. The Dalai Lama has played an important role in giving Tibetans their human rights. The Dalai Lama has also been awarded the Nobel Peace Prize for his outstanding work for peace in the world. Although, the Dalai Lama faced considerable rebellion from China, he was
Read more

2 OCTOBER GANDHI JAYANTI:

Image
  2 OCTOBER GANDHI JAYANTI 151st Gandhi Jayanti In Indian festivals, Gandhi Jayanti- 2 October is also considered an important festival. It is celebrated in the pious remembrance of Father of the Nation Mahatma Gandhi on 2 October. From the point of view of Mahatma Gandhi's ambition, we can say that October 2: Gandhi Jayanti has not only national importance but also social and cultural importance. How 2 October Gandhi Jayanti is celebrated: - In India, What is the reason for celebrating Gandhi Jayanti as a national festival? When we consider it. So we get the answer very easily. That is, Mahatma Gandhi was such a great man of our country, who put his full benevolence  in charity. He was such a divine figure who provided the weapon of truth and non-violence to break the shackles of subordination. Wrote the immense power and influence of the British Empire with this immovable weapon, wrote a new chapter in world history. The whole world accepted this wonderful weapon of his ple
Read more

Sneaky Stones Moral Story

Image
  Sneaky Stones Moral Story Sneaky Stones Moral Story A long time ago, a craftsman went to find a stone in the forest to make an idol. He found a very good stone there. He was very happy to see that and said that it is very right to make the idol. When he was coming, he found another stone. He also took that stone with him. On his way home, he picked up the stone and started working on it with his tools. When the tools were hit on the stone, the stone started saying, "Leave me, it is hurting me a lot." If you hurt me, I will fall apart. You make an idol on some other stone. The craftsman was pity on hearing the stone. He left the stone and started making the idol with another stone. That stone did not say anything. In some time the craftsman made a very good idol of that stone. The people of the village came to collect the idol after it was built. They thought that we would need another stone to break the coconut. He also took the first stone kept there with him. Taki
Read more