Adding additional options to Format Cells GUI

%3CLINGO-SUB%20id%3D%22lingo-sub-3387391%22%20slang%3D%22en-US%22%3EAdding%20additional%20options%20to%20Format%20Cells%20GUI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3387391%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20was%20hoping%20there%20is%20a%20way%20to%20add%20features%2F%20functions%20within%20the%20Format%20Cells%20interface.%20Number%2C%20Alignment%2C%20Font%2C%20Border%2C%20and%20Fill%20are%20all%20useful%2C%20but%20I%20was%20hoping%20to%20add%20features%20for%20adjusting%20column%20width%20and%20row%20height.%20Ideally%2C%20this%20function%20would%20be%20paired%20with%20the%20conditional%20formatting%20function%20to%20be%20applied%20to%20every-other-row%2Fcolumn.%3CBR%20%2F%3E%3CBR%20%2F%3EI've%20tried%20navigating%20through%20the%20%22Customize%20Ribbon%22%20interface%2C%20etc.%2C%20but%20have%20not%20had%20any%20luck%20and%20cannot%20find%20any%20other%20resources%20online.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20for%20your%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3387391%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3387669%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20additional%20options%20to%20Format%20Cells%20GUI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3387669%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1392582%22%20target%3D%22_blank%22%3E%40ChronicallyAcute%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20Format%20Cells%20dialog%20cannot%20be%20customized.%20Moreover%2C%20row%20height%20and%20column%20width%20are%20not%20properties%20of%20a%20cell%2C%20but%20of%20an%20entire%20row%2Fcolumn.%20You%20cannot%20set%20column%20width%20to%208%20in%20one%20cell%20of%20column%20A%20and%20to%2012%20in%20another%20cell%20of%20column%20A.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello all,

I was hoping there is a way to add features/ functions within the Format Cells interface. Number, Alignment, Font, Border, and Fill are all useful, but I was hoping to add features for adjusting column width and row height. Ideally, this function would be paired with the conditional formatting function to be applied to every-other-row/column.

I've tried navigating through the "Customize Ribbon" interface, etc., but have not had any luck and cannot find any other resources online.

Thanks for your help

1 Reply

@ChronicallyAcute 

The Format Cells dialog cannot be customized. Moreover, row height and column width are not properties of a cell, but of an entire row/column. You cannot set column width to 8 in one cell of column A and to 12 in another cell of column A.