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.
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.
The first step is to filter the data for the salesperson MJ.
- Make sure you are clicked within the table of data and then, in the Ribbon, go to Home > Sort & Filter > Filter.
- Now, click on the AutoFilter icon in Column C heading, select MJ, and click OK.
- Highlight all the filtered rows and then, in the Ribbon, go to Home > Clipboard > Copy.
- To insert a new sheet into your current workbook, right-click on the sheet tab and select Insert
- Select Worksheet and click OK
- Alternatively, you can insert a sheet by clicking on the small gray cross to the right of your last sheet tab.
- 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.
- The data is pasted including the cell formatting. However, the row and column sizes are not carried across.
- In the Ribbon, click File > Save to save your data.
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.
- Then, in the Ribbon, select File > New and then click Blank workbook.
- Position your cursor where you wish the data to be pasted, and then in the Ribbon, select Home > Clipboard > Paste OR press CTRL + V.
- In the Ribbon, select File > Save to save your new workbook. The Save As dialog box appears as you are saving a new file.
- 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.
- Click within your data and then, in the Menu, select Data > Create a filter.
- Select “MJ” in the Filter by values list.
- Select the filtered data, and then, in the Menu, select Edit > Copy or press CTRL + C
- 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.
- 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.
- To save the data into a new Google file, in the Menu, select File > New >Spreadsheet.
- Give your new file a relevant name. The file is saved automatically.