Finding Content
Track Your Course Progress
You are currently studying as a guest. Your course progress and quiz results will not be saved unless you login to your EduCourse account. Login to track your progress and qualify for your certificate.
It can be hard and time consuming to find details while dealing with a lot of data in Excel. You can quickly browse your workbook using the Find feature, which also allows you to use the Replace feature to change content.
Finding content:
We will use the Find command in our example to locate a specific department in this list.
- On the Home tab, click the Find and Select command and from drop-down menu select Find.
- Enter the content you want to find from the Find and Replace in the dialog box that will appear. We will type in our example the department’s name.
- Click Find Next. If the content is found, the cell with the content will be chosen.
- To find more examples, press Find Next or Find All to see each instance of the search word.
- Upon completion, click Close to exit the Find and Replace dialog box.
Even by pressing Ctrl+F on your keyboard, you can access the Find command.
Click Options in the Find and Replace dialog box to see the advanced search criteria.
