Can I get non-truncated print headings?

Topic

New Reply

Dear Loungers,

In Excel 2007 is it possible to set the print headings so that they don’t truncate to the width of the first column on the page… page one is OK, the second page across (not down) will only show the print headings as wide as the first column on that page.

Thank you…………………. liz

Reply | Quote

Replies

No, I don’t believe so. You need to ensure that the column is wide enough (and/or wrap the header text)

Reply | Quote

Odd, I could not repro this on a small test document. Could you perhaps upload a sample sheet?

Reply | Quote

I attach a test document

Reply | Quote

This is because you are repeating the A column on each page. Since the text runs into the B and C columns it is not included on pages 2 and 3. The same behavior occurs in Excel 2003.

Reply | Quote