See all How-To Articles

How to Save Filtered Data in New Excel or Google Sheet

This tutorial demonstrates how to save filtered data in a new Excel or Google Sheet.

 

filtercopy intro

 

Copy Filtered Data to New Excel Sheet

Consider the table of data below. Say you only want to copy the data that has MJ as the Sales Person to a new sheet.

 

filtercopy all data

 

The first step is to filter the data for the salesperson MJ.

  1. Make sure you are clicked within the table of data and then, in the Ribbon, go to Home > Sort & Filter > Filter.

 

filtercopy auto filter

 

  1. Now, click on the AutoFilter icon in Column C heading, select MJ, and click OK.

 

filtercopy filter

 

  1. Highlight all the filtered rows and then, in the Ribbon, go to Home > Clipboard > Copy.

 

filtercopy copy

 

  1. To insert a new sheet into your current workbook, right-click on the sheet tab and select Insert

 

filtercopy right click menu

 

  1. Select Worksheet and click OK

 

filtercopy insert sheet

 

  1. Alternatively, you can insert a sheet by clicking on the small gray cross to the right of your last sheet tab.

 

filtercopy insert sheet cross

 

  1. Now, position your cursor where you wish the data to be pasted, and then in the Ribbon, go to Home > Clipboard > Paste OR press CTRL + V.

 

filtercopy ribbon paste

 

  1. The data is pasted including the cell formatting. However, the row and column sizes are not carried across.

 

filtercopy paste

 

  1. In the Ribbon, click File > Save to save your data.

 

filtercopy file save

 

Copy Filtered Data to New Excel Workbook

To copy the filtered data to a new Excel file rather than a new Excel Sheet, follow Steps 1–3 above.

  1. Then, in the Ribbon, select File > New and then click Blank workbook.

 

filtercopy file new

 

  1. Position your cursor where you wish the data to be pasted, and then in the Ribbon, select Home > Clipboard > Paste OR press CTRL + V.
  1. In the Ribbon, select File > Save to save your new workbook. The Save As dialog box appears as you are saving a new file.

 

filtercopy save as

 

  1. Type in the name of your file, choose the location to save it to and then click Save.

How to Save Filtered Data in a new Google Sheet

Saving Filtered data in Google Sheets is quite similar to Excel.

  1. Click within your data and then, in the Menu, select Data > Create a filter.

 

filtercopy gs create filter

 

  1. Select “MJ” in the Filter by values list.

 

filtercopy gs set filter

 

  1. Select the filtered data, and then, in the Menu, select Edit > Copy or press CTRL + C

 

filtercopy gs copy

 

  1. Add a new sheet to your current Google file by clicking on the Add Sheet button at the bottom of the screen next to the sheet tabs.

 

filtercopy gs add sheet

 

  1. Position your cursor where you wish the filtered data to be pasted, and then in the Menu, select Edit > Paste or press CTRL + V. Notice that as with Excel the values and formats are all pasted. With Google Sheets however, the column widths and rows heights are also pasted.

 

 filtercopy gs paste

 

  1. To save the data into a new Google file, in the Menu, select File > New >Spreadsheet.

 

filtercopy new book

 

  1. Give your new file a relevant name. The file is saved automatically.

 

filtercopy gs save

See all How-To Articles