![merge and center in excel 2016 merge and center in excel 2016](https://cdn.ablebits.com/_img-lp18/excel-merge-cells-lp18/cells-into-one-initial.png)
This will create a simple formula that fills the first blank cell with the value from the above cell: With all the blank cells selected, type the equality sign (=) and press the Up Arrow key.In the Go To Special dialog window, tick off the Blanks option, and click OK:.Select the entire table again, go to the Home tab > Editing group, click Find & Select, and then click Go To Special….This will split all merged cells, but only the upper-left unmerged cells will be filled with data. Select your table (or just the columns that have merged cells) and click the Merge & Center button on the Home tab.To unmerge cells and fill down with duplicate values, please follow these steps: To improve the structure of your dataset, you may often need not only to unmerge cells but also fill each unmerged cell with the value from the original cell, as shown in the screenshot below:
#Merge and center in excel 2016 how to#
How to unmerge cells and copy the original value to each unmerged cell
![merge and center in excel 2016 merge and center in excel 2016](https://i.ytimg.com/vi/v1_TVBdNm5k/maxresdefault.jpg)
When you have related data in several cells, you may be tempted to combine them into a single cell for alignment or comparison purposes. This short tutorial shows how to quickly unmerge cells in Excel, how to find all merged cells in a worksheet, and how to fill each unmerged cell with the original value from the merged cell.