In some situation you can't work with 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.

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.

To move around the worksheet with your keyboard, use the key combinations: