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...
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 suc...
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 conside...
Read more

BEST PERSONALITY QUOTES:

Image
  BEST PERSONALITY QUOTES: PERSONALITY: Personality  is defined as the characteristic sets of Behaviours , cignitions , and emotional  patterns that evolve from biological and environmental factors.  While there is no generally agreed upon definition of personality, most theories focus on motivation  and psychological  interactions with one's environment. SOME BEST QUOTES ON PERSONALITY ARE: 1.There is nothing more attractive than a great positive personality. Its beauty never fades away with time. Edmond Mbiaka 2. An attitude of positive expectation is the mark of the superior personality. Brian Tracy   3. Beauty attracts the eye but personality captures the heart. Anonymous   4. Your personality is what makes you beautiful. Anonymous   5. An ugly personality destroys a pretty face. Anonymous   6. Personality has power to uplift. Paul P. Harris   7. I want freedom for the full expression of my person...
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 wo...
Read more