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, 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?

12 Replies

  • BriGuy1006's avatar
    BriGuy1006
    Copper Contributor

    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 

    • SGexcel's avatar
      SGexcel
      Copper Contributor
      You need to uninstall a Excel Add-in that comes with the Logitech mouse.  It worked for me

      Select Programs > Programs and Features.
      Press and hold (or right-click) on the program you want to remove and select Uninstall or Uninstall/Change. Then follow the directions on the screen.
      Look for logitech excel add-in
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    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's avatar
      suionhk
      Copper Contributor

      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

Resources