Printing column headers on a partial sheet print

**Paul-BJ** · 11-24-2020, 09:55 AM

I have been trying to persuade the column headers to print when I print a partial selection of an excel worksheet - so far total FAIL!!

Does anyone know if this can be done; if so how?

TIA

**Bernie Deitrick** · 11-24-2020, 12:49 PM

On the Page Layout tab, choose "Print Titles" and select the row with your headers under "Rows to repeat at top" Then set your print area to your partial selection, and your headers will be printed.

Printing column headers on a partial sheet print

LinkBack

Thread Tools

Rate This Thread

Display

Printing column headers on a partial sheet print

Re: Printing column headers on a partial sheet print

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] listbox with column headers as a specific sheet column headers

Print Column or Row Headers, Not Both

[SOLVED] Array Formula to print out column headers

Excel 2007 - Partial Printing of a print area

[SOLVED] Print column headers on select pages only

Replicating the print headers and footers from one sheet to others

Column Headers to Print On multiple pages????

Bookmarks

Bookmarks

Posting Permissions