How do I put column headers in a multi-page worksheet

L

Lizzie

I don't understand the Help menu on this topic!
Can someone please tell me in simple language how I'd put column headers on
each page of a long price list?
 
R

rojee

To put column header for each space in excel...
Go to File then select Page Set-up...
Select Sheet tab
then select "row to repeat on top"
 
G

Gord Dibben

Lizzie

Assuming you want to print out a long list from one worksheet.

Assuming the headers(titles) are in row 1.

File>Page setup>Sheet>"Rows to repeat at top".

Enter 1:1

If my assumer is not working, post back with more details.

Gord Dibben Excel MVP
 
Top