Inside Microsoft Excel

Filter data by font or fill color (2007/2010/2013)

Inside Microsoft Excel

by Kara Hiltz

Most of the time, you filter data based on the cells’ values. You might want to see only the data that pertain to a particular company. Or you may want to see only records in which the Profit column exceeds 1,000. Whatever the case, filtering by cell value is by far the most common filtering method.

Excel has expanded users’ filtering capabilities. Now the colors that you add to your spreadsheet can lend[…]


Subscribe to Inside Microsoft Excel

(get full access to archives and more)