need one PERMANENT FORMAT but format changes row to row

[vanilla bean]

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]

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]

Hi Dave,

Thank you for your answer. However, isn't there a way to set the format for
the whole file so I don't have to continually copy each line. I'm working on
a large file. In Word, you establish a format that remains in force for the
document. Sometimes I reformat an item, and only some of the fields change.

Hmmm...I just thought of something. I could increase the width of each field
so that everything fits in, and then in the end, reformat everything.

 

[Dave Peterson]

You could always apply the formatting to the entire row or column.

You could select all the cells and adjust the rowheight/columnwidth of one of
the selected and all will be made the same.

 

[vanilla bean]

Hi Dave,
I apply the formatting but it doesn't remain formatted that way.
That's why I'm so frustrated. I think something may be wrong with my
program. It's time to write the big guns.

 

[Dave Peterson]

Are you formatting the entire column? Or a subset of that column?

Hi Dave,
I apply the formatting but it doesn't remain formatted that way.
That's why I'm so frustrated. I think something may be wrong with my
program. It's time to write the big guns.

 

[Gord Dibben]

And just who would those be?


Gord Dibben MS Excel MVP