Completely freeze column

**ABSTRAKTUS** · 02-17-2012, 02:29 PM

Hi all,

Searching net hasn't been succesfull. I'm trying to find a solution on how to freeze a column so that it is always visible regardless where user decides to scroll to. I need range C2:C60 to be frozen (or whole column). The point is that this range is full of buttons and user needs to access them with ease. I have tried split screens, freeze panes etc., but nothing gives me a desired effect.

Any ideas guys?

**john55** · 02-17-2012, 03:09 PM

hi Abstraktus,
if you click on cell d1 and then select first option from freeze panes you have frozen columns a,b and c. is this what you want?

**ABSTRAKTUS** · 02-17-2012, 05:59 PM

Hi John, freezing panes is not an option. I need to have this column frozen (static) even if you scroll down or across. Thanks for your effort anyway.

**ABSTRAKTUS** · 02-17-2012, 06:04 PM

I'm running 2003 by the way...

**mjcordeiro** · 02-17-2012, 06:36 PM

Hi, abstraktus. I'm not an expert, but I think that is not possible.
Instead it's possible you to put those buttons in a row (row 1, for example), make a split screens and then they are always visible in a simple row, instead of a column.
Hope this help you.
Mário.

**FDibbins** · 02-17-2012, 07:04 PM

As far as I know, there is no way to do what you want, the way you want to do it. An option might be to put them in Col A, and then just freeze that col? It sounds like you almost want that col to "float" in the ss

**OnErrorGoto0** · 02-17-2012, 07:06 PM

Why not make a toolbar instead? Or even a userform?

**ABSTRAKTUS** · 02-18-2012, 03:13 AM

Thanks guys. I will probably go for a frozen top row as it seems there's no way to freeze the column so that when you scroll down, objects always float (remain visible). Thanks for your effort guys.