Different column width on different rows on the same sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1739955%22%20slang%3D%22en-US%22%3EDifferent%20column%20width%20on%20different%20rows%20on%20the%20same%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1739955%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20we%20create%20a%20sheet%20with%20different%20column%20widths%20on%20different%20rows%20on%20the%20same%20sheet%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1739955%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1740003%22%20slang%3D%22en-US%22%3ERe%3A%20Different%20column%20width%20on%20different%20rows%20on%20the%20same%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1740003%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F818034%22%20target%3D%22_blank%22%3E%40Jsslider%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20use%20template%20where%20you%20manually%20defined%20the%20sizes%2C%20or%20use%20VBA%20programming%20to%20change%20the%20size%20if%20some%20logic%20for%20that%20is%20formally%20defined.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1740083%22%20slang%3D%22de-DE%22%3ESubject%3A%20Different%20column%20width%20on%20different%20rows%20on%20the%20same%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1740083%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F818034%22%20target%3D%22_blank%22%3E%40Jsslider%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22text-wrap%20tlid-copy-target%22%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EIf%20you%20mean%20something%20like%20that%2C%20I%20don't%20think%20VBA%20can%20help%20either.%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EThe%20same%20column%20in%20different%20rows%20different%3F%3C%2FSPAN%3E%20%3CSPAN%3E..%20that%20would%20be%20something%20new%20..%20for%20me.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-result-transliteration-container%20result-transliteration-container%20transliteration-container%22%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3CTABLE%20width%3D%22581%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2283%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2283%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2283%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2283%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2283%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2283%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2283%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%7C.......A........%7C%20.......B........%7C%20.......C........%7C%20.......D........%7C%20........E.......%7C%20column%201%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%7C.................%7C%20.................%7C%20.................%7C%20.................%7C%20.................%7C%20column%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%7C.................%7C%20.................%7C%20.................%7C%20.................%7C%20.................%7C%20column%203%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%7C.................%7C%20.................%7C%20................%7C%20.................%7C%20.................%7C%20column%204%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%7C.....%7C%20.....%7C%20..........%7C%20..........%7C%20.....%7C%20.....%7C%20..........%7C%20.........%7C%20...........%7C%20column%205%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%7C.....%7C%20.....%7C%20..........%7C%20..........%7C%20.....%7C%20.....%7C%20..........%7C%20.........%7C%20...........%7C%20column%206%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EOr%20do%20you%20mean%20column%20width%20per%20column%20or%20row%20height%20per%20row%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EI%20would%20be%20happy%20to%20learn%20more%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Can we create a sheet with different column widths on different rows on the same sheet?

2 Replies
Highlighted

@Jsslider 

You may use template where you manually defined the sizes, or use VBA programming to change the size if some logic for that is formally defined.

Highlighted

@Jsslider 

 

If you mean something like that, I don't think VBA can help either. The same column in different rows different? ..that would be something new .. for me.
 
       
 |.......A........|.......B........|.......C........|.......D........|........E.......| column 1
       
 |.................|.................|.................|.................|.................| column 
       
 |.................|.................|.................|.................|.................| column 3
       
 |.................|.................|................|.................|.................| column 4
       
 |.....|.....|..........|..........|.....|.....|..........|.........|...........| column 5 
       
 |.....|.....|..........|..........|.....|.....|..........|.........|...........| column 6 
       

 

Or do you mean column width per column or row height per row?

 

I would be happy to learn more

 

Nikolino

I know I don't know anything (Socrates)