98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Quickening up finding information on a spreadsheet.
Quickening up finding information on a spreadsheet.
Resolved · Low Priority · Version Standard
Wed 13 Feb 2008, 16:28Delegate Bronagh said...
Bronagh has attended:
Excel Introduction course
Quickening up finding information on a spreadsheet.
If I need to find a specific item on a spreadsheet ie: all mentions of maths, what is the best method to use. I often get calls to find all our teachers with qualifications in a particular subject across a certain region and it would be great to have a method set up so I can save time.
Wed 13 Feb 2008, 16:35Delegate Paul said...
RE: Quickening up finding information on a spreadsheet.
All depends on how your spreadsheet is layed out. It can be done, but not easily.
It's easy to do in MS Access if you are able to do it in that rather than Excel, but if you have to do it in Excel, then I'm sure we can work out a way if you provide more information on how your workbook is laid out.
Mon 18 Feb 2008, 16:02Trainer Mark said...
RE: Quickening up finding information on a spreadsheet.
Hi Bronagh
Sorry i haven't got back to you sooner the best way to search for the info you need is to run a filter, highlight the cells you want to search then go to the data menu, then filter and auto filter.
When you see then drop down arrows choose the option you want to filter from the desired drop down to find just the thing you are after
You can additionally have more than one filter running at once, try this out see if it helps
Mark East
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:View a unique listYou have a column with hundreds of entries, and you need to see what unique items are entered in it. Select any cell in that column, hold down Alt and press the down arrow: Excel produces an alphabetically-sorted list of unique entries in that column. |
