Table
 

The table that I have generated in Excell is much larger than the screen and
when I scroll to the right side, the columns to the left disappear, which I
looking to keep the first column in place.
Could anyone tell me how to make the first column to the laft not to goes
out of screen while I scroll to the rest of the table to the right.
Thanks,
--
John

Table
 

In Excel 07:
Go to View, click Freeze Panes, click Freeze First Column

In Excel 03:
Click Column A to select the whole column, click on Windows, and click on
Freeze Panes.

Hope this helps :)

"John Savy" wrote:

The table that I have generated in Excell is much larger than the screen and
when I scroll to the right side, the columns to the left disappear, which I
looking to keep the first column in place.
Could anyone tell me how to make the first column to the laft not to goes
out of screen while I scroll to the rest of the table to the right.
Thanks,
--
John

Table
 

Thanks, But I'm using Excel 97.
I hope you are femiliar with excel 97.
Thanks,
--
John


"Toast" wrote:

In Excel 07:
Go to View, click Freeze Panes, click Freeze First Column

In Excel 03:
Click Column A to select the whole column, click on Windows, and click on
Freeze Panes.

Hope this helps :)

"John Savy" wrote:

The table that I have generated in Excell is much larger than the screen and
when I scroll to the right side, the columns to the left disappear, which I
looking to keep the first column in place.
Could anyone tell me how to make the first column to the laft not to goes
out of screen while I scroll to the rest of the table to the right.
Thanks,
--
John

Table
 

Did you try the same process as Excel 03?
--
David Biddulph

"John Savy" wrote in message
...
Thanks, But I'm using Excel 97.
I hope you are femiliar with excel 97.
Thanks,
--
John


"Toast" wrote:

In Excel 07:
Go to View, click Freeze Panes, click Freeze First Column

In Excel 03:
Click Column A to select the whole column, click on Windows, and click on
Freeze Panes.

Hope this helps :)

"John Savy" wrote:

The table that I have generated in Excell is much larger than the
screen and
when I scroll to the right side, the columns to the left disappear,
which I
looking to keep the first column in place.
Could anyone tell me how to make the first column to the laft not to
goes
out of screen while I scroll to the rest of the table to the right.
Thanks,
--
John

Table
 

No, I don't have the 03 version.
I know 97 has this option as well, and I used it in the past, but I have
forgotten how it was.
--
John


"David Biddulph" wrote:

Did you try the same process as Excel 03?
--
David Biddulph

"John Savy" wrote in message
...
Thanks, But I'm using Excel 97.
I hope you are femiliar with excel 97.
Thanks,
--
John


"Toast" wrote:

In Excel 07:
Go to View, click Freeze Panes, click Freeze First Column

In Excel 03:
Click Column A to select the whole column, click on Windows, and click on
Freeze Panes.

Hope this helps :)

"John Savy" wrote:

The table that I have generated in Excell is much larger than the
screen and
when I scroll to the right side, the columns to the left disappear,
which I
looking to keep the first column in place.
Could anyone tell me how to make the first column to the laft not to
goes
out of screen while I scroll to the rest of the table to the right.
Thanks,
--
John

Table
 

Toast's suggestion is incorrect.

Select B1 to freeze column A

Select B2 to freeze column A and row 1

This is for Excel 97 through 2003


Gord Dibben MS Excel MVP


On Sun, 25 Jan 2009 11:47:01 -0800, John Savy
wrote:

No, I don't have the 03 version.
I know 97 has this option as well, and I used it in the past, but I have
forgotten how it was.

Table
 

Could you elaborate more on the process, Thanks
--
John


"Gord Dibben" wrote:

Toast's suggestion is incorrect.

Select B1 to freeze column A

Select B2 to freeze column A and row 1

This is for Excel 97 through 2003


Gord Dibben MS Excel MVP


On Sun, 25 Jan 2009 11:47:01 -0800, John Savy
wrote:

No, I don't have the 03 version.
I know 97 has this option as well, and I used it in the past, but I have
forgotten how it was.

Table
 

If you wish to freeze the top 2 rows and the left hand two columns, select
cell C3, then go to the Window menu and select "Freeze Panes".
In general, select the cell below the rows you wish to freeze, and to the
right of the columns you wish to freeze, then go to the Window menu and
select "Freeze Panes".
--
David Biddulph

"John Savy" wrote in message
...
Could you elaborate more on the process, Thanks
--
John


"Gord Dibben" wrote:

Toast's suggestion is incorrect.

Select B1 to freeze column A

Select B2 to freeze column A and row 1

This is for Excel 97 through 2003


Gord Dibben MS Excel MVP


On Sun, 25 Jan 2009 11:47:01 -0800, John Savy
wrote:

No, I don't have the 03 version.
I know 97 has this option as well, and I used it in the past, but I have
forgotten how it was.

Table
 

Where or how do I found this command "freeze pan", or any other command in
Excel 97?
--
John


"David Biddulph" wrote:

If you wish to freeze the top 2 rows and the left hand two columns, select
cell C3, then go to the Window menu and select "Freeze Panes".
In general, select the cell below the rows you wish to freeze, and to the
right of the columns you wish to freeze, then go to the Window menu and
select "Freeze Panes".
--
David Biddulph

"John Savy" wrote in message
...
Could you elaborate more on the process, Thanks
--
John


"Gord Dibben" wrote:

Toast's suggestion is incorrect.

Select B1 to freeze column A

Select B2 to freeze column A and row 1

This is for Excel 97 through 2003


Gord Dibben MS Excel MVP


On Sun, 25 Jan 2009 11:47:01 -0800, John Savy
wrote:

No, I don't have the 03 version.
I know 97 has this option as well, and I used it in the past, but I have
forgotten how it was.

Table
 

Perhaps you missed the part where I said:
" If you wish to freeze the top 2 rows and the left hand two columns,
select
cell C3, then go to the Window menu and select "Freeze Panes".
In general, select the cell below the rows you wish to freeze, and to the
right of the columns you wish to freeze, then go to the Window menu and
select "Freeze Panes"." ?

Are you trying to tell us that in your Excel 97 you can't find the Window
menu, or that on the Window menu you can't see the menu item "Freeze Panes"?

You can find a screen grab of the Excel 97 menus at
http://www.ngfl.ac.uk/resources/excel/excelpage3.pdf and at
http://www.smartcomputing.com/editor...0.jpg&caption=
--
David Biddulph

"John Savy" wrote in message
...
Where or how do I found this command "freeze pan", or any other command in
Excel 97?
--
John


"David Biddulph" wrote:

If you wish to freeze the top 2 rows and the left hand two columns,
select
cell C3, then go to the Window menu and select "Freeze Panes".
In general, select the cell below the rows you wish to freeze, and to the
right of the columns you wish to freeze, then go to the Window menu and
select "Freeze Panes".
--
David Biddulph

"John Savy" wrote in message
...
Could you elaborate more on the process, Thanks
--
John


"Gord Dibben" wrote:

Toast's suggestion is incorrect.

Select B1 to freeze column A

Select B2 to freeze column A and row 1

This is for Excel 97 through 2003


Gord Dibben MS Excel MVP


On Sun, 25 Jan 2009 11:47:01 -0800, John Savy
wrote:

No, I don't have the 03 version.
I know 97 has this option as well, and I used it in the past, but I
have
forgotten how it was.

Table
 

That's exactly correct. What I'm trying to tell you is that in Excel 97 I
can't find the Window menu, or that on the Window menu I can't see the menu
item "Freeze Panes".
--
John


"David Biddulph" wrote:

Perhaps you missed the part where I said:
" If you wish to freeze the top 2 rows and the left hand two columns,
select
cell C3, then go to the Window menu and select "Freeze Panes".
In general, select the cell below the rows you wish to freeze, and to the
right of the columns you wish to freeze, then go to the Window menu and
select "Freeze Panes"." ?

Are you trying to tell us that in your Excel 97 you can't find the Window
menu, or that on the Window menu you can't see the menu item "Freeze Panes"?

You can find a screen grab of the Excel 97 menus at
http://www.ngfl.ac.uk/resources/excel/excelpage3.pdf and at
http://www.smartcomputing.com/editor...0.jpg&caption=
--
David Biddulph

"John Savy" wrote in message
...
Where or how do I found this command "freeze pan", or any other command in
Excel 97?
--
John


"David Biddulph" wrote:

If you wish to freeze the top 2 rows and the left hand two columns,
select
cell C3, then go to the Window menu and select "Freeze Panes".
In general, select the cell below the rows you wish to freeze, and to the
right of the columns you wish to freeze, then go to the Window menu and
select "Freeze Panes".
--
David Biddulph

"John Savy" wrote in message
...
Could you elaborate more on the process, Thanks
--
John


"Gord Dibben" wrote:

Toast's suggestion is incorrect.

Select B1 to freeze column A

Select B2 to freeze column A and row 1

This is for Excel 97 through 2003


Gord Dibben MS Excel MVP


On Sun, 25 Jan 2009 11:47:01 -0800, John Savy
wrote:

No, I don't have the 03 version.
I know 97 has this option as well, and I used it in the past, but I
have
forgotten how it was.

Table
 

Well if you don't know whether you can't find the Window menu, or whether
you do have a Window menu on which you can't see the menu item "Freeze
Panes", there's not much likelihood that we can help you.
--
David Biddulph

"John Savy" wrote in message
...
That's exactly correct. What I'm trying to tell you is that in Excel 97 I
can't find the Window menu, or that on the Window menu I can't see the
menu
item "Freeze Panes".
--
John


"David Biddulph" wrote:

Perhaps you missed the part where I said:
" If you wish to freeze the top 2 rows and the left hand two columns,
select
cell C3, then go to the Window menu and select "Freeze Panes".
In general, select the cell below the rows you wish to freeze, and to
the
right of the columns you wish to freeze, then go to the Window menu and
select "Freeze Panes"." ?

Are you trying to tell us that in your Excel 97 you can't find the Window
menu, or that on the Window menu you can't see the menu item "Freeze
Panes"?

You can find a screen grab of the Excel 97 menus at
http://www.ngfl.ac.uk/resources/excel/excelpage3.pdf and at
http://www.smartcomputing.com/editor...0.jpg&caption=
--
David Biddulph

"John Savy" wrote in message
...
Where or how do I found this command "freeze pan", or any other command
in
Excel 97?
--
John


"David Biddulph" wrote:

If you wish to freeze the top 2 rows and the left hand two columns,
select
cell C3, then go to the Window menu and select "Freeze Panes".
In general, select the cell below the rows you wish to freeze, and to
the
right of the columns you wish to freeze, then go to the Window menu
and
select "Freeze Panes".
--
David Biddulph

"John Savy" wrote in message
...
Could you elaborate more on the process, Thanks
--
John


"Gord Dibben" wrote:

Toast's suggestion is incorrect.

Select B1 to freeze column A

Select B2 to freeze column A and row 1

This is for Excel 97 through 2003


Gord Dibben MS Excel MVP


On Sun, 25 Jan 2009 11:47:01 -0800, John Savy
wrote:

No, I don't have the 03 version.
I know 97 has this option as well, and I used it in the past, but
I
have
forgotten how it was.