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.
- Find and replace : A find and replace Excel doesn't have: regular expression, every sheet, text and formulas, with a preview.
- Recover a damaged file : The repaired workbook when possible, and always the data that could be read.