Hiding a column when cells are merged

[dougw2112]

Hello,

I have a worksheet with some merged cells. When I select a column
containing a merged cell, the entire merged set of cells is also
selected. When I select Hide, all columns in the merged row are
hidden, which is not what I want. For example:

Select B5 and C5, and merge them
Select the C column, notice how both B and C cells are selected in row
5
Select Hide. notice how the B column goes away also.


thanks

dougw

 

[JE McGimpsey]

Hello,

I have a worksheet with some merged cells. When I select a column
containing a merged cell, the entire merged set of cells is also
selected. When I select Hide, all columns in the merged row are
hidden, which is not what I want. For example:

Select B5 and C5, and merge them
Select the C column, notice how both B and C cells are selected in row
5
Select Hide. notice how the B column goes away also.

This is one reason why merged cells are the spawn of Beelzebub and
should never be used in any self-respecting worksheet (just my opinion,
of course).

That's design behavior - your solution is to unmerge the cells. If you
merged them in order to center text across two cells, use the
Format/Cells/Alignment/Center Across Selection option instead.

 

[dougw2112]

Thanks for the help. Given that I can't change this format I did find
a workaround.

Select a cell in the column to be hidden, and then go format/cell/hide
and it works correctly the same as the windows version.

thanks again