Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Possible Duplicate:
How to get the Excel header on each print page to be the first row of the table

Can we print Excel report like this ?

-------------------
 Some description
 Some description

 Table header
 Table Values
 Table Values
 Table Values
------------------- 

-------------------
 Table header
 Table Values
 Table Values
 Table Values
 Table Values
 Table Values
 Table Values
------------------- 

-------------------
 Table header
 Table Values
 Table Values
 Table Values
 Table Values
 Table Values
 Table Values
------------------- 

We can set printable rows like mentioned at How to get the Excel header on each print page to be the first row of the table But this results in rather weird formatting: while the preamble itself is not repeated (printed), the rows are still reserved and stays blank, instead of being reused for the table itself.

-------------------
 Some description
 Some description

 Table header
 Table Values
 Table Values
 Table Values
------------------- 

-------------------



 Table header
 Table Values
 Table Values
 Table Values
------------------- 

-------------------



 Table header
 Table Values
 Table Values
 Table Values
------------------- 

Moving preamble to the separate page (tab) is not a solution as well:

  1. Report may contain several tabs with different tables and describing them preambles in each

  2. Wasting the whole paper sheet for few descriptional lines it not much better than wasting blank lines atop of each sheet

  3. The separate sheet with the description might be lost or get mistakenly attached to another table, etc.

share|improve this question

marked as duplicate by slhck Jan 18 '13 at 22:53

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

    
Any reason you can't just put the preamble in the header? –  CharlieRB Jan 16 '13 at 14:41
    
Too long. Half-dozen rows. –  Arioch 'The Jan 16 '13 at 14:46

1 Answer 1

up vote 2 down vote accepted

This seems straightforward to me. Assuming this is your data:

-------------------
Some description line 1
Some description line 2
                       (blank row)
Table header
Table Values
Table Values
Table Values
(etc)

Set your print area as cells A1:B200 (or whatever), including the "some description" lines at the top. Then set row 4 (ie $4:$4) as the "Rows to repeat at top".

This works fine for me in Excel 2010.

share|improve this answer
    
Hmm... that actually works... looks like i over-minimized the example, for our COM-generated reports "feature" those blank lines. I would have to re-think the difference, really. –  Arioch 'The Jan 16 '13 at 14:54
    
I'm not sure I understand. Could you provide more detail please? –  Andi Mohr Jan 16 '13 at 15:00
1  
I'm sorry, i heavily misrepresented the situation.... it is more complex and the artifacts are less obtrusive. Perhaps i'd let it go for a while or maybe would start another question later. Thanks for your help. –  Arioch 'The Jan 18 '13 at 11:55

Not the answer you're looking for? Browse other questions tagged or ask your own question.