WEBVTT Kind: captions Language: en 00:00:08.500 --> 00:00:12.750 In workbooks with lots of data, when I’m looking for something, I sometimes have trouble 00:00:12.750 --> 00:00:16.910 finding a specific word or phrase that I know is in there somewhere. 00:00:16.910 --> 00:00:21.000 The Find feature can help by searching the workbook for you. 00:00:21.000 --> 00:00:24.250 Just click Find & Select on the ribbon. 00:00:24.250 --> 00:00:30.760 Then choose Find… and type the word or phrase you're looking for. 00:00:30.760 --> 00:00:35.200 When you're done, click Find Next in the dialog box. 00:00:35.200 --> 00:00:39.750 If the word or phrase is found, the cell containing it will be selected. 00:00:39.750 --> 00:00:43.829 At times, you may find that you've made a mistake throughout your workbook, or you need 00:00:43.829 --> 00:00:46.960 to swap a certain word or phrase for another. 00:00:46.960 --> 00:00:50.309 For that, you can use the Replace feature instead. 00:00:50.309 --> 00:00:53.520 I actually need to change the name of this department from Accounting to… 00:00:53.520 --> 00:00:54.520 Finance. 00:00:54.520 --> 00:01:02.219 To continue, go ahead and click Replace… and it will jump to the next instance automatically. 00:01:02.219 --> 00:01:07.690 If you want to skip the current instance without replacing it, click Find Next instead. 00:01:07.690 --> 00:01:14.470 Alternatively, to replace every instance without having to review each one, click Replace All… 00:01:14.470 --> 00:01:18.680 and the entire workbook will be updated. 00:01:18.680 --> 00:01:22.400 When it comes to using Replace All though, it’s important to remember that it could 00:01:22.400 --> 00:01:26.560 find matches you didn’t anticipate, and might not actually want to change. 00:01:26.560 --> 00:01:31.430 Generally, you don't want to use Replace All because it doesn't give you the option of 00:01:31.430 --> 00:01:33.920 skipping anything you don’t want to change. 00:01:33.920 --> 00:01:38.280 So you should only use this option if you're absolutely sure that it won't replace anything 00:01:38.280 --> 00:01:41.070 you didn’t intend it to. 00:01:41.070 --> 00:01:44.799 Now that you know how to use Find and Replace, you can put this time-saving technique to 00:01:44.799 --> 00:01:46.560 work in your Excel spreadsheets.