| Posted By |
Message |
SweetestOfPeas
J'taime Paris!
Member since 3/06 32345 total posts
Name:
|
Excel masters - a question
I can't remember how to do this... need your help.
how do I make only the first row (accross the top) of a spreadsheet stay static?
TY!
|
Posted 5/18/07 9:10 AM  |
| |
|
Long Island Weddings
Long Island's Largest Bridal Resource |
LMFitz
life is good
Member since 5/05 2013 total posts
Name:
L
|
Re: Excel masters - a question
freeze the panes - (under the window option on the toolbar)
|
| Posted 5/18/07 9:12 AM |
| |
|
HarleyGirlFLA
Come on in
Member since 5/05 9674 total posts
Name:
Mel
|
Re: Excel masters - a question
Do you want to freeze it???
meaning you can work in the rest of the workbook but line 1 will always stay where it is no matter how far down you go??
|
| Posted 5/18/07 9:12 AM |
| |
|
MikesWife
Wanting...........
Member since 1/06 6887 total posts
Name:
Karen
|
Re: Excel masters - a question
I'm pretty sure you highlight the row you want to stay static - I'm assuming it's 1. Then go to Window --> freeze panes.
|
| Posted 5/18/07 9:13 AM |
| |
|
SweetestOfPeas
J'taime Paris!
Member since 3/06 32345 total posts
Name:
|
Re: Excel masters - a question
Posted by HarleyGirlFLA
Do you want to freeze it???
meaning you can work in the rest of the workbook but line 1 will always stay where it is no matter how far down you go??
yes!! exactly!
if I choose freeze pane, won't a few other rows get frozen too? I just want the very top row frozen
|
| Posted 5/18/07 9:16 AM |
| |
|
SweetestOfPeas
J'taime Paris!
Member since 3/06 32345 total posts
Name:
|
Re: Excel masters - a question
Posted by MikesWife
I'm pretty sure you highlight the row you want to stay static - I'm assuming it's 1. Then go to Window --> freeze panes.
I tried that and several rows get "frozen", I only want the top row to stay static
|
| Posted 5/18/07 9:17 AM |
| |
|
Christine
2nd verse same as the 1st
Member since 5/05 15287 total posts
Name:
|
Re: Excel masters - a question
Posted by SweetestOfPeas
Posted by HarleyGirlFLA
Do you want to freeze it???
meaning you can work in the rest of the workbook but line 1 will always stay where it is no matter how far down you go??
yes!! exactly!
if I choose freeze pane, won't a few other rows get frozen too? I just want the very top row frozen
No, just highlight Row A when you select Freeze Panes and that will be the only one that stays on the top.
|
| Posted 5/18/07 9:18 AM |
| |
|
SweetestOfPeas
J'taime Paris!
Member since 3/06 32345 total posts
Name:
|
Re: Excel masters - a question
Posted by Christine
Posted by SweetestOfPeas
Posted by HarleyGirlFLA
Do you want to freeze it???
meaning you can work in the rest of the workbook but line 1 will always stay where it is no matter how far down you go??
yes!! exactly!
if I choose freeze pane, won't a few other rows get frozen too? I just want the very top row frozen
No, just highlight Row A when you select Freeze Panes and that will be the only one that stays on the top.
when I do that it's freezing a bunch of rows, not just the top one 
|
| Posted 5/18/07 9:19 AM |
| |
|
Elbee
Zanzibar
Member since 5/05 10767 total posts
Name:
Me
|
Re: Excel masters - a question
Click on Cell A2 and do "FREEZE PANE" that should freeze only ROW 1
To freeze Column A and Row 1, Click on cell B2 and choose "Freeze pane". ... both Column A and Row 1 will be frozen ... etc and so on ...
Message edited 5/18/2007 9:24:45 AM.
|
| Posted 5/18/07 9:24 AM |
| |
|
SweetestOfPeas
J'taime Paris!
Member since 3/06 32345 total posts
Name:
|
Re: Excel masters - a question
Posted by Elbee
Click on Cell A2 and do "FREEZE PANE" that should freeze only ROW 1
To freeze Column A and Row 1, Click on cell B2 and choose "Freeze pane". ... both Column A and Row 1 will be frozen ... etc and so on ...
UGH! why is it that the first 15 rows freeze when I do this?!
|
| Posted 5/18/07 9:30 AM |
| |
|
Christine
2nd verse same as the 1st
Member since 5/05 15287 total posts
Name:
|
Re: Excel masters - a question
I would try starting over -- select the whole sheet, freeze panes, then unfreeze panes, then try again. Roll the sheet all the way to the top, hilight the first row and freeze panes again.
|
| Posted 5/18/07 9:43 AM |
| |
|
SweetestOfPeas
J'taime Paris!
Member since 3/06 32345 total posts
Name:
|
Re: Excel masters - a question
Posted by Christine
I would try starting over -- select the whole sheet, freeze panes, then unfreeze panes, then try again. Roll the sheet all the way to the top, hilight the first row and freeze panes again.
it's not working. maybe it's this version of Excel that I use - it's 2002 
|
| Posted 5/18/07 9:51 AM |
| |
|
nrthshgrl
It goes fast. Pay attention.
Member since 7/05 57538 total posts
Name:
|
Re: Excel masters - a question
Do you have a split screen? (2 windows of the same file) There would be a thick gray line across the top.
|
| Posted 5/18/07 9:53 AM |
| |
|
SweetestOfPeas
J'taime Paris!
Member since 3/06 32345 total posts
Name:
|
Re: Excel masters - a question
Posted by nrthshgrl
Do you have a split screen? (2 windows of the same file) There would be a thick gray line across the top.
OMG! it just worked!  I didn't do anything differently!  
|
| Posted 5/18/07 9:56 AM |
| |
|
nrthshgrl
It goes fast. Pay attention.
Member since 7/05 57538 total posts
Name:
|
Re: Excel masters - a question
It was driving me crazy. I was going to ask you to email me the file so I could fix it.
|
| Posted 5/18/07 10:01 AM |
| |
|
SweetestOfPeas
J'taime Paris!
Member since 3/06 32345 total posts
Name:
|
Re: Excel masters - a question
Posted by nrthshgrl
It was driving me crazy. I was going to ask you to email me the file so I could fix it.
|
| Posted 5/18/07 10:01 AM |
| |
|
MsMBV
:P
Member since 5/05 28602 total posts
Name:
Me
|
Re: Excel masters - a question
I hate Excel for this reason. I use it all day at work, and sometimes it just does not work.....
I am glad you got it fixed
|
| Posted 5/18/07 10:10 AM |
| |
|
Phyl
R.I.P. Sweet Mia ♥
Member since 5/06 28918 total posts
Name:
The Mystical Azzhorse! ™
|
Re: Excel masters - a question
Thank G-d you did it. I was getting all worked up!
|
| Posted 5/18/07 10:27 AM |
| |
|
SweetestOfPeas
J'taime Paris!
Member since 3/06 32345 total posts
Name:
|
Re: Excel masters - a question
Posted by Phyl
Thank G-d you did it. I was getting all worked up!
|
| Posted 5/18/07 10:31 AM |
| |
|
