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%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
Highlighted
Occasional 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
Highlighted
Best Response confirmed by dstedham (Occasional 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 

Highlighted

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

Highlighted

@dstedham Glad i could help!