delete the rows in the filter mode

**manieswar** · 03-16-2010, 06:33 AM

Hi,

by using the ctrl+ '-' we can only delete one row.

we have lot of data to be deleted at once in filter mode.
Is it possible to delete all at once.

Thanks,
Mani.

**teylyn** · 03-16-2010, 07:26 AM

Select the rows by clicking the row numbers. Drag the selection down. Hit F5 - Special - Visible Cells only. Right-click and select "Delete" from the context menu.

**manieswar** · 03-16-2010, 07:53 AM

iam new to excel. Do you mean context menu in the sense the dropdown menu when we right click mouse.

i tried this and its not showing me the result.

Thank you very much for your quick response....

**teylyn** · 03-16-2010, 08:03 AM

Yes, the context menu is the menu that opens when you right-click.

If you have any cells, rows, or columns selected, the context menu will contain the Delete command.

**manieswar** · 03-16-2010, 08:43 AM

Thanks lot.

Yah! its working fine. but it takes long time to delete the 10 selected records.
We have more than 4000 records. can we delete this at once? is there any other process to delete the data containing '-' sign in sales column.

Help me plz....
Thanks,
Mani.

**martindwilson** · 03-16-2010, 05:14 PM

it takes a long time? that sounds a bit odd.
to save time put the select visible cells button on the tool bar see attached
right click any tool bar and customise