Hide a column with merged cell across the column

%3CLINGO-SUB%20id%3D%22lingo-sub-89912%22%20slang%3D%22en-US%22%3EHide%20a%20column%20with%20merged%20cell%20across%20the%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-89912%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%2C%20I%20am%20using%20Excel%202016.%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20hide%20a%20column%20with%20merged%20cells%3A%20e.g.%3C%2FP%3E%3CP%3ECell%26nbsp%3BA2%20%26amp%3B%20B2%20%26amp%3B%20C2%20have%20been%20merged%2C%20while%20I%20would%20like%20to%20hide%20column%20B.%20When%20I%20highlight%26nbsp%3Bby%20right%20clicking%26nbsp%3Bcolumn%20B%2C%20the%20whole%20section%20Column%20A%20%2F%20B%20%2F%20C%20are%20all%20highlighted%20so%20I%20can't%20just%20hide%20column%20B.%3C%2FP%3E%3CP%3EThis%20doesn't%20happen%20in%20older%20version.%20Any%20idea%20pls%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-89912%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EHidding%20column%20with%20merged%20cells%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-156880%22%20slang%3D%22en-US%22%3ERe%3A%20Hide%20a%20column%20with%20merged%20cell%20across%20the%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-156880%22%20slang%3D%22en-US%22%3E%3CP%3EI%20think%20I%20figured%20out%20the%20issue%20for%20me%20at%20least.%26nbsp%3B%20It%20has%20to%20do%20with%20the%20EPM%20add-in.%26nbsp%3B%20When%20I%20am%20logged%20into%20BPC%20via%20the%20EPM%20add%20in%20I%20cannot%20hide%20an%20individual%20column%20that%20contains%20merged%20cells.%26nbsp%3B%20If%20I%20log%20off%2C%20then%20it%20works%20just%20like%20it%20did%20in%20excel%202013.%26nbsp%3B%20So%20this%20may%20be%20related%20to%20the%20service%20pack%20of%20the%20EPM%20add-in%20rather%20than%20excel%20itself.%26nbsp%3B%20Thanks%20for%20the%20reply.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-156845%22%20slang%3D%22en-US%22%3ERe%3A%20Hide%20a%20column%20with%20merged%20cell%20across%20the%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-156845%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Russ%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECould%20you%20please%20give%20bit%20more%20details%20how%20you%20do%20that.%20In%20Excel%202016%3A%3C%2FP%3E%0A%3CP%3EInitially%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20198px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F28481iC4219BD59B2E78A1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Hide01.JPG%22%20title%3D%22Hide01.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EWhen%20select%20entire%20column%20B%2C%20right%20click%20on%20it%20and%20Hide%20from%20menu%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20147px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F28482i272095E0A7E5650A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Hide02.JPG%22%20title%3D%22Hide02.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EAs%20general%20comment%20-%20better%20to%20avoid%20merged%20cells%20at%20all.%20Here%20you%20may%20select%20cells%20A1%3AC1%20(unmerged)%2C%20Ctrl%2B1%2C%20Alignment%20and%20Center%20Across%20Selection%20in%20Horizontal%20drop%20down%20list%20menu.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-156723%22%20slang%3D%22en-US%22%3ERe%3A%20Hide%20a%20column%20with%20merged%20cell%20across%20the%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-156723%22%20slang%3D%22en-US%22%3E%3CP%3EHas%20anyone%20found%20a%20resolution%20to%20this%3F%26nbsp%3B%20It%20only%20happens%20using%20excel%202016%20not%20previous%20versions.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-116020%22%20slang%3D%22en-US%22%3ERe%3A%20Hide%20a%20column%20with%20merged%20cell%20across%20the%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-116020%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20have%20this%20problem.%26nbsp%3B%20I%20have%20a%20header%20that%20is%20merged%20across%20columns%20A%2C%20B%2C%20and%20C.%20When%20I%20right%20click%20column%20B%20and%20select%20'Hide'%20from%20the%20menu%20it%20hides%20columns%20A%2C%20B%2C%20and%20C%2C%20not%20just%20column%20B.%20In%20previous%20versions%20of%20excel%20I%20was%20able%20to%20just%20hide%20column%20B.%20How%20do%20I%20accomplish%20this%20with%20Excel%202016%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-90174%22%20slang%3D%22en-US%22%3ERe%3A%20Hide%20a%20column%20with%20merged%20cell%20across%20the%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-90174%22%20slang%3D%22en-US%22%3E%3CP%3Esuionhk%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyes%2C%20right%20klick%20works.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-90160%22%20slang%3D%22en-US%22%3ERe%3A%20Hide%20a%20column%20with%20merged%20cell%20across%20the%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-90160%22%20slang%3D%22en-US%22%3E%3CP%3EDo%20you%20highlight%20by%20left%20clicking%20or%20right%3F%20As%20my%20aim%20is%20to%20hide%20the%20column%20so%20I%20need%20a%20right%20click%20highlight%20and%20then%20click%20on%20Hide%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-89928%22%20slang%3D%22en-US%22%3ERe%3A%20Hide%20a%20column%20with%20merged%20cell%20across%20the%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-89928%22%20slang%3D%22en-US%22%3E%3CP%3Esuionhk%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20I%20highlight%20column%20B%20as%20part%20of%20merged%20cells%20A2%3AC2%20then%20only%20column%20B%20is%20hightlighted.%3C%2FP%3E%3CP%3EI'm%20using%20Excel%202016%20(Office%20365%20subscription).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1599224%22%20slang%3D%22en-US%22%3ERe%3A%20Hide%20a%20column%20with%20merged%20cell%20across%20the%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1599224%22%20slang%3D%22en-US%22%3E%3CP%3EDid%20we%20ever%20solve%20for%20this%3F%26nbsp%3B%20I%20am%20now%20having%20this%20issue%20after%20getting%20a%20new%20work%20computer%20and%20going%20from%20Excel%202013%20to%20Excel%202016.%26nbsp%3B%20It%20is%20extremely%20frustrating!%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F68620%22%20target%3D%22_blank%22%3E%40suionhk%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1830171%22%20slang%3D%22en-US%22%3ERe%3A%20Hide%20a%20column%20with%20merged%20cell%20across%20the%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1830171%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F87018%22%20target%3D%22_blank%22%3E%40Carly%20Stroker%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20need%20to%20uninstall%20a%20Excel%20Add-in%20that%20comes%20with%20the%20Logitech%20mouse.%26nbsp%3B%20It%20worked%20for%20me%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%20class%3D%22X5LH0c%22%3E%3CLI%3ESelect%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EPrograms%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%26gt%3B%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EPrograms%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eand%20Features.%3C%2FLI%3E%3CLI%3EPress%20and%20hold%20(or%20right-click)%20on%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3Eprogram%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eyou%20want%20to%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3Eremove%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eand%20select%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EUninstall%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eor%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EUninstall%3C%2FSTRONG%3E%2FChange.%20Then%20follow%20the%20directions%20on%20the%20screen.%3C%2FLI%3E%3C%2FOL%3E%3CP%3ELook%20for%20logitech%20excel%20add-in%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1830172%22%20slang%3D%22en-US%22%3ERe%3A%20Hide%20a%20column%20with%20merged%20cell%20across%20the%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1830172%22%20slang%3D%22en-US%22%3EYou%20need%20to%20uninstall%20a%20Excel%20Add-in%20that%20comes%20with%20the%20Logitech%20mouse.%26nbsp%3B%20It%20worked%20for%20me%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3ESelect%26nbsp%3BPrograms%26nbsp%3B%26gt%3B%26nbsp%3BPrograms%26nbsp%3Band%20Features.%3CBR%20%2F%3EPress%20and%20hold%20(or%20right-click)%20on%20the%26nbsp%3Bprogram%26nbsp%3Byou%20want%20to%26nbsp%3Bremove%26nbsp%3Band%20select%26nbsp%3BUninstall%26nbsp%3Bor%26nbsp%3BUninstall%2FChange.%20Then%20follow%20the%20directions%20on%20the%20screen.%3CBR%20%2F%3ELook%20for%20logitech%20excel%20add-in%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1830174%22%20slang%3D%22en-US%22%3ERe%3A%20Hide%20a%20column%20with%20merged%20cell%20across%20the%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1830174%22%20slang%3D%22en-US%22%3EYou%20need%20to%20uninstall%20a%20Excel%20Add-in%20that%20comes%20with%20the%20Logitech%20mouse.%26nbsp%3B%20It%20worked%20for%20me%3CBR%20%2F%3E%3CBR%20%2F%3ESelect%26nbsp%3BPrograms%26nbsp%3B%26gt%3B%26nbsp%3BPrograms%26nbsp%3Band%20Features.%3CBR%20%2F%3EPress%20and%20hold%20(or%20right-click)%20on%20the%26nbsp%3Bprogram%26nbsp%3Byou%20want%20to%26nbsp%3Bremove%26nbsp%3Band%20select%26nbsp%3BUninstall%26nbsp%3Bor%26nbsp%3BUninstall%2FChange.%20Then%20follow%20the%20directions%20on%20the%20screen.%3CBR%20%2F%3ELook%20for%20logitech%20excel%20add-in%3C%2FLINGO-BODY%3E
New Contributor

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

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

 

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

suionhk,

 

yes, right klick works.

 

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.

Has anyone found a resolution to this?  It only happens using excel 2016 not previous versions.

Hi Russ,

 

Could you please give bit more details how you do that. In Excel 2016:

Initially

Hide01.JPG

When select entire column B, right click on it and Hide from menu:

Hide02.JPG

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.

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.

 

 

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 

@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

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
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 thnx thats work for me too