Format > Wrap Text...go figure! I can't believe it was that easy. Thank you sooooo much. As for problem #2: formula, macro, I don't care whichever is easiest. Do you know of a macro? I can repost this in that forum if need be.