Forum Discussion
Excel 2016 - retain color fills converting raw data sheet to table
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.
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.
