ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Expanding info on the top line without increasing the 1a column (https://www.excelbanter.com/excel-worksheet-functions/205619-expanding-info-top-line-without-increasing-1a-column.html)

SILVERTHORNE

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

Sean Timmons

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


Gord Dibben

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



Sean Timmons

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





All times are GMT +1. The time now is 07:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com