Width Auto-Adjust

joferder

Board Regular
Joined
Dec 18, 2005
Messages
57
I am in the process of creating a form for the place that I work and I am using Excel to make the form look exactly like the form that was created in Word. This requires me to make it so that the cells can have multiple lines of text typed into it and they will expand if more than one line is entered. In one of the lines that I need this to work I entered two lines of text and selected both AutoFit and I also tried double clicking on the bottom line of the cell (on the left side where it numbers the cells) and neither of them actually did anything. I'm sure that some one will suggest that I just adjust the row width manually but the problem with that is that it leaves too much room for error and we would prefer that the row adjusts itself automatically. If any knows how to fix this problem I would really appreciate any help.

Thanks
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

parmel

Active Member
Joined
Aug 24, 2005
Messages
324
If you want to adjust the width of a cell, you have to AutoFit the column not the row. It seems from your message that you may have been trying to do the AutoFit on the row.
 

joferder

Board Regular
Joined
Dec 18, 2005
Messages
57
Thanks for your input, but the solution that you suggested doesn't really resolve the issue that I am having. I need the entire form to remain on one page so that when we have pilots print it out it doesn't require multiple pages to be printed. Also I tried making the column autofit and it still didn't work. I am thinking that neither of them work because I have merged several cells together in that row.

John
 

parmel

Active Member
Joined
Aug 24, 2005
Messages
324
The merged cells are definitely the problem. I tried it out and, as you said, you cannot autofit the width. You also cannot wrap the text in merged cells. Can you unmerge the cells?
 

TrippyTom

Well-known Member
Joined
Nov 16, 2004
Messages
587

ADVERTISEMENT

Convince the bigheads in your office to fork over the cash for Acrobat Writer. It will save you a ton of headaches! And if you already have that software, why are you using Excel for this?
 

joferder

Board Regular
Joined
Dec 18, 2005
Messages
57
The problem with unmerging the cells is that it will screw up the alignment of the blocks that need to be filled in. We may have come up with a compromise by just adjusting the width of the row so that three rows of text will fit. As far as text wrap for the cell is concerned that is not a problem because it seemed to work for me. As far as the bigheads buying Acrobat Writer...yeah right that'll happen. I work for the US Air Force and even if they did buy the program it would take them three years to install the program. Plus getting them to buy a program to make my life easier just isn't likely. Thanks for all of your input.

John
 

TrippyTom

Well-known Member
Joined
Nov 16, 2004
Messages
587
Don't assume they won't allow it. Give it a try. They're likely to listen if you point out it will improve productivity, improve morale (less frustration and time wasted) and make everyone more productive! Besides, since you work for the Air Force you could probably get a severe discount.

There's a lot you can do with Acrobat Writer's forms engine. On second thought, if you become more productive, they might throw more work at you; that's what happens with me. So it's up to you I guess.
 

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985
As far as "Unmerging the Cells", try using "Center Across Selection" formating instead. It shows the same on the page but does not have the problems that Merged cells do.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,536
Messages
5,572,774
Members
412,482
Latest member
arooshrana2
Top