Forum Discussion

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

Detlef_Lewin

Silver Contributor

Jul 25, 2017

suionhk,

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).

suionhk
Copper Contributor
Jul 25, 2017
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
- Detlef_Lewin
  Silver Contributor
  Jul 25, 2017
  suionhk,
  
  yes, right klick works.
  - Carly Stroker
    Copper Contributor
    Oct 12, 2017
    Hello,
    
    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?
    
    Thank you.