ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Hide all "except" the visible selected range(s)? (https://www.excelbanter.com/excel-worksheet-functions/197288-hide-all-except-visible-selected-range-s.html)

Pierre

Hide all "except" the visible selected range(s)?
 
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


John C[_2_]

Hide all "except" the visible selected range(s)?
 
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 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



Spiky

Hide all "except" the visible selected range(s)?
 
On Aug 1, 1:00 pm, Pierre wrote:
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


How about using a Filter?


All times are GMT +1. The time now is 04:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com