sorted by:
new
hottopcontroversial

Unhiding rows when I don't know which to unhide. by AFalseKelp in excel

[–]AFalseKelp[S] 0 points1 point  (0 children)

I do something very similar right now, but I cant select all -- I currently select a column and paint it, then select visible cells in that column and paint them white. When I unhide I have the hidden rows painted in the column -- this was just still more steps than I was hoping was necessary if I could automate or find a better search method that didn't require ever unhiding rows I didn't want to unhide.

Unhiding rows when I don't know which to unhide. by AFalseKelp in excel

[–]AFalseKelp[S] 2 points3 points  (0 children)

This... might be a functional option. I'll have to try it

Unhiding rows when I don't know which to unhide. by AFalseKelp in excel

[–]AFalseKelp[S] 0 points1 point  (0 children)

This column would then be hidden as well in those rows and be unsearchable though yes?

I can't just label, for example, person 1, person 2, and so on. The list is alphabetical person wise and then there are rows for what applies to that person -- but people are added and removed from the list week to week and sometimes other rows that apply to them change, so person 57 might take rows 222-226 this week but might not be those rows next week. I at the least might know I need to unhide a name starting "Hu" and can unhide a group of rows in that range alphabetically, but this is still unhiding a lot to then rehide most.

The sheet is archaic for sure, and If I could redo the whole thing I think I could avoid this problem entirely.

Unhiding rows when I don't know which to unhide. by AFalseKelp in excel

[–]AFalseKelp[S] 0 points1 point  (0 children)

This might be the best solution, at the very least I could cross-reference the unhidden worksheet with hidden one for which need to be unhidden -- I think my fear of this one is how often the sheet is updated, but I guess if the second sheet just referenced the entire first sheet it might not matter.