Copy & paste filtered columns [Closed]

Question

Copy & paste filtered columns [Closed]

Report

Gaz - Dec 22, 2009 at 05:51 PM
Sid - May 3, 2010 at 12:08 PM

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

Copy & paste filtered columns
Copy and Paste certain columns based on dates ✓ - Forum - Excel
Macro to blank out filtered columns ✓ - Forum - Excel
Excel vba filter column based on cell value ✓ - Forum - Excel
Copy and paste to next available column - Forum - Excel
Excel vba copy paste values next empty column - Forum - Excel

1 reply

Ask a question

Sid · Answer 1 · 2010-05-03T12:08:58-0400

Answer 1 / 1

Sid
May 3, 2010 at 12:08 PM

drag the + sign at the below right, it worked for me

Copy & paste filtered columns [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!