Forum home » Delegate support and help forum » Microsoft Excel Training and help » Views

Views

ResolvedVersion 2003

Wed 19 Nov 2008, 16:28 Delegate 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:18 Trainer 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 courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Recently used file list

Under the File menu, you may find a list of files at the bottom of the menu. These files represent the most recently used Excel spreadsheets. This file list provides a quick way for you to access your files.

You can disable the file list feature of Excel. This is done by

1. Choose Tools > Options menu. You will see the Options dialog box.
2. Ensure the General tab is selected.
3. Make sure the Recently Used File List check box is cleared.
4. Click on OK.

View all Excel hints and tips

Views

Views

RE: Views

Excel articles

Excel tip:

Recently used file list