Forum home » Delegate support and help forum » Microsoft Excel Training and help » Use of filters
|
|
|
The UK's most regular 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. |
Use of filters
Resolved · Medium Priority · Version 2003
Reply Thu 25 Mar 2010, 16:37Delegate Helen said...
Helen has attended:
No courses
Use of filters
I have a list of data with amounts of money for each row. There is an autosum Total at the bottom of the amounts column. There is more data several rows below the Total cell. I use filtering in this way quite regularly to get a sub-total on different items within the list. On this occasion the filter is filtering out the Total row at the bottom so it doesn't show and also some of the data below it.
For upcoming training course dates see: Pricing & availability
RE: Use of filters
Hi Helen
Thanks for your question. Try removing the filter and then before you turn filters back on first highlight the headings and rows you would like the filter to apply to. This should enable you to set Excel to ignore total row.
Let me know how you get on or if you have any further questions.
Kind regards,
Andrew
Sun 4 Apr 2010: Automatically marked as resolved.
|