Donate SIGN UP

Isolating Selected Information In Excel

Avatar Image
Wrangler3 | 07:39 Fri 03rd May 2013 | Computers
4 Answers
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!
Gravatar

Answers

1 to 4 of 4rss feed

Best Answer

No best answer has yet been selected by Wrangler3. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
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
Question Author
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
Question Author
SeaJayPea thank you! A bit of experimentation with filters has produced the desired effect. Once again thanks!
Excellent. You are most welcome.

1 to 4 of 4rss feed

Do you know the answer?

Isolating Selected Information In Excel

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.