Forum Discussion
averageOfficeUser
Feb 02, 2024Copper Contributor
Filtering in Excel using a Table
First - Is there a way to format a table in Excel where you can hide redundant cells, but maintain the ability to filter for the data I need? Example: Here the three instances of the Perso...
PeterBartholomew1
Feb 02, 2024Silver Contributor
You can conditionally format the font colour to match the cell fill colour.
That only changes the visual appearance of a flat data structure. If you wish to have one to many links using foreign keys that would require considerable effort to set up and maintain in Excel.