Hello,
I am a little confused. My department sharea a spreadsheet that lists all of our current projects and who is assigned them. My manager hides all the detail rows of each project and only lets the heading row show. When I go in to the sheet with write access, I change the filter to only show me, that actually shows the row where a specific project starts, I then reset the filter to select all again(that was the default when I opened the sheet) and I go to the row and do what I need. My issue is when I select myself and then select all, all the hidden rows in the sheet are now displayed, is this a function of the filter? Is there a way around that with still using the filter function? Thanks
Bookmarks