View Single Post
Old 11-29-2022, 02:01 PM
sheridan60 sheridan60 is offline Windows 10 Office 2016
Join Date: Aug 2022
Posts: 6
sheridan60 is on a distinguished road
Question Collapse Rows When NOT Selected

I have a large spreadsheet with multiple updates for each line item, creating the need to scroll a lot to find information. I would like the rows to expand/collapse based on when that row is selected/unselected. I am not referring to hiding rows and I don't want to use Groupings for more than one reason. Is it possible to setup my spreadsheet in this manner? I have attached two examples: #1 is what my spreadsheet looks like and #2 is how I would like to see it. Notice that in example #1, column B, I have the identifier in row 9 and the remaining rows below is what I would think might be collapsible.
Attached Images
File Type: png Screenshot collapse-expand1.png (28.5 KB, 12 views)
File Type: png Screenshot collapse-expand2.png (7.4 KB, 11 views)
Reply With Quote