Search and Find the Merged Cells
Merging cells in Excel
About Cells and acts on them (selecting, copying, moving, etc.) I wrote already on this website - tutorials (see the content of the topics on this site). Excel has the ability to Merge Cells. If you ask a question of how multiple cells to create a single cell then refer to the following instructions. To merge two or more cells into one cell (one unit) is sufficient to select a range of cells that you want to connect and click in the group commands Alignment => Merge & Center command / button. In the picture below you see a merged cell (gray cells).
You notice that the following cells merged into one (merged cells retain the address of the first cell in the upper left corner)
B2=> B2:B3, B5=> B5:B7, B10=> B10:B13, B15=> B15:B16, D3=> D3:E7, D10=> D10:E10, E13=> E13:F14.
How to find the merged Excel cells
If you are working on the worksheet for the first time and you are not familiar with the organization of data and you want to find out that all the cells are merged in a worksheet, or you want to know the address merged cell do the following:
On the ribbon, in the Home tab Editing group commands, click Find & Select => Find
He opened a dialogue window Find and Replace, click the Format button and select the Format command.
In the next step, you open a new dialog window 'Find Format'. In this dialog box, turn ON (check box) in front of the 'Merge Cells' and then click on the OK button.
Search Merged Cell step by step
Again you are return to the dialogue box 'Find and Replace'. Now in this dialog box, click on the 'Find Next' button. Excel will select the first cell merged, after the next click on 'Find Next' button Excel will find the next merged cell and so again in a circle (loop). (You note the picture below to Excel frame the merged cells green frame). If you look at the address field, you will see the address of the first cell of all merged).