| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Expanding info on the top line without increasing the 1a column
Office 1997 allowed stretching the 1A column without expanding the entire
column doesn't seem to work in Office 2003. Please explain |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Expanding info on the top line without increasing the 1a column
Can't remember much about 1997, but 2003 has Merge and Center. This allows
you to make cell A1 cover columns A and B or A through Z, or whatever you'd want. Probably due to this, there wouldn't be a need to retain the feature you describe. "SILVERTHORNE" wrote: Office 1997 allowed stretching the 1A column without expanding the entire column doesn't seem to work in Office 2003. Please explain |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Expanding info on the top line without increasing the 1a column
I think you mis-remember.
Excel 97 nor any other version of Excel has ever allowed one cell to be wider than the rest of the column. Column widths and row heights are properties of the column and/or row. BTW..........1A is not a column or a row. A1 is a cell reference. You may use "center across selection" or the not recommended "merge cells". Gord Dibben MS Excel MVP On Wed, 8 Oct 2008 13:11:02 -0700, SILVERTHORNE wrote: Office 1997 allowed stretching the 1A column without expanding the entire column doesn't seem to work in Office 2003. Please explain |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Expanding info on the top line without increasing the 1a colum
mis-remember. Sounds like a Roger Clemens reference.
Didn't think that was so, but I can't rmemeber 10 years ago any more than I can remember yesterday. "Gord Dibben" wrote: I think you mis-remember. Excel 97 nor any other version of Excel has ever allowed one cell to be wider than the rest of the column. Column widths and row heights are properties of the column and/or row. BTW..........1A is not a column or a row. A1 is a cell reference. You may use "center across selection" or the not recommended "merge cells". Gord Dibben MS Excel MVP On Wed, 8 Oct 2008 13:11:02 -0700, SILVERTHORNE wrote: Office 1997 allowed stretching the 1A column without expanding the entire column doesn't seem to work in Office 2003. Please explain |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to update column info based on column info from another worksh | Excel Discussion (Misc queries) | |||
| How do I sort by info in one column and it stay in line with info | Excel Worksheet Functions | |||
| how do I expand a cell without expanding column | Excel Worksheet Functions | |||
| Increasing the Vertial Size of a 3-D Line Chart | Charts and Charting in Excel | |||
| Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
Linear Mode
