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

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

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

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

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

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

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

Hi Kim!

Freezing multiple columns in Excel 2007 is actually quite easy. Here's how you can do it:

1. Select the column to the right of the last column you want to freeze. In your case, you want to freeze columns A and B, so you would select column C.
2. Click on the "View" tab in the ribbon at the top of the screen.
3. In the "Window" group, click on the "Freeze Panes" dropdown menu.
4. From the dropdown menu, select "Freeze Panes".
5. You should now see a horizontal line appear in your worksheet, just below row 1. This line indicates where your frozen columns will end.
6. To test that your columns are frozen, scroll to the right and make sure that columns A and B remain visible.

That's it! You should now be able to freeze multiple columns in Excel 2007.