My spreadsheet has 2 columns of data. Column A contains part numbers and column B contains serial numbers. I frequently delete part numbers (and serial numbers) due to part discontinuations, etc which leaves many blank rows within my spreadsheet. Removing these rows individually can get time consuming (I sometimes have 40 or 50 rows of data sparatically located throughout my spreadsheet).
How can i remove the blank rows all at once?
Thx,
Noir
How can i remove the blank rows all at once?
Thx,
Noir