SOLVED

Merge Command

%3CLINGO-SUB%20id%3D%22lingo-sub-1878644%22%20slang%3D%22en-US%22%3EMerge%20Command%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1878644%22%20slang%3D%22en-US%22%3E%3CP%3ENeed%20some%20help...for%20some%20reason%20over%20the%20past%20few%20weeks%20if%20I%20have%20merged%20cells%20across%20a%20few%20columns%20I%20can%20no%20longer%20adjust%20the%20width%20of%20one%20of%20those%20columns.%20When%20I%20highlight%20the%20column%20or%20columns%20that%20I%20want%20to%20adjust%20the%20width%2C%20all%20columns%20effected%20by%20the%20merged%20cells%20becomes%20highlighted%20as%20well.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1878644%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1879280%22%20slang%3D%22en-US%22%3ERe%3A%20Merge%20Command%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1879280%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F865987%22%20target%3D%22_blank%22%3E%40dstedham%3C%2FA%3E%26nbsp%3BAvoid%20using%20merged%20cells.%20Use%20%22Allignment%22%2C%20Horizontal%20and%20then%20Center%20Across%20Selection.%20More%20about%20that%20in%20the%20link%20below.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Flessons%2Fhow-to-use-center-across-selection-in-excel%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Flessons%2Fhow-to-use-center-across-selection-in-excel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1880044%22%20slang%3D%22en-US%22%3ERe%3A%20Merge%20Command%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1880044%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BPerfect%20and%20thank%20you%20so%20much%20for%20your%20reply...your%20response%20was%20spot%20on%20and%20now%20I%20can%20structure%20the%20workbook%20appropriately.%20Only%20wish%20I%20knew%20you%20three%20years%20ago%20when%20I%20was%20creating%20all%20of%20these%20templates!%20Lots%20to%20do%20in%20the%20weeks%20ahead.%20Thank%20you%20once%20again.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Need some help...for some reason over the past few weeks if I have merged cells across a few columns I can no longer adjust the width of one of those columns. When I highlight the column or columns that I want to adjust the width, all columns effected by the merged cells becomes highlighted as well. 

3 Replies
best response confirmed by dstedham (New Contributor)
Solution

@dstedham Avoid using merged cells. Use "Allignment", Horizontal and then Center Across Selection. More about that in the link below.

https://exceljet.net/lessons/how-to-use-center-across-selection-in-excel 

@Riny_van_Eekelen Perfect and thank you so much for your reply...your response was spot on and now I can structure the workbook appropriately. Only wish I knew you three years ago when I was creating all of these templates! Lots to do in the weeks ahead. Thank you once again.

@dstedham Glad i could help!