Excel 2013 Tutorial For Noobs Part 25: How to Find & Replace Content Numbers & Formulas in Excel

http://www.excelfornoobs.com In this Excel for beginners tutorial I teach you how to search find and replace content, numerical values and formulas in a cell or multiple cells. You can do this by using the Find and Select command. In Excel you can locate cells by using the Find and Replace command. Suppose you wanted to locate a cell or all cells that contained a certain word or number. Instead of searching throughout your worksheet you could use the Find and Replace command and let Excel do the work for you. Find In the Home tab under the Editing group click on the Find & Select command and from the drop-down menu click on Find and the Find and Replace dialog box will appear. The Find and Replace dialog box has two tabs, the Find tab and the Replace tab. Where it says "Find What" enter the content that you want to locate. Now click on the Options button and more search options will appear in the dialog box. Here you have options of Within, Search, Look in, Match case and Match entire cell contents. Use the options to tailor your search and press Find All. find and replace in excel 2013 Within: Here you can choose to search a single worksheet or the entire workbook. Search: Here you can organize your search by rows or columns. If you were to choose By Rows then your search results would be organized by rows. The very next cell in the search would be the very next cell in the row that contained your data. If you organized your search By Columns then the very next cell in your results would be the next cell in the column that contained your data. Look In: Here you can choose to search inside formulas, comments are regular values for the data you want to locate. Match Case: If this box is checked then your search will be case sensitive. Match entire cell contents: If this box is checked then the cell or cells found must contain on the search string and nothing else. Replace Imagine you had a large inventory list with the names of multiple suppliers. What if one of the suppliers changed their company name? It would be very time consuming to change the company name cell by cell. Instead you can use the Find and Replace command and change all cells instantly. In the Find and Replace dialog box make sure the Replace tab is activated. The only difference with the Find tab and the Replace tab is that you have a new box and buttons that allow you to replace the cells in your search results with other content. The options work the same in Replace as the do in Find. Make sure that you use the Match Case and Match entire cell contents if necessary. If you searched and replaced the number 3 with 5 without checking the Match entire cell contents option then the number 2 would be replaced with the number 5 even if it was in a series of numbers. For example, 638 would be 658 after you click Replace All or Replace Next. This tutorial works for Microsoft Excel 2007, Excel 2010 and Excel 2013    / subjectmoney      • Excel 2013 Tutorial For Noobs Part 25: How...