From the course: Excel 2013 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Finding and replacing data - Microsoft Excel Tutorial
From the course: Excel 2013 Essential Training
Finding and replacing data
On the Home tab in the ribbon the editing group on the right-hand side contains a number of features including a binoculars icon for Find & Select. Some of the things we're about to show you in this movie could be done more efficiently with a filter, but not always. Sometimes we're simply looking for data. Let's imagine that we're looking for somebody named Rick. Before searching for data in Excel it's best to narrow down the search. If you click a single cell and then activate the Find feature, you will automatically be looking in the entire worksheet. If you select a range--possibly you have this range already selected for a different reason-- if you start a Find now, we're only looking for data within the range. Now let's say we are looking for someone named Rick. The only location in this worksheet where we see names like that is column A. Let's go to column A, select that first, and now our search process using Find will only be looking in column A. Notice it's "Find and…
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.