Food & Drink1 min ago
Isolating Selected Information In Excel
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!
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!
Answers
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.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
I am trying achieve this in Excel now.
Thanks for any pointers
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.