Thread: how do I make the cell expand to fit my text as I type?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default how do I make the cell expand to fit my text as I type?
If cells are merged. the row will not autofit without using VBA

See google search thread for code by Greg Wilson

http://groups.google.com/group/micro...1c160cbeb27874


Gord Dibben MS Excel MVP

On Sat, 23 Sep 2006 00:03:01 -0700, pnwwoman
wrote:

I merged some cells across the width of a spreadsheet and i can't get the
cell to increase it's height as more text is typed in wraps around.

Gord Dibben MS Excel MVP
Reply With QuoteReply With Quote