FlyerTalk Forums - View Single Post - MS Excel Help
Thread: MS Excel Help
View Single Post
Old May 24, 2006 | 8:00 am
  #35  
Efrem
FlyerTalk Evangelist
40 Countries Visited
3M
All eyes on you!
25 Years on Site
 
Join Date: May 1998
Location: Massachusetts, USA; AA 2.996MM & Plat Pro, DL 1MM, GM & Flying Colonel
Posts: 25,036
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.
Efrem is offline