Copy Filter Results in Excel 2003

If you have filtered your data in Excel 2003 before, I am sure you have also tried copy and pasting the filtered results to another worksheet or workbook.

By default, Excel 2003 will copy all the data including the hidden records. Fortunately there is a feature for us to select only visible cells.

Let’s look at copying the filtered data shown below.

Filtered results in Excel 2003
Filtered results in Excel 2003

Copy Visible Cells Only

1. Select the cells that you want to copy

2. Click Edit > Go To or press Ctrl + G or press F5

3. Click the Special button at the bottom of the Go To dialogue box

4. Select Visible Cells Only

Select Visible Cells Only
Select Visible Cells Only

5. Click Ok

6. Click Edit > Copy or press Ctrl + C

Excel only copies the visible records, which can now be pasted into another worksheet, workbook or another application altogether.

Add the Select Visible Cells Button

To speed up this process the Select Visible Cells button can be added to a toolbar. Selecting visible cells will then just be at the click of a button.

1. Click Tools > Customize

2. Click the Commands tab

3. Select Edit in the Categories: list

4. Scroll down the Commands: list until you find Select Visible Cells

Adding the Select Visible Cells button to the toolbar
Adding the Select Visible Cells button to the toolbar

5. Click and drag the button onto a toolbar and position it where you want

The picture below shows the Select Visible Cells button positioned between the Sort Descending and Chart Wizard buttons on the Standard Toolbar.

Button added to the toolbar
Button added to the toolbar

To speed the process up even greater, record a macro in Excel that selects visible cells and copies themin one step.

In Excel 2007 and 2010, copy and paste will paste the filtered results so the steps mentioned above are unnecessary.

Useful Resources

Software training videos

Online training videos for Excel, Word, PowerPoint, Photoshop, Dreamweaver, Flash, JavaScript and much much more..

Microsoft Excel training

Online Microsoft Excel training guides and quizzes. Improve your existing skills and learn new Excel tips.

More by this Author

  • Sort Pictures in an Excel List
    0

    If you are using pictures in your Excel spreadsheet you may be having some difficulty with sorting the pictures along with the other data in the list. The good news is that you can sort pictures in an Excel list just...

  • Create an Interactive Excel Chart using Option Buttons
    6

    Form controls can be added to an Excel spreadsheet to create interactivity with the user. This article looks at using option button controls to allow a user to choose the data they want to see on a chart. The first...

  • Impaction in Bearded Dragons
    10

    Impaction is when a bearded dragon’s digestive tract has become blocked. It is a very real hazard that is brought about when the beardie has either swallowed something that is too large, or something that it...


No comments yet.

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working