Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Question about freezing cells
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 MVP Microsoft [Publisher] |
#2
|
|||
|
|||
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]" wrote in message ... 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 MVP Microsoft [Publisher] |
#3
|
|||
|
|||
Click on cell B2. The pull-down:
Window Freeze Panes -- Gary''s Student "JoAnn Paules [MSFT MVP]" wrote: 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 MVP Microsoft [Publisher] |
#4
|
|||
|
|||
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" wrote in message ... 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]" wrote in message ... 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 MVP Microsoft [Publisher] |
#5
|
|||
|
|||
How cool is that!
BTW - who's Gary? -- JoAnn Paules MVP Microsoft [Publisher] "Gary''s Student" wrote in message ... Click on cell B2. The pull-down: Window Freeze Panes -- Gary''s Student "JoAnn Paules [MSFT MVP]" wrote: 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 MVP Microsoft [Publisher] |
#6
|
|||
|
|||
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 [MSFT MVP]" wrote in message ... How cool is that! BTW - who's Gary? -- JoAnn Paules MVP Microsoft [Publisher] "Gary''s Student" wrote in message ... Click on cell B2. The pull-down: Window Freeze Panes -- Gary''s Student "JoAnn Paules [MSFT MVP]" wrote: 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 MVP Microsoft [Publisher] |
#7
|
|||
|
|||
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 [MSFT MVP]" wrote in message ... 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" wrote in message ... 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]" wrote in message ... 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 MVP Microsoft [Publisher] |
#8
|
|||
|
|||
Don't be a troll - that's a bad thing. ;-)
-- JoAnn Paules MVP Microsoft [Publisher] "Scudo" wrote in message k... 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 [MSFT MVP]" wrote in message ... How cool is that! BTW - who's Gary? -- JoAnn Paules MVP Microsoft [Publisher] "Gary''s Student" wrote in message ... Click on cell B2. The pull-down: Window Freeze Panes -- Gary''s Student "JoAnn Paules [MSFT MVP]" wrote: 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 MVP Microsoft [Publisher] |
#9
|
|||
|
|||
But being a lurker is a good thing!
(Well, in the newsgroups <vbg.) "JoAnn Paules [MSFT MVP]" wrote: Don't be a troll - that's a bad thing. ;-) -- JoAnn Paules MVP Microsoft [Publisher] "Scudo" wrote in message k... 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 [MSFT MVP]" wrote in message ... How cool is that! BTW - who's Gary? -- JoAnn Paules MVP Microsoft [Publisher] "Gary''s Student" wrote in message ... Click on cell B2. The pull-down: Window Freeze Panes -- Gary''s Student "JoAnn Paules [MSFT MVP]" wrote: 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 MVP Microsoft [Publisher] -- Dave Peterson |
#10
|
|||
|
|||
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" wrote in message ... But being a lurker is a good thing! (Well, in the newsgroups <vbg.) "JoAnn Paules [MSFT MVP]" wrote: Don't be a troll - that's a bad thing. ;-) -- JoAnn Paules MVP Microsoft [Publisher] "Scudo" wrote in message k... 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 [MSFT MVP]" wrote in message ... How cool is that! BTW - who's Gary? -- JoAnn Paules MVP Microsoft [Publisher] "Gary''s Student" wrote in message ... Click on cell B2. The pull-down: Window Freeze Panes -- Gary''s Student "JoAnn Paules [MSFT MVP]" wrote: 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 MVP Microsoft [Publisher] -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Order of selecting unprotected cells | Excel Discussion (Misc queries) | |||
Unlocking Cells when a worksheet is protected... | Excel Discussion (Misc queries) | |||
Help me! There is problem with cells view... | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions |