Isolating Selected Information In Excel

[Wrangler3]

In Works, if you did ctrl F, the search results would open up in a separate window. This enabled you (for example) to look at all the entries in a spreadsheet pertaining to the search parameter entered, i.e. by client or similar.

When I do a search in excel, it opens up a new window with the cell numbers it has found. Can I then open all these up in a separate window so I have in effect a display of these excel records alone?

Hope I have explained that properly!

[SeaJayPea]

Don't quite see what you're suggesting, but I'd use the Filter option along your column headings then select whatever parameters you want. This way, you can select more than one search.

Good luck

[Wrangler3]

I was concerned that I hadn't explained myself clearly. I use it to keep payments records for a lottery syndicate. In Works, if I searched for 'Mike' it would open up all the transactions in the spreadsheet for Mike and in exactly the same format.

I am trying achieve this in Excel now.

Thanks for any pointers

[Wrangler3]

SeaJayPea thank you! A bit of experimentation with filters has produced the desired effect. Once again thanks!

[SeaJayPea]

Excellent. You are most welcome.