|
Sorting
Sorting your data helps you reorganize it in a way that is more relevant to what you are working on. This way, you can view your data more efficiently. With the Sort feature in Excel, you can sort data by columns or rows, in ascending or descending order. Excel lets you sort by up to three columns or rows.
Searching
You can search within any cell or group of cells using the Find feature. Control + F will open the Find window, where you enter your search criteria. The Options let you choose to search within the sheet or the entire book, by columns or by rows, and in formulas, values, or comments.
Clicking the Replace tab lets you find an item and replace it with another.
Filtering
The Filter feature in Excel hides data that does not match your filter criteria so that you can view only the data that you want to view. Watch this demo to find out how to use Excel's AutoFilter feature.
|
