Excel 2007 spreadsheet - blank rows

  • Thread starter Thread starter pc4n6
  • Start date Start date
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!
 
Pick a typical column, say column A. Switch on AutoFilter and select blanks.
Then delete the visible rows.
 
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

Deleting blank rows 4
Deleting/removing unused rows in a worksheet 3
Having Blank Cells, etc. ? 1
automatically deleting blank rows? 3
Deleting Blank Rows. 3
Delete Empty Rows 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Delete multiple rows where a blank cell is located 2

Back
Top