Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

How avoid new header/line created at applying a custom style?

Copper Contributor

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 click at "Table Design" and then "options" and remove the check mark at header", then the header filter disappers... but my data is still one line above original position (because of that header line that was inserted).




I'm using Excel Web to fast edit some email file. It is better to read each color different.

excel autoformato irritante.jpg

That's it.

1 Reply

@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.