tried deleting filtered data - but all data gets deleted

N

New user

i have 2 issues. (new user to 2007)
1. When I have a filter on and try to delete rows all the rows are being
deleted even the ones not selected in the filter.

2. When I have a filter on and copy data it also copies the data into the
unfilterd areas.
 
E

Eduardo

Hi,
Is the first time I heard when deleting the filter rows you delete
everything and I'm using 2007 version, regarding to copy the filtered data do
this
Select filtered data, press CTRL G, special, visible cells only, then Copy
and paste
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

i am unable to copy & paste filtered data to another sheet. 1
Delete only Filetered rows in excel 2007 not hidden rows or header 0
Copying the filtered data to clipboard is copying non-visible rows 10
Excel Export Filtered Form Data To Excel 0
Filters do not work correctly for table linked to an Access query 1
copying filtered data in Excel 2007 2
Copy visible cells on Filtered data 4
Excel 07 - deleting filtered items 2

Top