Question about freezing cells

  • Thread starter Thread starter JoAnn Paules [MSFT MVP]
  • Start date Start date
J

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.
 
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
 
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]
 
How cool is that!

BTW - who's Gary?

--

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


JoAnn Paules said:
How cool is that!

BTW - who's Gary?

--

JoAnn Paules
MVP Microsoft [Publisher]



Click on cell B2. The pull-down:
Window > Freeze Panes
Click to expand...
Click to expand...
 
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

JoAnn Paules said:
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]



Paul B said:
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
Click to expand...
Click to expand...
 
Don't be a troll - that's a bad thing. ;-)

--

JoAnn Paules
MVP Microsoft [Publisher]



Scudo said:
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


JoAnn Paules said:
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.
Click to expand...
Click to expand...
Click to expand...
 
But being a lurker is a good thing!

(Well, in the newsgroups <vbg>.)


JoAnn Paules said:
Don't be a troll - that's a bad thing. ;-)

--

JoAnn Paules
MVP Microsoft [Publisher]

Scudo said:
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


JoAnn Paules said:
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.
Click to expand...
Click to expand...
Click to expand...
 
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]



Dave Peterson said:
But being a lurker is a good thing!

(Well, in the newsgroups <vbg>.)


JoAnn Paules said:
Don't be a troll - that's a bad thing. ;-)

--

JoAnn Paules
MVP Microsoft [Publisher]

Scudo said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top