LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Freeze more than one column

If you mean merged cells, the general view of the experts on this group is
that they are the spawn of the devil and should be avoided like the plague.
--
David Biddulph

"Kim" wrote in message
...
Gonna have to look closer at this. Given a blank worksheet, it works as
Dave
said. Give MY worksheet selecting col C + freeze pain freezes Column C
and
rows 1-3. I have some grouped cells, maybe that's an issue.

My apologizes Dave.............

Kim

"David Biddulph" wrote:

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






 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Freeze column AG [email protected] Excel Discussion (Misc queries) 4 January 2nd 07 10:06 PM
freeze row and column 00KobeBrian Excel Discussion (Misc queries) 3 May 8th 06 06:58 AM
Freeze Sections and column in a worksheet Jelinek Excel Discussion (Misc queries) 3 March 28th 06 12:50 PM
Freeze column and row vapor77 New Users to Excel 3 February 3rd 06 05:44 PM
In Excel allow freeze pane in any column plus any row vlado Excel Worksheet Functions 1 October 11th 05 05:00 PM


All times are GMT +1. The time now is 10:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"