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.