[Solved] Locate merged cells
Posted: Mon Jul 09, 2012 10:00 pm
I have a sheet and some cells are merged in it but I dont know which cells are merged . Is there any way we can quickly find the cells that are merged.
Download http://user.services.openoffice.org/en/ ... p?id=11048
Do NOT unzip and point Tools>Extensions... to this zip package.
Close the office or all spreadsheets at least.
Open your sheet and call
menu:Tools>Add-Ons>SpecialCells>Formattings...
Search in the grouped list of cell format ranges for ranges with attribute <Merged>.