excel

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

Excel

resolvedResolved · Medium Priority · Version 2003

James has attended:
Excel Intermediate course
Excel Advanced course
Access Introduction course

Excel

How do you copy filetered results onto another worksheet?

RE: Excel

Hi James,

Have you tried pasting values only?

Copy the filtered results you want to copy.

Go to the new worksheet.

Right click where you want to paste and choose Paste Special.
Under the 'paste' section choose 'values'.

Let me know how you get on, or if this doesn't answer your question.

Regards, Rich


 

Excel tip:

Finding cells that have data restrictions

Click anywhere on the worksheet.
On the Edit menu, click Go To.
Click Special.
Click Data validation.
Click All.

View all Excel hints and tips


Server loaded in 0.08 secs.