You'll want to add this quick selection trick to your repertoire. It's handy when the range isn't a complete data range or it comprises more than one data range. You probably know about the [F5] key – ...
Filters organize and prepare data for Excel reports and visualizations by selecting only relevant data for display. If you are working with a filter in an Excel worksheet, you can extend the range of ...