Microsoft Excel - Unmerge cells and fill down the values in all rows

| Tuesday, March 22, 2016
This can be done using Go to Special command in Find and Select option. Following are the steps to achieve this.
1. Select the columns that have merged cells.
2. Click Home > Merge & Center > Unmerge Cells
3. The merged cells have been unmerged and only the first cell will be filled with the original values. Keep the range selected or select the range again.
4. Click Home > Find & Select > Go To Special. In the Go To Special dialog box, select Blanks option

5. Click OK, all of the blank cells in the range have been selected. Then input = and press Up arrow key on the keyboard.
6. Press Ctrl + Enter keys, all of the blank cells have been filled with the original merged data.


TaDa!!!! DONE


Post a Comment

Next Prev