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:
![](https://static.wixstatic.com/media/af7fa4_77e953ff60c5471b9db16ecce81dd03d~mv2.png/v1/fill/w_65,h_66,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_auto/af7fa4_77e953ff60c5471b9db16ecce81dd03d~mv2.png)
. . . then simply press ALT + ;
![](https://static.wixstatic.com/media/af7fa4_06c8e32d0b9a4e419bbe6e07b9d9bef5~mv2.png/v1/fill/w_65,h_66,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_auto/af7fa4_06c8e32d0b9a4e419bbe6e07b9d9bef5~mv2.png)
. . . and only the individual filtered rows will be selected.