ExcelBanter - Delete empty rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Delete empty rows (https://www.excelbanter.com/excel-discussion-misc-queries/398132-delete-empty-rows.html)

gwc

Delete empty rows

In Excel 2007, how can I delete rows in which all cells are empty?

Jim Cone[_2_]

Delete empty rows

Sort the data - blank cells sort to the bottom.
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware

"gwc"
wrote in message
...
In Excel 2007, how can I delete rows in which all cells are empty?

Exceldummies

Quote:

Originally Posted by gwc (Post 1410298)

In Excel 2007, how can I delete rows in which all cells are empty?

To delete rows, select complete rows to be deleted. Now press "ctrl" and "-". The whole rows will be deleted.

All times are GMT +1. The time now is 08:14 PM.