| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Macro specific table to generic table? | Excel Discussion (Misc queries) | |||
| Pivit table- cell on spread sheet referencing pivot table field | Charts and Charting in Excel | |||
| entry removed from source table remains in pivot table pull down | Excel Worksheet Functions | |||
| Excel Pivot Table Plugin? (crosstab to data table) | Excel Discussion (Misc queries) | |||
| PIVOT TABLE - Summary Table into a Databasae Table. | Excel Worksheet Functions | |||
Hybrid Mode
