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.

Contact Me With Your Litigation Support Questions:

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with