Excel 2016 - retain color fills converting raw data sheet to table

Regular Visitor

How do I create a table from a large spreadsheet of raw data in which color fills per cell are utilized to signify different projects (for filtering] without losing the fill colors in the table? Excel 2016. Thank you. 

1 Reply


As far as I know, fill colors are preserved when you convert a range to a table. Only cells that have No Fill will use the table style coloring.