07-25-2017 06:17 AM
07-25-2017 06:17 AM
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, the whole section Column A / B / C are all highlighted so I can't just hide column B.
This doesn't happen in older version. Any idea pls?
07-25-2017 07:10 AM
if I highlight column B as part of merged cells A2:C2 then only column B is hightlighted.
I'm using Excel 2016 (Office 365 subscription).
07-25-2017 10:20 AM
Do you highlight by left clicking or right? As my aim is to hide the column so I need a right click highlight and then click on Hide
10-12-2017 09:49 AM
I also have this problem. I have a header that is merged across columns A, B, and C. When I right click column B and select 'Hide' from the menu it hides columns A, B, and C, not just column B. In previous versions of excel I was able to just hide column B. How do I accomplish this with Excel 2016?
02-13-2018 07:07 AM
Has anyone found a resolution to this? It only happens using excel 2016 not previous versions.
02-13-2018 07:48 AM
Could you please give bit more details how you do that. In Excel 2016:
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.
02-13-2018 07:57 AM
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.
08-19-2020 09:32 AM
Did we ever solve for this? I am now having this issue after getting a new work computer and going from Excel 2013 to Excel 2016. It is extremely frustrating! @suionhk