From the course: Excel 2019 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Finding and replacing data
From the course: Excel 2019 Essential Training
Finding and replacing data
- [Instructor] Whether you're looking for data in a list, or trying to replace data with other data, the Find and Select button located on the Home tab gives you multiple options for meeting these objectives. In this worksheet, called Find and Replace, it's in the workbook 05 Layout, we've got a list of data here, and we wanna make some changes. Sometimes you're just curious, you're trying to find something, you wanna know if it exists. We're looking in column C. I'm curious as to whether, although I see one training group here, is there another department that has the word "training" in it? Let's select column C. Before looking for information, it's always best to narrow it down by either highlighting cells or selecting columns, and off to the right on the Home tab, Find and Select. Let's choose Find, and in this dialog box, you might see a color here, you might see a preview. You can search by format, that's a bit unusual, but let's search for content itself. If there is an existing…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.