i opened a new spreadsheet, and i'm trying to utilize the 'freeze
panes' function. i'm looking to just 'freeze' the contents of the first
column ('A'), but whenever I highlight the entire first column and
select 'freeze panes,' the first couple of columns become frozen (A-H).
any advice would be greatly appreciated...

Select A1 (to make it visible)
then select column A.
Now hit window|Freeze panes


wrote:

i opened a new spreadsheet, and i'm trying to utilize the 'freeze
panes' function. i'm looking to just 'freeze' the contents of the first
column ('A'), but whenever I highlight the entire first column and
select 'freeze panes,' the first couple of columns become frozen (A-H).
any advice would be greatly appreciated...

--

Dave Peterson

just tried following the suggestion, and the same problem occurs (to be
more specific, when i hit 'freeze', it 'blocks off' columns A1-A12, all
the way to the right to H1-H12). not sure why it's automatically doing
this (especially since i'm just highlighting the A column)...

Greg
Just select B1, then freeze panes. Don't select a whole column. HTH
Otto
wrote in message
oups.com...
just tried following the suggestion, and the same problem occurs (to be
more specific, when i hit 'freeze', it 'blocks off' columns A1-A12, all
the way to the right to H1-H12). not sure why it's automatically doing
this (especially since i'm just highlighting the A column)...

thanks for the tip otto, just got it to work.

greg p.

i spoke too soon - by clicking on B1 and 'freeze' i get the left column
(A) to freeze, but now the upper/left-to-right column (1) i cannot get
to freeze as well. in other words, i'd like for both to be frozen at
the same time.

any advice?