View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Freeze more than one column

So what happens when, in that situation, you select "Freeze Panes (both row
and colum)" ?
Doesn't it do what Dave says and freeze columns A to C?
--
David Biddulph

"Kim" wrote in message
...
Dave,

No joy. When I select D1 (or column D for that matter) the ViewFreeze
Pane
options are only Freeze Panes (both row and colum), Freeze Row and Freeze
First Column.

Maybe there's an add-in new to 2007.........

Thanks,

KIm

"Dave Peterson" wrote:

Say you want to freeze columns A to C.

Select a cell in column D.

Every column to the left of that activecell will be frozen.
Every row above the activecell will be frozen.

Make sure you remove any existing frozen panes first.

Kim wrote:

I'm new to Excell 2007. What's the trick to freezing columns A+? All
I can
see is "freeze first column". Selecting column "C" gets me column "A"
frozen.

Thanks for the help............

Kim


--

Dave Peterson