A lot of the cells in one of my worksheets are irrelevant. I'd like to know which ones I can skip filling in in the future. At the moment if it's worth it I click on a cell in each column and click on Dependents. That does the job but of course it's not ideal.
Is there a way to see all the dependents?
I'm confused as to why Microsoft didn't just enable this ability to highlight a range and click Dependents and all of them show up.
Is there a way to see all the dependents?
I'm confused as to why Microsoft didn't just enable this ability to highlight a range and click Dependents and all of them show up.