Select some rows, hide the rest?

[Ed]

I'd like to go through my spreadsheets and select certain rows to deal with,
then hide the unselected rows. I can autofilter, but that won't do quite
the same. Is this possible?

Ed

 

[Ken Wright]

You need to supply more detail - there is nothing in your statement so far that I can see that
Autofilter won't deal with. What criteria are you using? Are you proposing to manually go
through your data, mark the rows you want to deal with and then hide the rest - Mark them all with
an X in a helper column, and then autofilter on that column for X.

If that is not what you want to do then you need to clarify the request, and you may also want to
state the criteria you use to determine the rows you want, as we may be able to help you there as
well with some automation.

 

[Andy Brown]

"Ed",

This is crazy but might just work?

With your rows selected, define a name via the Name Box (left of formula
bar). Then hide the entire sheet (CTRL+A, Format -- Row -- Hide). Hit F5,
type the name you defined, press Enter. Then do Format -- Row -- Unhide.

HTH,
Andy

 

[Ed]

You need to supply more detail - there is nothing in your statement so far that I can see that
Autofilter won't deal with. What criteria are you using? Are you proposing to manually go
through your data, mark the rows you want to deal with and then hide the rest - Mark them all with
an X in a helper column, and then autofilter on that column for X.

I didn't think of that. Of course that would work. I've got 7,000 plus
rows, and I did want to go down and manually select the rows I wanted (may
be five, maybe 20), then hide the rest. I can double click to edit the cell
to add a character not found, then AutoFilter to Contains that character.
Then Edit-Replace to remove it. It's a bit of a process, but I don't use it
all that much. I just didn't want to try doing something the hard way if
that function was already available.

Thanks for helping.
Ed

 

[Ed]

Thanks for the help, Andy.

I'll have to try that. I've never worked with named ranges before, so that
didn't occur to me. I wonder if I could put this in a macro: select rows,
pop up an input box that would save my name as a text string, apply it, hide
all, then unhide my named string. Possible?

With named ranges: what if the row I selected for one range is part of
another group I need? Can the same rows, cells, columns be part of more
than one name?

Ed