Easy question

  • Thread starter Thread starter BH
  • Start date Start date
B

BH

I am wanting to have a row of Header Columns that comes up
on every page- How do you do that?
 
File, PageSetUp... Sheet Tab, Rows to Repeat at Top, Click inside and
enter something like $1:$3 (for Rows 1, 2 & 3- which could be your column
headers)...
HTH
 
Excelent answer! Now I need the headers to show up on the
normal screen (I am using it for a template). Do I need
to set something in my prefs?
 
Don previously answered on how to duplicate header "in the screen" by
Grouping across several sheets... and entering data just once..
 
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

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
Row 1 HEADERS on EVERY printed page 2
Data Import Question 4
Showing Letters For Column Headers Rather Thann Numbers ? 1
stop sorting titles please 3
How pull ID#s that meet specific "yes" requirements 3
rows and columns on worksheet 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2

Back
Top