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 » microsoft excel training day courses near kent - Quick way to refresh my database list when using AutoFilters
microsoft excel training day courses near kent - Quick way to refresh my database list when using AutoFilters
Resolved · Low Priority · Version Standard
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.
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:Keyboard Shortcuts to Add Rows or ColumnsCouple of other keyboard shortcuts. Shift+spacebar selects a row, Ctrl+spacebar selects a column. Select either row or column (or several) and use Ctrl and + to insert or Ctrl and - to delete rows or columns. |
