11 votes2 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →Simon Jewell commented
I'd like to add to this list. I agree that CF needs a general overhaul so that it works nicely with Tables.
Tables know about columns and rows but CF doesn't and it should. For example, if you add a new row to a table, the range of cells under the CF duplicates the format, so you end up with loads of duplicate rules that make editing the CF difficult. (Clearly the teams developing these features didn't work together.) It would be good to do a review so that the CF range uses the Table columns as references, in the same way that a power pivot table does for data fields, for example.
16 votes4 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →