Question about freezing cells

[JoAnn Paules [MSFT MVP]]

My Excel skills aren't the best. I can do some real basic things but because
I don't do a lot with Excel, I still need help.

Is there a way to freeze both a row and a column at the same time? We use
Excel 2000 at work to keep track of available accrued STD (short-term
disability). The employees names are in the first column and the pay period
is about row 6. I would like to be able to freeze the worksheet so that I
can still see the employee name and the pay period date without hiding
columns. (Sometimes you need to see when the employee used some of that
time.)

I know I can do a split screen but my co-workers know less about Excel than
I do. (They think I'm a computer goddess. Ha ha ha ha! Shhhhhhh!) I'm afraid
that might throw them off.

 

[Paul B]

JoAnn, try this, select cell B7 then window, freeze panes

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Gary''s Student]

Click on cell B2. The pull-down:
Window > Freeze Panes

 

[JoAnn Paules [MSFT MVP]]

Well I'll be hornswoggled! That's EXACTLY what I wanted! And sooooooo much
easier than I was expecting. Thank you Paul!

--

JoAnn Paules
MVP Microsoft [Publisher]

 

[Scudo]

I love it, just never thought about asking, wish I had known about this 3
years ago....Ah well every day something new
Pleased that the question was asked. and also that I troll these NGs

How cool is that!

BTW - who's Gary?

--

JoAnn Paules
MVP Microsoft [Publisher]

Click on cell B2. The pull-down:
Window > Freeze Panes

 

[Paul B]

JoAnn, your welcome

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

Well I'll be hornswoggled! That's EXACTLY what I wanted! And sooooooo much
easier than I was expecting. Thank you Paul!

--

JoAnn Paules
MVP Microsoft [Publisher]

JoAnn, try this, select cell B7 then window, freeze panes

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[JoAnn Paules [MSFT MVP]]

Don't be a troll - that's a bad thing. ;-)

--

JoAnn Paules
MVP Microsoft [Publisher]

I love it, just never thought about asking, wish I had known about this 3
years ago....Ah well every day something new
Pleased that the question was asked. and also that I troll these NGs

How cool is that!

BTW - who's Gary?

--

JoAnn Paules
MVP Microsoft [Publisher]

Click on cell B2. The pull-down:
Window > Freeze Panes
--
Gary''s Student


:

My Excel skills aren't the best. I can do some real basic things but
because
I don't do a lot with Excel, I still need help.

Is there a way to freeze both a row and a column at the same time? We use
Excel 2000 at work to keep track of available accrued STD (short-term
disability). The employees names are in the first column and the pay
period
is about row 6. I would like to be able to freeze the worksheet so
that I
can still see the employee name and the pay period date without hiding
columns. (Sometimes you need to see when the employee used some of
that
time.)

I know I can do a split screen but my co-workers know less about Excel
than
I do. (They think I'm a computer goddess. Ha ha ha ha! Shhhhhhh!) I'm
afraid
that might throw them off.

 

[Dave Peterson]

But being a lurker is a good thing!

(Well, in the newsgroups <vbg>.)

Don't be a troll - that's a bad thing. ;-)

--

JoAnn Paules
MVP Microsoft [Publisher]

I love it, just never thought about asking, wish I had known about this 3
years ago....Ah well every day something new
Pleased that the question was asked. and also that I troll these NGs

How cool is that!

BTW - who's Gary?

--

JoAnn Paules
MVP Microsoft [Publisher]



Click on cell B2. The pull-down:
Window > Freeze Panes
--
Gary''s Student


:

My Excel skills aren't the best. I can do some real basic things but
because
I don't do a lot with Excel, I still need help.

Is there a way to freeze both a row and a column at the same time? We use
Excel 2000 at work to keep track of available accrued STD (short-term
disability). The employees names are in the first column and the pay
period
is about row 6. I would like to be able to freeze the worksheet so
that I
can still see the employee name and the pay period date without hiding
columns. (Sometimes you need to see when the employee used some of
that
time.)

I know I can do a split screen but my co-workers know less about Excel
than
I do. (They think I'm a computer goddess. Ha ha ha ha! Shhhhhhh!) I'm
afraid
that might throw them off.

 

[JoAnn Paules [MSFT MVP]]

Thank you adding that clarification. We certainly don't need any more people
standing outside of our living room windows than we already have. ;-)

--

JoAnn Paules
MVP Microsoft [Publisher]

But being a lurker is a good thing!

(Well, in the newsgroups <vbg>.)

Don't be a troll - that's a bad thing. ;-)

--

JoAnn Paules
MVP Microsoft [Publisher]

I love it, just never thought about asking, wish I had known about this
3
years ago....Ah well every day something new
Pleased that the question was asked. and also that I troll these NGs


How cool is that!

BTW - who's Gary?

--

JoAnn Paules
MVP Microsoft [Publisher]



message
Click on cell B2. The pull-down:
Window > Freeze Panes
--
Gary''s Student


:

My Excel skills aren't the best. I can do some real basic things
but
because
I don't do a lot with Excel, I still need help.

Is there a way to freeze both a row and a column at the same time?
We
use
Excel 2000 at work to keep track of available accrued STD
(short-term
disability). The employees names are in the first column and the
pay
period
is about row 6. I would like to be able to freeze the worksheet so
that
I
can still see the employee name and the pay period date without
hiding
columns. (Sometimes you need to see when the employee used some of
that
time.)

I know I can do a split screen but my co-workers know less about
Excel
than
I do. (They think I'm a computer goddess. Ha ha ha ha! Shhhhhhh!)
I'm
afraid
that might throw them off.