How can I remove multiple (hundreds) of blank rows in one step?
I have a large spreadsheet that I inherited at work. It has hundreds of
blanks rows between data I would like to sort. Is there an easier way to
remove empty rows and columns other than to just click and delete? Is there
a way to get Excel to select all blank rows or columns so then I could delete
them?
|