google

Newest Post

Showing posts with label Go to Special. Show all posts
Showing posts with label Go to Special. Show all posts

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

| Tuesday, March 22, 2016
Read more »
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.

And

TaDa!!!! DONE

Prev
▲Top▲