98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training - Filtering
excel training - Filtering
Resolved · Low Priority · Version Standard
Fri 27 Jul 2007, 09:54Delegate Lauren said...
Lauren has attended:
Excel Intermediate course
Excel Introduction course
Filtering
How do i filter a table?
Sat 28 Jul 2007, 06:59Trainer Tracy said...
RE: Filtering
Hi Lauren,
Thank you for your question.
You can filter a table by clicking within the table and using the AutoFilter menu. This can be found under Data > Filter > AutoFilter. This is where you get the drop down options to pick from a selection. There are other filters as well, but this is the easiest and quickest one to use. Have a go see if it works and if you get stuck just get back to me!
Tracy
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:Reconciling a list to correspond with anotherMay have a list that needs to make but on another sheet one list seems to be out, eg. product list one sheet contains all product and inventory data, while the other contains pricing data. Both need to match with all products but there is more products in one list than the other. To find the disparaging product compare data in the two columns that need to match Make sure that order the same way. |
