always visable header row

  • Thread starter Thread starter Angee
  • Start date Start date
A

Angee

Hello All- I have seen this before and I have been trying to figure it out
for months. How can I create a header row that is always visable as I scroll
down the rest of m sheet? Like I can always see row 1 and it always meets up
with the information in each column rather I am looking at row 2 or row 2005.
Make sense? THANKS! I'd really appreciate any help, this has been driving
me crazy and no one at work knows what I am talking about.
 
Select A1 (just so you can see it)
select A2
Window|Freeze Panes
(in xl2003)

Everything above the activecell and to the left of that activecell will be
frozen.

If you have data|filter|autofilter applied, show all the data before you freeze
panes.
 
THANK YOU THANK YOU THANK YOU!!! It worked!

Dave Peterson said:
Select A1 (just so you can see it)
select A2
Window|Freeze Panes
(in xl2003)

Everything above the activecell and to the left of that activecell will be
frozen.

If you have data|filter|autofilter applied, show all the data before you freeze
panes.
Click to expand...
 
Place your cursor immediately below the Header Row, click Window
Freeze Panes and you should be good to go.

Dean

Hello All- I have seen this before and I have been trying to figure i
out
for months. How can I create a header row that is always visable as
scroll
down the rest of m sheet? Like I can always see row 1 and it alway
meets up
with the information in each column rather I am looking at row 2 or ro
2005.
Make sense? THANKS! I'd really appreciate any help, this has bee
driving
me crazy and no one at work knows what I am talking about
 
Back
Top