How to replace filtered data without disabling filter in Excel?
Supposing you want to replace some data in a filtered range in Excel, how will you get it done quickly? Normally, you might disable the filter, and then replace the data one by one. Here I will introduce several methods to replace filtered data without disabling filter in Excel easily.
Replace filtered data to same value without disabling filter in Excel
For example you find out some spelling mistakes in the filtered data, and now you want to batch correct these mistakes. In this case, you can replace all filtered data to same value without disabling filter as follows:
1. Select cells you will replace in the filter range, and press Alt + ; keys simultaneously to select only visible cells.
2. Type the value that you will replace with, and press the Ctrl + Enter keys at the same time.
Then you will see all selected cells in filtered range are replaced by the typed values at once.
Replace filtered data with exchanging filtered data with other ranges
Sometimes, you may want to replace a range of filtered data with other range. And you can get it done easily with Kutools for Excel’s Swap Ranges utility.
Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
More than 300 powerful features. Supports Office/Excel
2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features
30-day free trial. 60-day money back guarantee.