From the course: Excel VBA: Managing Files and Data
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Restore a range or worksheet to an unfiltered state - Microsoft Excel Tutorial
From the course: Excel VBA: Managing Files and Data
Restore a range or worksheet to an unfiltered state
- [Instructor] Filtering an Excel worksheet lets you focus on the data that you need to make a specific decision. When you're done, you can remove the filter and have access to all of your data. In this movie, I will show you two techniques to remove filters. The first will be to remove a filter from a particular field. And the second is to remove all filters from an entire worksheet. My sample file is oh one oh six, remove filters. And you can find it in the chapter one folder of your exercise files collection. This workbook contains a single worksheet and you can see that I have two filters applied. One for a year and one for state. I'm going to switch over to the visual basic editor and show you how to remove filters from one of those fields. So I'll press alt F11. And here, in the visual basic editor, I have a code module with two sub-routines. The first one is called remove filter. And this just removes a…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.