Unmerge cells, and fill the blanks
"To do this, all the merged cells need to be the same size": merges prevent sorting, filtering and pivot tables. Unmerging in Excel leaves empty cells; here the merged value is copied into each one.
What this tool does
- The number of merged ranges per sheet, and the choice of sheets to process.
- Each merge removed, and its value copied into every cell it covered.
- The original cell's formatting carried over, so dates stay dates.
- The output file is read back: no existing value has changed.
What it does not do: The value is copied, never the formula. A merge of more than 10,000 cells is unmerged without being filled, so the file does not balloon.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Slim down a workbook : Phantom rows, thousands of styles, copied formatting: the extra weight, removed.
- Remove external links : The "this workbook contains links" warning goes away: formulas become values.
- Formulas to values : Paste Special, Values, on the whole workbook at once: the file is frozen.
- Recover a damaged file : The repaired workbook when possible, and always the data that could be read.
- Workbook health check : Size, phantom rows, styles, links, errors, hidden content: all of it, with one-click fixes.