Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to have cells automatically expand when typing
Is there a way to have the cells automatically increase row height when what
you are typing is exceeds the cell dimensions? I have to describe entries in a cell and the column width is good, I don't want that to change but I would like the row height to automatically change so I can see all the text. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to have cells automatically expand when typing
You could use an event macro that autofits the changed cell's row height
whenever you make a change. If you want to try, rightclick on the worksheet tab that should have this behavior. Select view code and paste this into the code window: Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Target.EntireRow.AutoFit End Sub But be aware that most macros destroy the Edit|Undo and Edit|Redo stack. (I'd just do it manually so I wouldn't lose that.) Northwoods wrote: Is there a way to have the cells automatically increase row height when what you are typing is exceeds the cell dimensions? I have to describe entries in a cell and the column width is good, I don't want that to change but I would like the row height to automatically change so I can see all the text. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to have cells automatically expand when typing
Have you also tried: format rowautofit?
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to have cells automatically expand when typing
Thank you both, simple for me is best. What I did is checked wrap text under
format cells -- alignment tab. Autoformat did not work and the macro sounded a bit iffy. Thanks again "Northwoods" wrote: Is there a way to have the cells automatically increase row height when what you are typing is exceeds the cell dimensions? I have to describe entries in a cell and the column width is good, I don't want that to change but I would like the row height to automatically change so I can see all the text. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I automatically expand merged cells to fit text in excel | Excel Discussion (Misc queries) | |||
How do I enter a decimal automatically without typing it every ti. | New Users to Excel | |||
How do I automatically expand a merged cell with wrapped text? | Excel Discussion (Misc queries) | |||
Excel merged cell - can it automatically expand as text is typed? | New Users to Excel | |||
How can I automatically have 10% added to cell after typing a valu | Excel Worksheet Functions |