cornflakegirl
Well-known Member
- Joined
- Nov 4, 2004
- Messages
- 2,023
This feels like it should be a really straightforward question, but I haven't found an answer when searching.
One of my colleagues has a spreadsheet. It has hidden columns (to match Group format), and uses Autofilter. Today, with the Autofilter active, she tried to copy a row and paste it elsewhere - and got an error message that the command can't be used with multiple selections.
It seems to be something to do with Excel only copying the visible cells. With just hidden columns, or just Autofilter, everything is fine. But not with both.
The obvious workaround is to not have active filters when copying - which is okay, but not ideal. The other thought I had was to make the hidden columns really thin instead of hidden - again, not ideal.
Any better ideas?
One of my colleagues has a spreadsheet. It has hidden columns (to match Group format), and uses Autofilter. Today, with the Autofilter active, she tried to copy a row and paste it elsewhere - and got an error message that the command can't be used with multiple selections.
It seems to be something to do with Excel only copying the visible cells. With just hidden columns, or just Autofilter, everything is fine. But not with both.
The obvious workaround is to not have active filters when copying - which is okay, but not ideal. The other thought I had was to make the hidden columns really thin instead of hidden - again, not ideal.
Any better ideas?