98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Filters
Filters
Resolved · Low Priority · Version 2000
RE: Filters
Hi Kelly, thank you for the post, welcome to the forum, I hope you enjoyed your course; in answer to your question, using the filter command in Excel is quite an indepth operation with lots of different areas;
Excel enables you to filter the rows that appear in your spreadsheet. For an example lets consider a stock worksheet that produces data from several dozen companies, you can filter to view one or more companies at a time, or you can filter by more than one column at a time. For example, you can apply a filter to find the companies with great growth rates, then filter for companies with strength (low debt, good inventory turnover ratios, etc). Filtering rows is faster and more flexible than changing criteria in a stock screen, so it's a great way to see which companies keep showing up as you look for particular characteristics.
Follow these steps to define and refine filters:
1. Select a cell on the spreadsheet
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Change the Default Width of All Columns in Excel 2010If you want to change the width of the columns in your Excel 2010 spreadsheet, making them either larger or smaller, here's how: |