BradleyS
Active Member
- Joined
- Oct 28, 2006
- Messages
- 333
- Office Version
- 2010
- Platform
- Windows
I have a spreadsheet of data that has a few hidden columns.
However, if I copy and paste or even paste special it still copies the hidden columns and exposes them so they now show.
When I use an AutoFilter and copy data it never copies the hidden rows, which is great.
So is there a method I could use in the same way for my hidden columns, so that it only pastes what shows?
However, if I copy and paste or even paste special it still copies the hidden columns and exposes them so they now show.
When I use an AutoFilter and copy data it never copies the hidden rows, which is great.
So is there a method I could use in the same way for my hidden columns, so that it only pastes what shows?