need one PERMANENT FORMAT but format changes row to row
 

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.

need one PERMANENT FORMAT but format changes row to row
 

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

need one PERMANENT FORMAT but format changes row to row
 

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" wrote:

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

need one PERMANENT FORMAT but format changes row to row
 

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 wrote:

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" wrote:

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


--

Dave Peterson

need one PERMANENT FORMAT but format changes row to row
 

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" wrote:

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 wrote:

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" wrote:

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


--

Dave Peterson

need one PERMANENT FORMAT but format changes row to row
 

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

vanilla bean wrote:

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" wrote:

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 wrote:

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" wrote:

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


--

Dave Peterson


--

Dave Peterson

need one PERMANENT FORMAT but format changes row to row
 

And just who would those be?


Gord Dibben MS Excel MVP

On Sat, 26 Sep 2009 11:10:01 -0700, vanilla bean
wrote:

It's time to write the big guns.