Forum Discussion
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
- BriGuy1006Copper 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
- SGexcelCopper ContributorYou 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_LewinSilver 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).
- suionhkCopper 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
- Detlef_LewinSilver Contributor
suionhk,
yes, right klick works.