How to Delete empty rows in Excel?

Was this post useful to you?

I have some empty rows between data in an Excel spreadsheet, how can I delete them?

Spanner's picture
Spanner
Mon, 09/24/2012 - 14:20

1 Answers for "How to Delete empty rows in Excel?"

click data on main window menu use filter options in that select blanks then select rows and right click choose delete ...its done

Post your reply

Filtered HTML

  • Allowed HTML tags: <b> <br> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.