Find and Replace in Excel Spreadsheets

If you need to find or change something in your spreadsheet, you can use the Find and Replace feature.
To find some data/text info, press Control + F and type in the info you are trying to find. Press Enter to go to the next instance of that info and Escape to come out of the Find dialogue.
If you want to find and replace something, wherever it occurs in your spreadsheet file, press Control + H. This dialogue has two fields, one for the info to find and one for the replacement. Complete these fields and then you can Tab to Find Next, press Enter, and then press Escape to check what it has found. To go ahead and replace, press Control + H again, Tab to Replace and press Enter.
If you are feeling confident, you can Tab to Replace All and press Enter, and it will replace the info in all instances throughout the spreadsheet.
The Control + F and Control + H shortcuts for Find and Replace also work in a similar way in other Microsoft applications like Word and Powerpoint. But Excel also has an extra feature called Find All. When in the Find and Replace dialogue, enter your info and then Tab to Find All and press Enter. This will give you a list of instances of the information and exactly where they are.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.