Forum Discussion

suionhk's avatar
suionhk
Copper Contributor
Jul 25, 2017

Hide a column with merged cell across the column

hi, I am using Excel 2016. I am trying to hide a column with merged cells: e.g. Cell A2 & B2 & C2 have been merged, while I would like to hide column B. When I highlight by right clicking column B,...
Hidding column with merged cells
rtpatter's avatar
rtpatter
Copper Contributor
Feb 13, 2018

Has anyone found a resolution to this?  It only happens using excel 2016 not previous versions.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 13, 2018

Hi Russ,

 

Could you please give bit more details how you do that. In Excel 2016:

Initially

When select entire column B, right click on it and Hide from menu:

As general comment - better to avoid merged cells at all. Here you may select cells A1:C1 (unmerged), Ctrl+1, Alignment and Center Across Selection in Horizontal drop down list menu.

  • rtpatter's avatar
    rtpatter
    Copper Contributor
    Feb 13, 2018

    I think I figured out the issue for me at least.  It has to do with the EPM add-in.  When I am logged into BPC via the EPM add in I cannot hide an individual column that contains merged cells.  If I log off, then it works just like it did in excel 2013.  So this may be related to the service pack of the EPM add-in rather than excel itself.  Thanks for the reply.

     

     

Resources