0:59 a word of advice: this way of applying filter is only good when you have 100% guaranteed correct data set. If your data set contains fully empty rows - it will set the filter to partial set, not to mention if the data set is copied form other file (txt, CSV etc) thiis method can caose excel to select more rows / columns then the set actually has. So best way is to go to the Top Left cell of your data set and with CTRL+Shift+Arrows select the correct set size and then use CTRL+Shift+L to apply filters. Note this is on English - en-US language settings. Iff you change excel language your shortcuts may vary, just press alt and follow the letters on the ribbon in such case.
Great! anew trick I did not know about! Please keep posting more excel videos!
Glad you found it useful Steven, I will definitely keep posting some more interesting Excel videos.
0:59 a word of advice: this way of applying filter is only good when you have 100% guaranteed correct data set.
If your data set contains fully empty rows - it will set the filter to partial set, not to mention if the data set is copied form other file (txt, CSV etc) thiis method can caose excel to select more rows / columns then the set actually has.
So best way is to go to the Top Left cell of your data set and with CTRL+Shift+Arrows select the correct set size and then use CTRL+Shift+L to apply filters.
Note this is on English - en-US language settings.
Iff you change excel language your shortcuts may vary, just press alt and follow the letters on the ribbon in such case.