Results 1 to 6 of 6

Auto expand Row when typing lenthy text

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-30-2007
    Location
    London, UK
    MS-Off Ver
    Microsoft Office 2007
    Posts
    317

    Smile Auto expand Row when typing lenthy text

    I am trying to have a form that people can fill in and I know it would be far better to use Word for this purpose but it looks so much better in Excel format. The problem is I have merged about 10 cells in a row and copied this format down a few rows.

    Now although I have set the 'Text Wrap' option the rows will not auto expand unti to accodate all the text unless I do a ALT-ENTER combo. The problem is anyone using this spreadsheet to complete the form may not know how to use this feature.

    Is there anyway Excel can expand automatically or do I need some sort of Macro based in the Worksheet that will automatically adjust the row if the text is too long to fit?

    Thanks in advance for any help offered.
    Last edited by Zyphon; 11-18-2008 at 06:08 PM.
    Best Regards.

    Michael
    -----------------------------------
    Windows Vista, Microsoft Office 2007

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1