cmonthetic
IS-IT--Management
Hi,
The spreadsheet I am working with has a large number of empty rows.
As the sheet is sent to me and it is made up of several other imported spreadsheets so I never know how many blank rows I am going to have.
I know that the cells in column A only every contain a serial number and are blank otherwise.
Is there a quick way of selecting the blank cells from column A and then deleting all of the blank rows.
TIA
The spreadsheet I am working with has a large number of empty rows.
As the sheet is sent to me and it is made up of several other imported spreadsheets so I never know how many blank rows I am going to have.
I know that the cells in column A only every contain a serial number and are blank otherwise.
Is there a quick way of selecting the blank cells from column A and then deleting all of the blank rows.
TIA