Formatting As Table with OUT header row formatting

[magmike]

I am on Windows XP and Excel 2007. I would like to be able to just
format Data rows, however, when I Format As Table, it insists on using
a header row or creating one for me. Because it also automatically
turns on filtering for the header column it totally screws up my
column widths! I have worked hard on these widths and do not want them
to change.

My end goal is to apply every other row shading that changes to
maintain the everyother row shading when I insert or paste rows in the
middle somewhere.

Thanks in advance for your help,

magmike

 

[Zaidy036]

I am on Windows XP and Excel 2007. I would like to be able to just
format Data rows, however, when I Format As Table, it insists on using
a header row or creating one for me. Because it also automatically
turns on filtering for the header column it totally screws up my
column widths! I have worked hard on these widths and do not want them
to change.

My end goal is to apply every other row shading that changes to
maintain the everyother row shading when I insert or paste rows in the
middle somewhere.

Thanks in advance for your help,

magmike

One way is to use the free ASAP-Utilities

 

[magmike]

One way is to use the free ASAP-Utilities

Thank you for that piece of information. I am looking forward to
trying on my home computer. Unfortunately, due to our companies
policies, I will not be able to use that on my work computer. So I am
still hoping for a solution to my problem that doesn't involve other
software or add-ins.

magmike

 

[Ron Rosenfeld]

My end goal is to apply every other row shading that changes to
maintain the everyother row shading when I insert or paste rows in the
middle somewhere.

Use conditional formatting.

Select your current table (or select one cell in the table and then use the format painter to copy the formats to the other cells).

Conditional Formatting / New Rule / Use a Formula
Formula =iseven(row())
Format: Fill any color
Formula = isodd(row())
Format: Fill: Some other color

After you have applied the formatting to the table, if you insert or delete rows from the middle, the formatting will readjust. If you add rows to the beginning or end, you will probably have to copy the formatting (use the format painter).

 

[magmike]

Use conditional formatting.

Select your current table (or select one cell in the table and then use the format painter to copy the formats to the other cells).

Conditional Formatting / New Rule / Use a Formula
   Formula  =iseven(row())
        Format:  Fill  any color
   Formula   = isodd(row())
        Format:  Fill:  Some other color

After you have applied the formatting to the table, if you insert or delete rows from the middle, the formatting will readjust.  If you add rows to the beginning or end, you will probably have to copy the formatting (use the format painter).

Perfect, thanks!

 

[Ron Rosenfeld]

Perfect, thanks!

Glad to help. Thanks for the feedback.

 

[magmike]

One way is to use the free ASAP-Utilities

Zaidy - Checked this out on my home computer - very cool! Do you know
of anything similar for MS Access?

magmike

 

[Zaidy036]

Zaidy - Checked this out on my home computer - very cool! Do you know
of anything similar for MS Access?

magmike

Sorry no, I do not use MSA. Try Google "free utilities MS Access"