Merged cells
Dean
CTRL + a(twice in 2003) to select all cells.
FormatCellsAlignment.
Uncheck "merged cells"
Gord Dibben MS Excel MVP
On Tue, 12 Sep 2006 16:11:55 -0700, "Dean" wrote:
I am having one of those problems with copying from one sheet and edit paste special values to another sheet. It says merged cells are not identically sized. So, I am trying to find and clear all merged cells, though I want to know which they are.
Can someone tell me how to identify which cells are merged? I tried deleting rows and columns but they seem to be in multiple places, so this method is not working well.
Thanks!
Dean
|