quickening up finding informatio

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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.

resolvedResolved · Low Priority · Version Standard

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.

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.

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


 

Excel tip:

View a unique list

You 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.

View all Excel hints and tips


Server loaded in 0.08 secs.