How do I make the 1st column constant in viewing a wide spreadshee
 

Using Excel 2002. Created a very wide spreadsheet and I can't see the row
headings when I scroll to the right.

How do I make the 1st column constant in viewing a wide spreadshee
 

Place your cursor just to the right of the column you want to be visible and
just below the row that should always remain visible. Now select Window -
Freeze Panes
--
HTH...

Jim Thomlinson


"Greg" wrote:

Using Excel 2002. Created a very wide spreadsheet and I can't see the row
headings when I scroll to the right.

How do I make the 1st column constant in viewing a wide spreadshee
 

Select column 2, then go to Windows--Freeze pane and this will freeze the 1st
column on the left.

Dave
--
Brevity is the soul of wit.


"Greg" wrote:

Using Excel 2002. Created a very wide spreadsheet and I can't see the row
headings when I scroll to the right.

How do I make the 1st column constant in viewing a wide spread
 

Perfect! Simple but sweet - thanks!

"Jim Thomlinson" wrote:

Place your cursor just to the right of the column you want to be visible and
just below the row that should always remain visible. Now select Window -
Freeze Panes
--
HTH...

Jim Thomlinson


"Greg" wrote:

Using Excel 2002. Created a very wide spreadsheet and I can't see the row
headings when I scroll to the right.

How do I make the 1st column constant in viewing a wide spread
 

Thanks Dave - this works and makes life simpler...

"Dave F" wrote:

Select column 2, then go to Windows--Freeze pane and this will freeze the 1st
column on the left.

Dave
--
Brevity is the soul of wit.


"Greg" wrote:

Using Excel 2002. Created a very wide spreadsheet and I can't see the row
headings when I scroll to the right.