Asked By
John Bryant
0 points
N/A
Posted on - 08/27/2011
Good evening,
I have to prepare a table of accounting states. It contains about 40,000 records. And it takes more then 300 pages. But the problem is I have to set the row headings for every page manually. It is a burden for me.
How do you set it automatically? Is there any macro available for this?
Thanks
John Bryant
Answered By
Peter123
0 points
N/A
#118709
How to set row headings for 300 pages?
Hello!
When we work on Excel it happens commonly that our data goes beyond the multiple pages and we want to have first row printed at the start of every page so as to help the reader in understanding the information in a comfortable way.
Excel provides a wide range of features for handling spreadsheet with a flexibility of printing such header rows. To print your header rows at the top of every page apply these settings to your page layout.
-
Go to Page Layout and click on the Print Titles under Page Setup.
-
In the Page Setup, Under Print titles, click the red arrow icon next to Rows to repeat at top.
-
use the arrow to select the first row or the row that you want to repeat in each and every page that is printed.
-
Use the red arrow icon again and you will be taken to Page Setup screen. Click Ok.
-
Now are almost done but remember that this feature is not available in the earlier versions you must have at least Office 2007.
Hope it helps.
Regards
How to set row headings for 300 pages?
Hi John,
Based on my research this is what I found.
-
To affectation row headers on assorted pages:
Â
-
Right-click the row, column, or bend handle of a tablix abstracts region, and again bang Tablix Properties.
-
In Row Headers, baddest Echo attack rows on anniversary page.
-
Click OK.
Â
-
To affectation cavalcade headers on assorted pages:
Â
-
Right-click the row, column, or bend handle of a tablix abstracts region, and again bang Tablix Properties.
-
In Cavalcade Headers, baddest Echo attack columns on anniversary page.
-
Click OK.
Â
-
To affectation a changeless tablix affiliate (row or column) on assorted pages:
Â
-
On the architecture surface, bang the row or cavalcade handle of the tablix abstracts arena to baddest it. The Grouping area displays the row and cavalcade groups.
-
On the appropriate ancillary of the Grouping pane, bang the bottomward arrow, and again bang Advanced Mode. The Row Groups area displays the hierarchical changeless and activating associates for the row groups bureaucracy and the Cavalcade groups area shows an agnate affectation for the cavalcade groups hierarchy.
-
Click the changeless affiliate that corresponds to the changeless affiliate (row or column) that you appetite to abide arresting while scrolling. The Backdrop area displays the Tablix Affiliate properties.
-
In the Backdrop pane, set RepeatOnNewPage to True.
-
Repeat this for as abounding adjoining associates as you appetite to repeat.
-
Preview the report.
This would help. Thanks
