View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pierre Pierre is offline
external usenet poster
 
Posts: 193
Default 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