Hello,

Two questions:

1) is it possible to fix the left column or maybe the two most left columns
on the left side of the sheet...so that when one goes to the right the left
column(s) will stay visible.

2) same question for the upper row. I know I can freeze panes...but if the
sheet is bigger than what I can see, it fixes it in the current view...while
I still want to be able to see all columns, while going to the left or the
right.

1) Select column C, then go to Window - Freeze panes.

2) Select row 2, then go to Window - Freeze panes

Freeze panes will always freeze to the left and/or above of your current
selection.(if possible)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"mariekek5" wrote:

Hello,

Two questions:

1) is it possible to fix the left column or maybe the two most left columns
on the left side of the sheet...so that when one goes to the right the left
column(s) will stay visible.

2) same question for the upper row. I know I can freeze panes...but if the
sheet is bigger than what I can see, it fixes it in the current view...while
I still want to be able to see all columns, while going to the left or the
right.

I think Luke meant "select C2 then WindowFreeze Panes"


Gord Dibben MS Excel MVP

On Fri, 19 Jun 2009 06:07:05 -0700, Luke M
wrote:

1) Select column C, then go to Window - Freeze panes.

2) Select row 2, then go to Window - Freeze panes

Freeze panes will always freeze to the left and/or above of your current
selection.(if possible)

Dear Gord,

Thanks!

Actually, I can freeze either the upper row or a column on the left....but
not both... Is it possible to both freeze the upper row as well as a column
on the left?

Thanks in advance.

Marieke

"Gord Dibben" wrote:

I think Luke meant "select C2 then WindowFreeze Panes"


Gord Dibben MS Excel MVP

On Fri, 19 Jun 2009 06:07:05 -0700, Luke M
wrote:

1) Select column C, then go to Window - Freeze panes.

2) Select row 2, then go to Window - Freeze panes

Freeze panes will always freeze to the left and/or above of your current
selection.(if possible)

Unfreezeplace cursor where desiredfreeze
rows below cursor and columns to left will be frozen

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"mariekek5" wrote in message
...
Dear Gord,

Thanks!

Actually, I can freeze either the upper row or a column on the left....but
not both... Is it possible to both freeze the upper row as well as a
column
on the left?

Thanks in advance.

Marieke

"Gord Dibben" wrote:

I think Luke meant "select C2 then WindowFreeze Panes"


Gord Dibben MS Excel MVP

On Fri, 19 Jun 2009 06:07:05 -0700, Luke M

wrote:

1) Select column C, then go to Window - Freeze panes.

2) Select row 2, then go to Window - Freeze panes

Freeze panes will always freeze to the left and/or above of your current
selection.(if possible)

Select a cell.

Any rows above and columns left of that cell will be frozen when you Freeze
Panes.

B2 freezes row 1 and column A.


Gord

On Mon, 22 Jun 2009 00:11:01 -0700, mariekek5
wrote:

Dear Gord,

Thanks!

Actually, I can freeze either the upper row or a column on the left....but
not both... Is it possible to both freeze the upper row as well as a column
on the left?

Thanks in advance.

Marieke

"Gord Dibben" wrote:

I think Luke meant "select C2 then WindowFreeze Panes"


Gord Dibben MS Excel MVP

On Fri, 19 Jun 2009 06:07:05 -0700, Luke M
wrote:

1) Select column C, then go to Window - Freeze panes.

2) Select row 2, then go to Window - Freeze panes

Freeze panes will always freeze to the left and/or above of your current
selection.(if possible)

Great, thanks!

"Gord Dibben" wrote:

Select a cell.

Any rows above and columns left of that cell will be frozen when you Freeze
Panes.

B2 freezes row 1 and column A.


Gord

On Mon, 22 Jun 2009 00:11:01 -0700, mariekek5
wrote:

Dear Gord,

Thanks!

Actually, I can freeze either the upper row or a column on the left....but
not both... Is it possible to both freeze the upper row as well as a column
on the left?

Thanks in advance.

Marieke

"Gord Dibben" wrote:

I think Luke meant "select C2 then WindowFreeze Panes"


Gord Dibben MS Excel MVP

On Fri, 19 Jun 2009 06:07:05 -0700, Luke M
wrote:

1) Select column C, then go to Window - Freeze panes.

2) Select row 2, then go to Window - Freeze panes

Freeze panes will always freeze to the left and/or above of your current
selection.(if possible)