asked on

How to make an Excel column to stay put and let the rest be scrollable

Hi Everyone,

I need to make column A to stay put (vertical) and the rest of the sheet needs to scroll horizontal "under" column A. I hope this is clear enough.

Anyone any ideas?

ASKER CERTIFIED SOLUTION

wobbled

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Agrippa

ASKER

Hi Wobbled,

that's it, it's just to simple, but you need to know it. I have Office 2010.

Thankx!

Best regard, Erwin

jppinto

Go to your View tab, and click on Freeze Panes and select the option "Freeze Top Row".

jppinto
Capturar.JPG

Agrippa

ASKER

Hi jppinto,

Great, thankx!!

Wobbled already also answered with the correct solution, so I was very fast to accept and award points. I think I cannot add more.

Thankx!!

jppinto

You can always click on the Request Attention link that is below your original post and ask to re-open the question to re-award the points... :)

Agrippa

ASKER

Next question:

Freezing column A works. Now I also want to freeze the top row, row 1. I notice that I cannot do that at the same time. So freezing column A and row 1, is that possible?

Agrippa

ASKER

EE doesn't like that, I have asked that before in another question.

jppinto

Select cell B2 and choose the Option "Freeze Panes"

Agrippa

ASKER

In the freeze panes drop down I have 3 options:

Unfreeze all
Freeze first column only
Freeze top row only

jppinto

Right....first "Unfreeze all", then select cell B2 and the option for "Freeze Panes" should be available.

PS: What about clicking the Request Attention link?!?

jppinto

Still waiting...

Agrippa

ASKER

Hi ippinto

You're great, it works.

EE: can I reward points to ippinto or should this second question be made a seperate one.

jppinto

Use the Request Attention link...
Capture.JPG