ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Expand only one cell in a column (https://www.excelbanter.com/excel-discussion-misc-queries/107593-expand-only-one-cell-column.html)

brocklang

Expand only one cell in a column
 
I have a worksheet where I have text at the top (describing the worksheet)
but in order to enter all the text I have to expand these cells, but I don't
want the cells further down in the same columns to expand.

Is there a way to do this?

Kevin B

Expand only one cell in a column
 

Enter your text in one cell and when finished select the cell with the text
and the number of columns you think you'll need based upon the length of your
entry. Assuming that the text is in A1, select A1 through C1 and do the
following:

Click FORMAT in the menu and select CELLS
Click the ALIGNMENT tab in the dialog box and locate the MERGE CELLS check
box and click it to activate it.

Click OK

--
Kevin Backmann


"brocklang" wrote:

I have a worksheet where I have text at the top (describing the worksheet)
but in order to enter all the text I have to expand these cells, but I don't
want the cells further down in the same columns to expand.

Is there a way to do this?



All times are GMT +1. The time now is 04:09 PM.

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