Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Excel 2007 copy-paste with filters applied

Resolved · Urgent Priority · Version 2007

Reply Tue 30 Sep 2008, 08:20Delegate James said...

James has attended:
Excel Intermediate course
Outlook Advanced course
Access Advanced course
Excel Advanced course
Outlook Advanced 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

For upcoming training course dates see: Pricing & availability

Reply Tue 30 Sep 2008, 08:44Delegate James said...

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

Reply Tue 30 Sep 2008, 08:45Delegate James said...

RE: excel 2007 copy-paste with filters applied

Reply Tue 30 Sep 2008, 08:57 Edited on Tue 30 Sep 2008, 08:58Trainer Laura said...

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 articles

· Excel: Save Time With AutoFill
· Microsoft Excel's Best Kept Secret
· Identifying Suitable Candidates For VBA For Excel Training
· Excel 2010 Can Make Your Reports Better And More Detailed Than Ever
· Microsoft Excel 2007

Please browse our web site to find out more about
microsoft excel courses in and other Microsoft training courses.

Excel tip:

DATEDIF function

The DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002.
the formula function is:
=DATEDIF(Your age,Today(),"Y")
Y stands for year

View all Excel hints and tips