- When you go to sort data in Excel , specifically when you order your sheet based on a certain set of values, you will have to select the whole document so that it doesn't change the order of the data sheet.
- You can unfilter Excel sheets even after saved, but you can't undo a sort in the same way.
- Visit Business Insider's homepage for more stories .
ADVERTISEMENT
How to filter data in Microsoft Excel to organize and sort your spreadsheet
You can filter data in Excel based on either certain parameters in columns or over the whole sheet.
Excel Spreadsheet Getty 1152104531
Filtering in Excel allows you to organize your data in multiple ways.
Using a filter, you can cut down the amount of data shown on your sheet based on the values for either a certain selection, such as a certain column, or for the whole document. You can also reorder your sheet based on the numerical order of values in a certain column.
If you want to see all the values in a sheet, you can undo the filter as well.
ADVERTISEMENT
Check out the products mentioned in this article:
How to filter data in Excel for one column
ADVERTISEMENT
1. Select the column by clicking the corresponding letter at the top.
2. Click on "Data" along the top toolbar.
3. Click on "Filter" in the top toolbar. An arrow will show up in the top of the column.
How to filter in Excel
Ryan Ariano/Business Insider
4. Click on the arrow at the top of the column.
ADVERTISEMENT
5. It will show the "Filters" pop-up.
6. Click on "Number Filters," which pulls up a more detailed pop-up.
7. Click on the setting you wish to filter by. Click "OK." In this example, the sheet will be filtered by data greater than 5000.
How to filter in Excel
Ryan Ariano/Business Insider
This will only display the data along the parameters you choose, based on that column. For example, it will only show rows where that column meets the parameters chosen, though it will include data from other columns that is not within those parameters.
ADVERTISEMENT
How to filter data in Excel across a whole sheet
1. Select the whole sheet by pressing "CTRL" + "A" on your PC or "command" + "A" on your Mac keyboard.
2. Click on "Data" in the top toolbar.
3. Click on "Filter" in the top toolbar. This will show an arrow at the top of every column.
4. Click on the arrow at the top of one of the columns. This will show the "Filters" pop-up.
ADVERTISEMENT
How to filter in Excel
Ryan Ariano/Business Insider
5. Click on "Number Filters," which pulls up a more detailed pop-up.
6. Click on the setting you wish to filter by. In this example, the sheet will be filtered by data greater than 5000.
This will filter data in the whole sheet, meaning it will only include rows where every bit of data meets the parameters.
How to sort filtered data in Excel
ADVERTISEMENT
This allows you to put your sheet in rising or ascending order based on one column's values.
1. Select the whole sheet by pressing "CTRL" + "A" on your PC or "command" + "A" on your Mac keyboard.
2. Click on "Data" in the top toolbar.
3. Click on "Filter." You will see an arrow at the top of each column.
4. Click on one of those arrows to pull up the "Filter" pop-up. Either click on "Sort Smallest to Largest" or "Sort Largest to Smallest."
ADVERTISEMENT
How to filter in Excel
Ryan Ariano/Business Insider
Either will reorder the whole sheet based on the order of the column you've selected.
How to unfilter a column in Excel
You can unfilter data that has been sorted in either a column, multiple columns, or the whole sheet, but the process is a little different for each.
Note that this cannot be used to reorder data that has been sorted into ascending or descending order.
ADVERTISEMENT
Here's how to unfilter a column of data:
1. Click on the column that you want to unfilter. Click the down arrow next to the column's heading. This will bring up the "Filters" pop-up.
2. Click on "Clear filter from [column name]".
3. This will clear the filter and show all data.
How to filter in Excel
Ryan Ariano/Business Insider
ADVERTISEMENT
Read more coverage from How To Do Everything: Tech :
- How to search for terms or values in an Excel spreadsheet, and use Find and Replace
- How to sum values in Microsoft Excel in 2 different ways, to add multiple numbers or cells together
- How to divide numbers and cells in Microsoft Excel to make calculations and analyze data
- How to freeze a row in Excel so it remains visible when you scroll, to better compare data on different parts of a spreadsheet
See Also:
ADVERTISEMENT
SEE ALSO: The best all-in-one PCs you can buy
JOIN OUR PULSE COMMUNITY!
ADVERTISEMENT
Eyewitness? Submit your stories now via social or:
Email: eyewitness@pulse.ng
ADVERTISEMENT