User Login

Help Community Login:

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

22 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.
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....

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!!

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

Thank u So.....................................much foe the best instructions.

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

Thank you so much Smile

Who's New

Ezykeul's picture
freddiependleton's picture
flexnfiness's picture
raphaelbillington's picture
novellanewhouse's picture
chadwickbodiford's picture
lindsayisbrmpkgd's picture
olgapcpwslcplsjeqst's picture
ouidabohndavzzd's picture
daciacubadgeesbzlvcy's picture
numbersmarblefp's picture
thorstenpigdonisvpa's picture
brittnyuribexnak's picture
trentb46myppbupylq's picture
kattiercrfsdklmz's picture
facebook codes exploits tips tricks Phrozen Crew
All contents ©Copyright GeekDrop 2009-2014
TOS | Privacy Policy