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

excel copypaste filters

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

Excel 2007 copy-paste with filters applied

ResolvedVersion 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

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

 

Training courses

98.7 % recommend us

Training information:

See also:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

See also:
Hints and tips
Forum topics

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

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

Excel tip:

Change the default location for opening and saving spreadsheets

If you are always opening spreadsheets from and/or saving documents to a specific location that is not My Documents, save time by setting this folder as the default for opening files from and saving files to.

Here's how:
1. Go to Tools - Options.

2. Select the General tab.

3. Enter the pathname of the folder you wish to make the default in the Default File Location box (hint: it will be easier to use Windows Explorer to navigate to this folder, then copy and paste the pathname from the address bar at the top of the Windows Explorer screen).

4. Click OK.

You have now changed the default folder for opening and saving spreadsheets.

View all Excel hints and tips

TrustPilot
TrustScore 4.9 / 5       2394 reviews

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

STL training logo

Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Verified by Visa
Security verified
Microsoft Partner
Terms & Conditions Privacy & Cookie Policy Consent preferences
Server loaded in 0.1 secs.