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 » Views
Views
Resolved · Low Priority · Version 2003
Wed 19 Nov 2008, 16:28Delegate Craig said...
Craig has attended:
Excel Advanced course
Views
If using filters, will creating views mean that the filters that were applied when the view was created will be applied subsequently when that vew is selected?
Mon 24 Nov 2008, 12:18Trainer Simon said...
RE: Views
Hi Craig,
Thank you for your question. Yes, when the view is applied it will re-do the filter for you.
If you have used Autofilter on columns of data and have found 10 results, then you create a view and name it, every time you apply that view, it will autofilter the same criteria and show the same results.
I hope this answers your question.
Regards
Simon
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:Autonumber in ExcelTo create an autonumber field, can use the Offset() function. |
