cell header for each page print out

B

Brent

Hi - I want to be able to have a row of cells to be a header row for each
page - I want this row of cells to align with the column..

I looked at the Header feature but it did not allign with the cells...

How do I get a row header (aligned with the cell columns) to print out for
each page?

Thanks
brent
 
G

Gord Dibben

Brent

File>Page Setup>Sheet>Rows to Repeat at Top

Enter 1:1 or just point to row 1.


Gord Dibben MS Excel MVP
 

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

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
Access Sorting and grouping using multiple tables 0
Access Page Header with merge field 0
Return value in an table with variable columns and rows 2
Figuring out a lengthy formula. Probably quite simple... 3
How do I specify row 1 as header row that is to be printed on every page, regardless of other page s 3
Excel lookup across entire workbook 1
Sort Rows Ignoring Headers 5

Top