98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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
Resolved · Urgent Priority · Version 2007
James has attended:
Excel Intermediate course
Outlook Advanced course
Access Advanced course
Excel Advanced course
Outlook Advanced course
Project Introduction course
Project Intermediate course
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
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Quickly copy a formula across sheetsSuppose 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. |