Selecting only odd numbered rows

  • Thread starter Thread starter Alan T
  • Start date Start date
A

Alan T

I have a spreadsheet with data on all the even numbered rows. All th
odd numbered rows are blank. The data is imported into the spreadshee
from a text file.

How can I select and delete all the odd numbered rows which have n
data in them? (Manually doing this is not an option as there are 15
different spreadsheets with approximately 2500 rows of data on each
 
Can you do a sort or autofilter on the data ?
That way all rows with data should be in the top half.

Regards
Bill K
 
Alan,

Select a column, goto Data>Filter>Autofilter and then click the dropdown
arrow at the head of the column, click and you are presented with a filter
on your data. Go to the bottom of the list and select (Blanks) This will
then hide all of you data rows, and the blank rows between will show up with
a blue row number. Select the entire rows for those embedded blank rows and
just goto Edit>Delete Row. Then go to Data>Filter>Autofilter again to remove
the filter, and your data rows re-appear, no blanks.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Here's another way:

Select a single column containing all the rows that your
data's in (or just select the entire column)
Goto (F5)
Click Special...
Select Blanks
Right click on a selected (blank) cell
Select Delete...
In the Delete dialog box select Entire row
 
Back
Top