If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Freeze more than one column
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Freeze more than one column
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 |
#4
|
|||
|
|||
Freeze more than one column
I believe the first option (Freeze Panes) is what you want.
"Kim" wrote: 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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
Freeze more than one column
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 |
#7
|
|||
|
|||
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 news 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 |
#8
|
|||
|
|||
Freeze more than one column
I do....and with much laughter I'll take that under advisement.........
"David Biddulph" wrote: 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 news 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 | |
Display Modes | |
|
|