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