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

On Aug 1, 1:35*pm, John C <johnc@stateofdenial wrote:
Just curious, if everything is hidden if it is not selected, how do you
select in the first place?
--
John C



"Pierre" wrote:
Is it possible tohideeverything 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;hideeverything
else.

I could use it if can be done.

Pierre-Hidequoted text -

- Show quoted text -

I wanted to select rows 1-3, 24-98, and 125-230, and just hide the
others.
(Rather than select what I want to hide and hide them; or Rather than,
highlight these, and paste them onto another worksheet.)
I know, it's Monday.
Thanks
Pierre