I am sure there is a simple answer out there...
I am using Excel to create a kind of workbook for my users to fill
in...because I have a few lists with checkboxes, there are columns of varying
width - after all the basic info such as name, date, project, etc is filled
in and the various boxes checked, there are some areas for comments. To
create a more appealing layout, I merged a number of cells so text would
cross the page. The problem is when I tried to use Autofit to allow the
merged cells to expand as text was entered - it didn't work...
If I unmerge the cells,it works fine...
If I enter text text and use autofit first, then merge the cells, it also
seems to work..
But neither are acceptable solutions...
I should be able to create a nice layout and my users should be able to just
enter text and have the rows adjust as they type...
Help....