Originally Posted by alanh
Justify only works on (a) cells with word wrap enabled, and (b) not on the last line. If you only have one line, it's not justified.
Code:
|This is a test of |This is a test of|
|justify. |justify. |
The first column is right-aligned, and the second is justified.
I think you mean left-aligned, which is what General defaults to for text, but in any case those were exactly the problems I ran into when I tried to use Justify to make this happen. The only thing I can suggest is that, if this is a one-time deal and the text to be stretched out won't change, experiment with spaces between the letters to see if that might look OK. Caution: if the spreadsheet might be used on other computers that could have different versions of the fonts or other system-level differences, the results of this sort of hard formatting can look weird.