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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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"
 
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
 
You must log in or register to reply here.

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

Putting a title on each page 1
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
Display index of column headers in column A 9
HOW DO I PUT A DIFFERENT HEADER ON EACH PAGE? 1
Change the properties of the worksheet row or column header bars 6
Integrity of Column Headers 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How do I show the Header on all pages? 5

Back
Top