how to repeat rows in excel
this tutorial also shows you convert image to text, you can print same heading in all the pages in excel sheet or headers or heading (also called print titles) on every page. For example, you can repeat the first row of column header on all pages when you have large, complex worksheets. This allows you to view the same rows at the top of a column on each page so that you know what every column stands for in the printed spreadsheet. You will also see how to do this for columns when your data is organized left to right instead of up to down. This is a great tutorial to view to increase the usability of printed spreadsheets and simply to make them much easier to read and understand.
This tutorial shows you how to repeat single row and column as well as multiple row and column on every page of the printed Excel spreadsheet.
Select the Excel worksheet that you want to print.
Follow these steps repeat row & column titles on every print page from excel
On the worksheet that you want to print, in the Page Layout tab, click Print Titles , in the Page Setup group).
Note: The Print Titles command will appear dimmed if you are in cell editing mode, if a chart is selected on the same worksheet, or if you don’t have a printer installed. For more information about installing a printer, see finding and installing printer drivers for 7. Please note that Microsoft has discontinued support for Windows xp; check your printer manufacturer's Web site for continued driver support.
On the Sheet tab, under Print titles, do one—or both—of the following:
In the Rows to repeat at top box, enter the reference of the rows that contain the column labels.
In the Columns to repeat at left box, enter the reference of the columns that contain the row labels.
For ex., if you want to print column labels at the top of every printed page, you could type $2:$2 in the Rows to repeat at top box.
Tip: You can also click the Collapse Popup Window buttons at the right end of the Rows to repeat at top and Columns to repeat at left boxes, and then select the title rows or columns that you want to repeat in the worksheet. After you finish selecting the title rows or columns, click the Collapse Dialog button again to return to the dialog box.
~-~~-~~~-~~-~
Please watch: "Schedule message or sms to send automatic birthday or anniversary messages to wish 12 night "
• Schedule message or sms send automatic bir...
~-~~-~~~-~~-~