| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete rows with empty cells in columns B&C
Hi,
I have a huge spreadsheet that needs to have all rows with empty cells in both columns B and C deleted. I was going through it line by line, but there has got to be a better way. My knowledge of Excel and all of its features is very limited. Any help would be appreciated. Thank You, Richard |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete rows with empty cells in columns B&C
This is one of the standard features of ASAP Utilities, available at
www.asap-utilities.com Vaya con Dios, Chuck, CABGx3 "Richard" wrote: Hi, I have a huge spreadsheet that needs to have all rows with empty cells in both columns B and C deleted. I was going through it line by line, but there has got to be a better way. My knowledge of Excel and all of its features is very limited. Any help would be appreciated. Thank You, Richard |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete rows with empty cells in columns B&C
Do I have to pay for these utilities?
"CLR" wrote: This is one of the standard features of ASAP Utilities, available at www.asap-utilities.com Vaya con Dios, Chuck, CABGx3 "Richard" wrote: Hi, I have a huge spreadsheet that needs to have all rows with empty cells in both columns B and C deleted. I was going through it line by line, but there has got to be a better way. My knowledge of Excel and all of its features is very limited. Any help would be appreciated. Thank You, Richard |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete rows with empty cells in columns B&C
No, ASAP Utilities are free, sorry I forgot to mention that fact in my
post..... Vaya con Dios, Chuck, CABGx3 "Richard" wrote in message ... Do I have to pay for these utilities? "CLR" wrote: This is one of the standard features of ASAP Utilities, available at www.asap-utilities.com Vaya con Dios, Chuck, CABGx3 "Richard" wrote: Hi, I have a huge spreadsheet that needs to have all rows with empty cells in both columns B and C deleted. I was going through it line by line, but there has got to be a better way. My knowledge of Excel and all of its features is very limited. Any help would be appreciated. Thank You, Richard |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to swap rows and columns? | Excel Discussion (Misc queries) | |||
| delete empty rows between rows with text | Excel Discussion (Misc queries) | |||
| How to delete extraneous rows and columns | Excel Discussion (Misc queries) | |||
| extract data from a range of cells in rows or columns when a date. | Excel Worksheet Functions | |||
| Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
Linear Mode
