Note: Text overflow in cells is a visual problem. 1.Select the column that you want to filter the specific merged cell, and then click Kutools Plus > Special Filter > Special Filter, see screenshot. It also checks if the cell is not empty, otherwise, the loop would go to the last cell inside the worksheets and the program would crash. Instead of copying the text from the second tab's field, the formula just appears in the cell. You can take the text in one or more cells, and distribute it to multiple cells. If you drag the yellow dot, you copy the cell contents to the rows you drag over.
The shortcut to toggle absolute and relative references is F4 in Windows, while on a Mac, its Command T. On the first tab, there is a reference to that cell. In Excel, there is no way that can merge cells in a table, but here I introduce a roundabout trick for you to merge cells in a table.
