How To: Find, replace & sort in MS Excel

How to Find, replace & sort in MS Excel

In order to Find, Replace, and Sort, using MS Excel, become familiar with your home tab. When you click on Sort, it will give you the opportunity to sort in different ways: e.g. alphabetically. If you accidentally shift your table, you can undo it by using Ctrl + Z. Custom Sort will allow you to be very specific in the way you want your data sorted. You can add or remove a filter with the same drop down menu, in order to be even more precise.

Find will allow you to find a specific value in the table. You will find this in your drop down menu. Replace will allow you to quickly replace specific values that you searched for with Find. This will allow you to continue to use the same spreadsheet over time, by simply refreshing and changing values over time.