| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to format sheet to show first box whilst tabbing across sheet
I have never used excel to any great extent but can find my way around simple
tasks. However, I have one workbook which had 1 sheet of names in column A, addresses in column B and other information going across to column y. When I tab across I can still see the info in column A but the info in the column I am in is now viewed next to column A. I have added a sheet to this workbook with similar information but when I tab across the view of the column A goes off the screen. Can anyone help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to format sheet to show first box whilst tabbing across sheet
The first sheet has Freeze Panes enabled.
To freeze column A select B1 and WindowFreeze Panes. Gord Dibben MS Excel MVP On Wed, 22 Aug 2007 10:38:02 -0700, Trish wrote: I have never used excel to any great extent but can find my way around simple tasks. However, I have one workbook which had 1 sheet of names in column A, addresses in column B and other information going across to column y. When I tab across I can still see the info in column A but the info in the column I am in is now viewed next to column A. I have added a sheet to this workbook with similar information but when I tab across the view of the column A goes off the screen. Can anyone help? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to format sheet to show first box whilst tabbing across sheet
Hi Trish
To freeze the first column and the first row, select cell B2 then use Window (menu), freeze In Excel 2007 it is View, Freeze panes You might want to take a look at http://www.mvps.org/dmcritchie/excel/freeze.htm -- HTH, David McRitchie, Microsoft MVP -- Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "Trish" wrote in message ... I have never used excel to any great extent but can find my way around simple tasks. However, I have one workbook which had 1 sheet of names in column A, addresses in column B and other information going across to column y. When I tab across I can still see the info in column A but the info in the column I am in is now viewed next to column A. I have added a sheet to this workbook with similar information but when I tab across the view of the column A goes off the screen. Can anyone help? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to format sheet to show first box whilst tabbing across sh
Excellent, thank you, It works!
"Gord Dibben" wrote: The first sheet has Freeze Panes enabled. To freeze column A select B1 and WindowFreeze Panes. Gord Dibben MS Excel MVP On Wed, 22 Aug 2007 10:38:02 -0700, Trish wrote: I have never used excel to any great extent but can find my way around simple tasks. However, I have one workbook which had 1 sheet of names in column A, addresses in column B and other information going across to column y. When I tab across I can still see the info in column A but the info in the column I am in is now viewed next to column A. I have added a sheet to this workbook with similar information but when I tab across the view of the column A goes off the screen. Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i get sheet 2 to show a specific section of sheet 1?Please | Excel Worksheet Functions | |||
| tabbing in a protected sheet | Excel Discussion (Misc queries) | |||
| How do I get items from sheet 3 to show up on sheet 1 and 2? | Excel Worksheet Functions | |||
| Excel: have add'l rows entered in sheet 1 always show up in sheet | Excel Worksheet Functions | |||
| tabbing from 1 sheet to another in the same .xls w'o clicking | Setting up and Configuration of Excel | |||
Linear Mode
