Excel 2007 spreadsheet - blank rows

P

pc4n6

I imported telephone records (text file) into excel and when it was brought
over, every other row is empty/blank. How do I delete every other row of
this spreadsheet? Want to thank you all in advance...this is such a great
resource and I appreciate all the help and quick responses.

Thank you!
 
G

Gary''s Student

Pick a typical column, say column A. Switch on AutoFilter and select blanks.
Then delete the visible rows.
 
T

tom

Hello can you help me figure out how or what the sign is for subtract in
formatting a column that has ex. a4:a10 and then i want to subtract e4???

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Using Office Forms and dynamically updating the excel backend 0
Having Blank Cells, etc. ? 1
Deleting Blank Rows. 3
Delete extra empty rows 2
Deleting/removing unused rows in a worksheet 3
a function that deletes all rows with no value in a certain column? 2
if cell is blank 8

Top