User Login

Help Community Login:

How do I freeze rows and columns at the same time in Excel 2007 ?

25 replies [Last post]
Autumn's picture
Autumn
Premium Member (Gold)I'm a Code Monkey!I use Google ChromeWindows UserI donated more than $20+ to GeekDrop!I donated to GeekDrop simply because I love it!I spend all day Photobucketing!I took a bite of the AppleIs a FIERCE Competetor! 2nd place contest winner!The Dr. left the stem off the apple!Someone thinks you're udderly delightful!
Joined: 09/12/2009
Posts: 254
Drops: 339
Mood: Content
Groups: Geekdrop Cafe

im hoping someone can help me with this, i have been trying to freeze the 3 top rows and the first column of a spreadsheet, but everytime i freeze the top rows and then i try to freeze the first column the top rows unfreeze, im going crazy Frustrated

I Averaged: 4 | 2 votes

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
missb's picture
missb
Banned Member (Way To Go!)
Relationship Status:
Single & Not Looking
Joined: 01/16/2009
Posts: 3109
Drops: 3812
Mood: Weird
Re: How do I freeze rows and columns at the same time in ...

Ah, been there done that Autumn, but it's easy peasy!

First of all instead of trying to freeze each one individually you actually do it simultaneously as follows:

Assuming that you want to freeze the "EMPLOYEE" column and the first 3 rows.

freeze rows and columns

You will go to the cell that is directly to the right of the column you want to freeze and in this case the 4th row down (you said you wanted to freeze the top 3 rows) you always go to the row directly under the rows you want to freeze.

freeze rows and columns

Then you go to "View" on the top menu, then click "Freeze Panes" to get the drop down box and hit Freeze Panes

freeze rows and columns

You will now see 2 solid lines which indicates that anything to the left and above those lines are frozen.

freeze rows and columns
 

Hope this helps and happy scrolling Big Grin

Autumn's picture
Autumn
Premium Member (Gold)I'm a Code Monkey!I use Google ChromeWindows UserI donated more than $20+ to GeekDrop!I donated to GeekDrop simply because I love it!I spend all day Photobucketing!I took a bite of the AppleIs a FIERCE Competetor! 2nd place contest winner!The Dr. left the stem off the apple!Someone thinks you're udderly delightful!
Joined: 09/12/2009
Posts: 254
Drops: 339
Mood: Content
Groups: Geekdrop Cafe
Re: How do I freeze rows and columns at the same time in ...

thank you so much missb you're right that is easy, well it is once you know how. problem solved, i wish i had seen this yesterday. thanks again Big Hug

Autumn's picture
Autumn
Premium Member (Gold)I'm a Code Monkey!I use Google ChromeWindows UserI donated more than $20+ to GeekDrop!I donated to GeekDrop simply because I love it!I spend all day Photobucketing!I took a bite of the AppleIs a FIERCE Competetor! 2nd place contest winner!The Dr. left the stem off the apple!Someone thinks you're udderly delightful!
Joined: 09/12/2009
Posts: 254
Drops: 339
Mood: Content
Groups: Geekdrop Cafe
Re: How do I freeze rows and columns at the same time in ...

just want to let you know that this worked perfectly thank you again.

Rajeshkanna's picture
Rajeshkanna
Re: How do I freeze rows and columns at the same time in ...

It's working fine as per your information. and its very useful tips for us.

Aruna's picture
Aruna
Re: How do I freeze rows and columns at the same time in ...

Thank you for solving my problem

shaik.umarfarooq's picture
shaik.umarfarooq
Re: How do I freeze rows and columns at the same time in ...

Thanks ... Thats was very clear and simple explanation....

notbillcourtney's picture
notbillcourtney
Re: How do I freeze rows and columns at the same time in ...

I can think of a dozen times I wanted to do this and got frustrated when I couldn't, finally googled it - I can't believe it was this easy! Thanks a lot!

Guest- Sohel Kabir's picture
Guest- Sohel Kabir
Re: How do I freeze rows and columns at the same time in ...

 This is so helpful. Thank u so much Smile

Vasharukwa's picture
Vasharukwa
Re: How do I freeze rows and columns at the same time in ...

Eish this was so handy, this was the second time I tried to do this with no joy, until I saw this solution from miss b. thank you so much, i feel great

tamekadyer's picture
tamekadyer
Re: How do I freeze rows and columns at the same time in ...

Thanks a million....very good instructions!!

Who's New

metaclippingpath's picture
Generalocee's picture
emma agro's picture
DarkkDdream's picture
Larisabrownb's picture
conor13's picture
MeadeDorianx's picture
Emilylowes's picture
Emmaythomson's picture
Chair's picture
Financial's picture
Red bud's picture
DonnaStella123's picture
WenrichFeugene's picture
Weissert's picture
facebook codes exploits tips tricks Phrozen Crew
All contents ©Copyright GeekDrop™ 2009-2024
TOS | Privacy Policy