suppressing table header on a page

K

Kevin

I have a worksheet with column headers (rows) repeating on all pages.
The last page is text, with no tabular materail. Is there a way to
prevent the header from printing on this page?
 
E

Earl Kiosterud

Kevin,

I don't think there's a way to get the rows to repeat to not appear on the
last page. A macro could print all but the last page, change the rows to
repeat to nothing, then print the last page. But that would change the
pagination -- the last page would no longer be the same. Probably not worth
persuing. Consider putting the text on a subsequent sheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return value in an table with variable columns and rows 2
Skip header on first page? 1
MS Word 2003 Header area size distburbs page setup 0
Repeating rows dont repeat fully when columns also repeat 4
Macro to remove rows? 5
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Formatting As Table with OUT header row formatting 5
Repeat rows or columns as headers when printing? 2

Top