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

  • 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...

  • 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...

  • Brock Lesnar Nutrition and Workouts
    2

    Brock Lesnar is a phenomenon of a man and an athlete. Brock Lesnar weighs a lean 265 lbs and yet possesses extreme speed, agility and athleticism. How a man carrying so much muscle mass can maintain such high levels of...


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