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

Cell data entering slow! 0
Need Help with a VBA subroutine 0
i am unable to copy & paste filtered data to another sheet. 1
Using filters for a scheduling worksheet 0
Using Auto filtered Data 0
Refreshing some Pivots Tables makes Excel stop or crash 0
Refreshing some Pivot Tables makes Excel stop or crash 0
Need help deleting data 2

Top