From the course: Excel 2016 Essential Training
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Finding and replacing data
From the course: Excel 2016 Essential Training
Finding and replacing data
- Sometimes you're looking for data in a large list, sometimes you're actually trying to replace data. We're looking at a sheet called Find Replace, those two features are actually located in the same place in the Excel menu system. Let's imagine that, in this list we've got in Column D, Status, and the company that operates this organization has said, "We don't want to use the term half-time anymore. "We've got a number of people who are "working quarter time, three quarters time, "we'd rather use the term 'part-time'." So we want to replace the word "half" with "part," and it occurs many times in this list, and the list can be huge. It's always best, if you're trying to find or replace data, to narrow the search first, so rather than looking in the entire list, and that's what would happen if we click a single cell and then start to look. Let's click just Column D. On the Home tab in the ribbon, the far right button, Find and Select. Let's simply replace. Now, we can do a Find…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.