Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Data from a Database
In Excel 2002, there is no longer a Delete command in the Data menu. How can
I specify criteria in one or more columns and delete rows containing data that matches the criteria, without writing a macro. I suspect that filtering is the answer but I can't find any help on deleting. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Data from a Database
Hi,
There was no Delete command on the Data menu in 2000? To delete items you work backwards: 1. Use either Filter or AutoFilter to display the items you want to delete 2. Select the all the results without the titles and press Del. 3. Remove the filter 4. To remove all the blank rows you can sort or use the goto special blanks command followed by del. If this helps, please click the Yes button cheers, Shane Devenshire "Joe K" wrote in message ... In Excel 2002, there is no longer a Delete command in the Data menu. How can I specify criteria in one or more columns and delete rows containing data that matches the criteria, without writing a macro. I suspect that filtering is the answer but I can't find any help on deleting. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tool bar: Data/Import external data/New database query | Setting up and Configuration of Excel | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
Using Sum for database data | Excel Discussion (Misc queries) | |||
how do i delete multiple records from my database | Excel Discussion (Misc queries) | |||
Delete a Table not in Current Database | Excel Discussion (Misc queries) |