Tuesday, July 2, 2019

Use This Method to Reproduce your Excel Data for Sorting and more


In the last post "How to get rid of Blank Rows Using COUNTA", I shared how to compact your data for a comprehensive report.

This is a follow up tutorial to the last post.

This time, capture the data with "Last Cell"(check last post} + holding down the SHIFT KEY to highlight the content in the worksheet.
Note, keep your active cell on your starting point. 

A1 is the starting point here.


Depending on the visible and invisible format or text in the worksheet, your LAST CELL might be different. Mine is set to Range A1:G26

With the range highlighted, press CTRL+SHIFT+L to insert the FILTER BUTTONS.
Note, you can use the CUSTOM SORT as you wish


Now get rid of the blank rows, irrespective of how your data might look like.
The work is done!


No comments:

Post a Comment