Copy & paste filtered columns
Closed
Hello,
Since changinging to windows 07 I can't work out how I can copy & paste in a filtered column without losing the formating of individual cells eg various colours or borders on descending rows. If I drag the cell down i copy the data to filtered cells only, however i lose the format. if i copy and paste special ...values or formula etc, it maintains the formats but copies to unfiltered cells. it seems like I'm snookered either way. Is there a solution to both copy to filtered cells only while maintaining the individual cell format.
Regards
Gaz
Since changinging to windows 07 I can't work out how I can copy & paste in a filtered column without losing the formating of individual cells eg various colours or borders on descending rows. If I drag the cell down i copy the data to filtered cells only, however i lose the format. if i copy and paste special ...values or formula etc, it maintains the formats but copies to unfiltered cells. it seems like I'm snookered either way. Is there a solution to both copy to filtered cells only while maintaining the individual cell format.
Regards
Gaz
Related:
- Copy & paste filtered columns
- Tweetdeck larger columns - Guide
- Display two columns in data validation list but return only one - Guide
- Copy paste e with accent - Guide
- Copy and paste fonts - Guide
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum