Excel "Format as Table"

[adfo]

Hello,

I use excel 2010. When I select range of data, and click on "Format as Table". I select "My table has header". It does not seem that same name can be used in multiple headers. Excel appends a number to the header name if repeated. Is there a way around this?

 

[SkipVought]

hi,

NO!!!

Because a TABLE means something very specific!!!

faq68-5184

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

Table formatting is primarily NOT to make it look "pretty!"

It is to endow PROPERTIES that give it special features, called Structured Table features.

This is really cool stuff, that has ABSOLUTELY NOTHING to do with visual appearance.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]