Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide all "except" the visible selected range(s)? Pierre Excel Worksheet Functions 2 August 1st 08 09:21 PM
Create a "cell button" to hide selected cells. Shoolin Patel Excel Worksheet Functions 12 July 30th 07 11:00 AM
Array as a "named range" - formula ok in cells, but error as "named range" tskogstrom Excel Discussion (Misc queries) 11 December 28th 06 04:44 PM
Questionnaire sheet: Select "yes" or "no," and only one can be selected bpatterson Excel Worksheet Functions 2 April 13th 06 11:04 PM
if "a" selected from dropdown menu then show "K" in other cell LEGALMATTERS Excel Worksheet Functions 1 April 13th 06 06:05 PM


All times are GMT +1. The time now is 11:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"