Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete empty rows
In Excel 2007, how can I delete rows in which all cells are empty?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
|
|||
|
|||
To delete rows, select complete rows to be deleted. Now press "ctrl" and "-". The whole rows will be deleted.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hpw do I delete multiple empty rows found between filled rows? | Excel Worksheet Functions | |||
How to Delete empty rows in excel in b/w rows with values | Excel Worksheet Functions | |||
Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
Delete Rows with Empty Cells with empty column 1 | Excel Programming | |||
Delete Empty Rows | Excel Programming |