| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Blank Rows.
I have a spreadsheet which has one row with data and one row blank, it's
about 1000 rows down, is there any way I can delete the blank rows. If I apply autofilter it won't catch the other rows after the first one, is there any way to delete all the blank rows??? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deleting Blank Rows.
f5gotospecial blanksthen delete
-- Don Guillett Microsoft MVP Excel SalesAid Software "GEM" wrote in message ... I have a spreadsheet which has one row with data and one row blank, it's about 1000 rows down, is there any way I can delete the blank rows. If I apply autofilter it won't catch the other rows after the first one, is there any way to delete all the blank rows??? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deleting Blank Rows.
Great thanks!!!!
"Don Guillett" wrote: f5gotospecial blanksthen delete -- Don Guillett Microsoft MVP Excel SalesAid Software "GEM" wrote in message ... I have a spreadsheet which has one row with data and one row blank, it's about 1000 rows down, is there any way I can delete the blank rows. If I apply autofilter it won't catch the other rows after the first one, is there any way to delete all the blank rows??? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deleting Blank Rows.
try this
Select a column then F5SpecialBlanksOK EditDeleteEntire Row -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "GEM" wrote: I have a spreadsheet which has one row with data and one row blank, it's about 1000 rows down, is there any way I can delete the blank rows. If I apply autofilter it won't catch the other rows after the first one, is there any way to delete all the blank rows??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting multiple blank rows | Excel Worksheet Functions | |||
| deleting the blank rows from the sheet | Excel Worksheet Functions | |||
| Deleting blank rows | Excel Worksheet Functions | |||
| Deleting Blank Rows | New Users to Excel | |||
| Deleting rows with blank cells | Excel Worksheet Functions | |||
Hybrid Mode
