Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-29-2022, 02:01 PM
sheridan60 sheridan60 is offline Collapse Rows When NOT Selected Windows 10 Collapse Rows When NOT Selected Office 2016
Novice
Collapse Rows When NOT Selected
 
Join Date: Aug 2022
Posts: 7
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
  #2  
Old 11-30-2022, 01:23 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now Collapse Rows When NOT Selected Windows 10 Collapse Rows When NOT Selected Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi
please post sheets instead of pictures on which we cannot work. Thanks
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Tags
collapse, expand

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word table set selected rows height eduzs Word VBA 0 09-06-2020 10:50 AM
Collapse Rows When NOT Selected Extract a matrix of another matrix defined by selected rows marked with an x Tommy7571 Excel 19 03-20-2019 08:39 AM
Collapse Rows When NOT Selected Macro that deletes all empty rows in selected table MathiasFC Word VBA 2 02-10-2019 04:06 PM
Collapse Rows When NOT Selected Set Range based on selected rows. 14spar15 Excel Programming 8 11-19-2018 08:08 AM
Temporarily show/hide selected table rows glricht Word Tables 0 12-29-2009 05:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:32 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft