Tuesday, January 6, 2009

Microsoft Tip of the Week Excel: Repeat Rows At Top

Microsoft Tip of the Week Excel: Rows to Repeat at the Top
Sometimes it is necessary to have the column headers to print on every Excel Spreadsheet. This can be done using the Rows to repeat at the top option found on the Page Layout Ribbon.
Click on the Page Layout Ribbon and locate the Sheet Options launch arrow.
A new Page Setup box will appear.
Click on the small box next to the Rows to repeat at top. A new Page Setup-Rows to repeat at top box will appear requesting which rows you would like to repeat.
You can click on the row number to highlight the area or highlight manually using your mouse.

Once you have the correct information entered, click on the box again to return to your Page Setup box.
Click OK to secure your task and return to your spreadsheet.


  1. Yesterday I worked with excel sheet and saved all info.But today all data were lost.And I used-Excel repairs,this tool I saw in one forum.It is free as far as I know,besides that tool can recovered contents and export of recovered data into a new document in Microsoft Excel format.

  2. Some days ago I worked with my excel file and after that something happened and it was damaged.But I entered in google and found there-how to repair an excel file 2007.Program helped me in 30 seconds and composed it for free.Moreover I knew that tool recover after attack viruses, problems with media (a hard drive failure, a corrupted CD or DVD, etc.).

  3. There are all of Office programs on my computer. But a lot of problems usually I have with MS Excel files. And one day I opened my MS Excel and understood that all my data was lost. Fortunately I have the Internet and used there - repair corrupted .xls file. The software solved my issue for seconds and for free as far as I remember. Besides I advised it for my friend and he was very glad..

  4. Ms Exceed makes tasks simpler for the individual by offering entertaining help by simply simply clicking a option that will help you will all features of the worksheet.

  5. This comment has been removed by the author.