Selecting Filtered Rows in Excel
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.