| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatically deleting blank rows?
Hello:
I exported data from Crystal Reports to Excel. I have a huge spreadsheet, and a lot of blank rows in between records of data. Is there a way to "tell" Excel to get rid of any and all blank rows, rather than having to manually go through the tens of thousands of rows of the spreadsheet to find and delete rows? childofthe1980s |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
automatically deleting blank rows?
You can do it manually but still pretty fast, select the range, then press
F5, click special and select blanks, do editdelete and select entire row -- Regards, Peo Sjoblom "childofthe1980s" wrote in message ... Hello: I exported data from Crystal Reports to Excel. I have a huge spreadsheet, and a lot of blank rows in between records of data. Is there a way to "tell" Excel to get rid of any and all blank rows, rather than having to manually go through the tens of thousands of rows of the spreadsheet to find and delete rows? childofthe1980s |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
automatically deleting blank rows?
Thanks, Peo!!!
childofthe1980s "Peo Sjoblom" wrote: You can do it manually but still pretty fast, select the range, then press F5, click special and select blanks, do editdelete and select entire row -- Regards, Peo Sjoblom "childofthe1980s" wrote in message ... Hello: I exported data from Crystal Reports to Excel. I have a huge spreadsheet, and a lot of blank rows in between records of data. Is there a way to "tell" Excel to get rid of any and all blank rows, rather than having to manually go through the tens of thousands of rows of the spreadsheet to find and delete rows? childofthe1980s |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
automatically deleting blank rows?
But wouldn't that also delete any rows in which *any* cells were blank?
Didn't the OP want to delete just the blank rows? -- David Biddulph "Peo Sjoblom" wrote in message ... You can do it manually but still pretty fast, select the range, then press F5, click special and select blanks, do editdelete and select entire row -- Regards, Peo Sjoblom "childofthe1980s" wrote in message ... Hello: I exported data from Crystal Reports to Excel. I have a huge spreadsheet, and a lot of blank rows in between records of data. Is there a way to "tell" Excel to get rid of any and all blank rows, rather than having to manually go through the tens of thousands of rows of the spreadsheet to find and delete rows? childofthe1980s |
| 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 | |||
Linear Mode
