excel copypaste filters

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2007 copy-paste with filters applied | Excel forum

Excel 2007 copy-paste with filters applied | Excel forum

resolvedResolved · Urgent Priority · Version 2007

Excel 2007 copy-paste with filters applied

Excel 2007 pastes into cells not visable due to filters where 2003 did not. I have searched the net for solution and it seems to be that this depends on how filters are applied in the first place. Can you explain how 2007 differs from 2003 regarding copy-paste with filters applied?

Thanks

RE: excel 2007 copy-paste with filters applied

By the way...I use PASTE SPECIAL then click VALUES because I take data from various spreadsheets with various formats and need this pasted data to comply with my format. I notice the above problem does not happen if I simply use PASTE - only when I use PASTE SPECIAL and VALUES.

Thanks

RE: excel 2007 copy-paste with filters applied

By the way...I use PASTE SPECIAL then click VALUES because I take data from various spreadsheets with various formats and need this pasted data to comply with my format. I notice the above problem does not happen if I simply use PASTE - only when I use PASTE SPECIAL and VALUES.

Thanks

Edited on Tue 30 Sep 2008, 08:58

RE: excel 2007 copy-paste with filters applied

Hi James

Thanks for the post, not a nice one to find.

I have no idea why the change in behaviour but I think I have a work around for you.

Apply the filters
Copy your data
Highlight the area to paste into
Press F5 or Ctrl+G to brng up the Goto box
Press Special in the bottom left
Choose "Visible Cells Only" and press OK
Then do your paste special.

I hope that works for you


Laura GB


 

Excel tip:

Quickly copy a formula across sheets

Suppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets.

Remember to ungroup the sheets afterwards! Right-click on any tab and choose Ungroup Sheets to do that.

View all Excel hints and tips


Server loaded in 0.09 secs.