View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Freeze more than one column

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