Excel: Find and replace - how it works
You can save a lot of time in Excel with the "Find and Replace" function. The larger your spreadsheets are, the more useful the feature is. We show you how to best use the function.
Use the Excel functions "Find and Replace"
You can also copy and paste the contents of individual cells in large Excel tables using Copy & Paste. But that is very complex. This is faster with the "Find and Replace" function:
- First go to the "Start" tab and then go to the "Edit" section.
- Then click on the "Find and Select" binoculars button.
- Select the "Replace" option in the menu.
- Then enter the content to be replaced and the new content. There are still various options available to you to refine your search. For example, you can specify whether upper and lower case should be considered or whether Excel searches only one sheet or the entire workbook.
- You can use the "Replace all" option to replace the data automatically. Excel then exchanges all values at once. Alternatively, the tool shows you every value found and you then decide whether the corresponding value should be replaced or not.
- Of course, you can also use the search function alone.