In Excel 2000, if I had text that extended beyond the page (let's say it's in A1 but extends out past E1), I would select A1:E1 and then Edit>Fill>Justify. I would receive the warning that it will extend to other rows and will overwrite anything below it and I would click "OK" and volia, it would then be broken up in A1, B1, etc but not extending beyond column E. This doesn't seem to work in 2007 using Home>Editing>Fill>Justify. Does this no longer work?
Thanks
Nevermind, I tried it on a new sheet and is working fine. Not sure what happened there.
Bookmarks