tried deleting filtered data - but all data gets deleted
3 views
Skip to first unread message
user@discussions.microsoft.com New user
unread,
Dec 17, 2009, 7:07:01 PM12/17/09
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
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.
Eduardo
unread,
Dec 18, 2009, 9:34:01 AM12/18/09
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
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