How to Save Filtered Data in Excel (With Example)


Often you may want to save filtered data in Excel.

Fortunately this is easy to do and the following step-by-step example shows how to in practice.

Step 1: Enter the Data

First, let’s create the following dataset in Excel that contains information about various basketball players:

Step 2: Filter the Data

Next, suppose we would like to filter the dataset to only show the rows where the team name is Mavs.

To do so, highlight the cell range A1:C11, then click the Data tab along the top ribbon and then click the Filter button:

Then click the dropdown arrow next to Team, check only the box next to Mavs, then click OK:

The data will automatically be filtered to only show rows where the Team column contains Mavs:

Step 3: Save the Filtered Data

Next, we will saved this filtered data to a new workbook.

To do so, type Ctrl + N to automatically bring up a new workbook.

Then highlight all of the filtered data in the original workbook and then type Ctrl + C to copy the data:

Lastly, click on cell A1 in the new workbook and type Ctrl + V to paste all of the filtered data into the new workbook:

Now save this workbook under any name you’d like to only save this filtered data from the original dataset.

Note: You could also paste the filtered data into a new sheet in the existing workbook if you don’t want to save the filtered data in an entirely new workbook.

Additional Resources

The following tutorials explain how to perform other common operations in Excel:

How to Count Filtered Rows in Excel
How to Sum Filtered Rows in Excel
How to Delete Filtered Rows in Excel

2 Replies to “How to Save Filtered Data in Excel (With Example)”

    1. Hi Sandra…Saving an Excel filter with a custom view can be very useful if you frequently need to analyze or review specific subsets of data without altering the arrangement for others who might access the same workbook. Here’s how you can save a custom view in Excel:

      1. **Apply Your Filters**: First, apply any filters and adjustments you need to your data. This could include sorting, hiding rows or columns, or specific filter settings for certain columns.

      2. **Save a Custom View**:
      – Go to the **View** tab in the ribbon.
      – Click on **Custom Views**.
      – Press **Add** to create a new view.
      – Give your view a name and decide whether to include print settings and hidden rows and columns in the view.
      – Click **OK** to save the view.

      3. **Using Custom Views**:
      – Whenever you need to return to this specific setup, go back to the **View** tab.
      – Click on **Custom Views**, then select the view you saved and click **Show**.

      This feature can make your workflow in Excel more efficient, especially when dealing with complex datasets where you often need to switch between different data perspectives or configurations. However, it’s important to note that custom views do not work if the workbook contains tables. You would need to convert tables to ranges if you want to use this feature.

Leave a Reply

Your email address will not be published. Required fields are marked *