Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatically select empty rows
Is there a way to have excel select empty rows? I imported data and each
record is seperated by an empty row. Considering there are 1000+ rows of data it would be quicker to have excel select the empty rows so I could remove them. Thank you |
#2
|
|||
|
|||
Automatically select empty rows
Try this, Michael:
Select a column. Hit Edit--Go to--Special--Blanks. Hit Edit--Delete, and choose Entire Row when asked. ************ Anne Troy www.OfficeArticles.com "Michael S." wrote in message ... Is there a way to have excel select empty rows? I imported data and each record is seperated by an empty row. Considering there are 1000+ rows of data it would be quicker to have excel select the empty rows so I could remove them. Thank you |
#3
|
|||
|
|||
Automatically select empty rows
This also works fine...Select any one column, Click on DataAuto Filter. From
trhe drop down list select "Blanks". You now have all the blank rows in front of you. You can now select all and delete them. The hidden rows won't be deleted. "Michael S." wrote: Is there a way to have excel select empty rows? I imported data and each record is seperated by an empty row. Considering there are 1000+ rows of data it would be quicker to have excel select the empty rows so I could remove them. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to select only odd/even numbered rows to be shaded | Excel Discussion (Misc queries) | |||
Select rows and sort based on type | Excel Discussion (Misc queries) | |||
Conversion | Excel Worksheet Functions | |||
Save As CSV saves empty rows | Excel Discussion (Misc queries) | |||
empty rows at bottom of worksheet | Excel Discussion (Misc queries) |