![]() |
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? |
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