Forum Discussion
How avoid new header/line created at applying a custom style?
I have a simple list of items. I want to format them as color strips. I select the cells and apply some "custom formating". But always it inserts a "header line". If after formating I cli...
Daniel_Calegari That's by design. The whole purpose of formatting data as a table is to get a structured data set with column headers so that you can address columns by their name.
The dialogue box asking for a a header or not is used to tell Excel wether the data has a header row or not. If not, a header row (be it with not very meaningful names) will be created.
Now, if you do not want to work in a table with headers, look into conditional formatting. In the attached file I have formatted each odd numbered row to have a light grey background.
- Thank you, but this design is very dumb!
Why in the hell Excel does include a new line if I tell "no header"?
This new line mess all the others.
And if I change the options to not generate the header line and filters, well, next time I use the feature it could remember my settings... why not?
"Conditional formatting". I was using it before. But it is a bit laborious to apply it every time I need only a "zebra worksheet".
