Column Titles

K

KrisP

I have a rather large spreadsheet where I have Titles in the first row of
each column identifying what each column represents. Within this spreadsheet
there are several pages (within the same tab). How do I set this up so the
Titles appear on each page?
Thanks,
 
G

Gord Dibben

Kris

For printing purposes......File>Page Setup>Sheet. Rows to Repeat at Top.

For viewing purposes.......Window>Freeze Panes.

Select A2 to freeze row 1

Select B2 to freeze row 1 and column A


Gord Dibben 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

Adding a big matrix in Word 2013 5
Text duplication question 0
Automatically insert "Continued" in footer based on existing STYLEREF 2
Need Help with Macro Security 1
Identify letters but not spaces 2
Create timeline with event being hyperlinks to documents on drive 1
Mail Merge Directory Conditional Page Break 0
Table - Link titles with each other so they move together 2

Top