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
suionhk's avatar
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's avatar
Detlef_Lewin
Silver Contributor
Jul 25, 2017

suionhk,

 

yes, right klick works.

 

  • Carly Stroker's avatar
    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.

    • SGexcel's avatar
      SGexcel
      Copper Contributor
      Oct 28, 2020
      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
    • SGexcel's avatar
      SGexcel
      Copper Contributor
      Oct 28, 2020

      Carly Stroker 

       

      You need to uninstall a Excel Add-in that comes with the Logitech mouse.  It worked for me

       

      1. Select Programs > Programs and Features.
      2. 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

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

Resources