Hide all "except" the visible selected range(s)?

P

Pierre

Is it possible to hide everything that's "not" currently selected?
Lets say: "Top rows of a table, and rows 25 through 50", for instance
would remain visible. They'd be the ones selected; hide everything
else.

I could use it if can be done.

Pierre
 
J

John C

Just curious, if everything is hidden if it is not selected, how do you
select in the first place?
 
S

Spiky

Is it possible to hide everything that's "not" currently selected?
Lets say: "Top rows of a table, and rows 25 through 50", for instance
would remain visible. They'd be the ones selected; hide everything
else.

I could use it if can be done.

Pierre
Click to expand...

How about using a Filter?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to add comments to selected cells within a selected range 30
need a macro to set the print range only for visible rows 1
Auto populate 1
Hide Combo Boxes 0
How do I include only visible cells in a range? 1
Hide row(s) based on drop down selection 6
Hide a visible rows 5
Temporarily show/hide selected table rows 0

Top