find option

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Find option

Find option

resolvedResolved · Low Priority · Version 2003

Mikel has attended:
Excel Intermediate course

Find option

Can you send me more info on 'find' option plese?

RE: find option

Hi Mikel

Thank you for your question and welcome to the forum.

The Find feature gets Excel to search through a spreadsheet for any occurrences of whatever you ask it to find. The advantage of it is that it allows you to find something quickly in a spreadsheet rather than having to hunt through a spreadsheet yourself.

For example, if you have a list of sales and you want to locate a sale to a particular company, you can use the Find feature to get Excel to search for the name of that company.

You could do this by going to Edit - Find and type the name of the company you are looking for and then click the Find Next button to get Excel to locate what you are looking for. Excel will highlight the next cell that contains this word.

I hope this helps.
Amanda


 

Excel tip:

Create Charts with One keystroke

Create a graph with one click

1. Select your data.
2. Press F11.
3. You have a graph.

View all Excel hints and tips


Server loaded in 0.09 secs.