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.