Stretch or shrink text to fit cell(s)

**PY_** · 10-07-2010, 08:22 AM

I am generating a contract in excel. The last two pages of the contract is just wording (about 200 lines of it). Is there a way i can fix the justification of it so its aligned on both the left and right side of the page when printed? That way, that no matter how litte or much i type for each row, the final printed view of the text will all line up on the left and right.

**Andy Pope** · 10-07-2010, 08:38 AM

Sounds like a job for Word.

Does the text alter with the contract?

Why use Excel at all?

If you are using Execl to calculate details of the contract perhaps you need to use a combination of Excel & Word. Where the values are populated from Excel into Word.

**PY_** · 10-07-2010, 08:41 AM

Yea i was afraid its only avilable in Word. The text itself never changes so i even thought about making the text a "picture" and inserting it into excel. Im using Excel because the rest of the worksheet is tied to a program we use here and it has to be excel with the way the program is setup. The last two pages of the contract is just verbage.

**Andy Pope** · 10-07-2010, 08:52 AM

You can set the alignment of a cell to be distributed.

Each lines worth of text will be handled. So you either need lots of cells or cells with lots of ALT+ENTERs (Line feeds).