Tue 4 Dec 2007, 11:52
Edited on Tue 4 Dec 2007, 11:56Trainer Sandy said...
Quick way to refresh my database list when using AutoFilters
Is there a quick way to refresh my database list when using Filters? When I turn on Autofilter to filter data in several columns, I always get in a muddle trying to show all of the data in the database once I have finished. Is there a quick way?
Tue 4 Dec 2007, 11:55
Edited on Tue 4 Dec 2007, 11:57Trainer Sandy said...
RE: Quick way to refresh my database list when using AutoFilters
Yes to show all of the data in your database once you have used the Autofilter, you just need to go to the Data menu, choose Show All and all your data that was hidden will now display on your worksheet.
To find out more about AutoFilters please see our syllabus for our Excel Intermediate course on our website.
