Microsoft Tip of the Week Excel: Rows to Repeat at the Top
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.
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.
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.
ReplyDeleteSome 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.).
ReplyDeleteMs 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.
ReplyDeleteThis comment has been removed by the author.
ReplyDelete