Hello to all,
This is actually a question from a colleague which I found intriguing. He wants to select certain cells with Ctrl + Click and then delete all the data except for those selected cells, something like inverse selection followed by a deletion.
Is there any way you can do that without resorting to VBA;
Αlso I am not sure but I think there was an Inverse Select option in the Edit Menu of Excel 2003. Is there a relevant option in Excel 2007 or has Microsoft once again taken a useful feature out?
Thanks in advance for the help!
This is actually a question from a colleague which I found intriguing. He wants to select certain cells with Ctrl + Click and then delete all the data except for those selected cells, something like inverse selection followed by a deletion.
Is there any way you can do that without resorting to VBA;
Αlso I am not sure but I think there was an Inverse Select option in the Edit Menu of Excel 2003. Is there a relevant option in Excel 2007 or has Microsoft once again taken a useful feature out?
Thanks in advance for the help!
