If you have any questions or suggestions, please feel free to ask OfficeToolTips team.

See Also

Unmerging all merged cells

Unmerging all merged cells

Here's a quick way to unmerge all merged cells in a worksheet:
Workaround for sorting and filtering of merged cells

Workaround for sorting and filtering of merged cells

In some situations, you can't work with a workbook that consists of merged cells. To use Filter, Sort, or other functions, you need to unmerge cells and put to all of them the data from merged cells. This tip shows how to do it efficiently.
How to select all the embedded charts on the worksheet

How to select all the embedded charts on the worksheet

If you need to select all objects embedded into the worksheet, e.g., select all charts to adjust their size, press Ctrl+G and click the Special button or use Ctrl to select objects individually.