Selecting Filtered Rows in Excel
- Sean O'Shea
- Jul 24, 2017
- 1 min read
When working in Excel, after filtering on columns for only certain entries on a worksheet, you may need to select just the filtered rows in order to enable a macro to function properly. In order to do this, first highlight the filtered data:

. . . then simply press ALT + ;

. . . and only the individual filtered rows will be selected.