I'd just select one of the perfectly formatted rows
Edit|copy
select the row(s) that I want to fix
Edit|Paste special|formats



vanilla bean wrote:

I set a format for the file with a font, font size, alignment, word wrap, but
if I add something to the row, add another row, the format I want is gone.
It's very frustrating and time-consuming to have to reformat the rows all the
time. I have extend the formatting on. There must be a way to keep the
formatting. Excel 2003 running on XP. Thanks for your help.

--

Dave Peterson