20 1 10 False 6 Format Cells dialog True False vertical 6 True False end gtk-help True True True False True False False 0 gtk-apply True True True False True False False 1 gtk-cancel True True True False True False False 2 gtk-ok True True True True False True False False 3 False True end 0 True True 5 True True False 12 6 12 True False 0 <b>Horizontal alignment</b> True 0 0 3 1 _Left True True False 24 6 True 0 True halign_justify 0 1 1 1 _General True True False 24 True 0 True halign_justify 0 2 1 1 Center across _selection True True False 24 True 0 True halign_justify 0 3 2 1 True False 24 0 _Indent: True halign_indent 0 4 1 1 True False 6 0 <b>Vertical alignment</b> True 0 5 3 1 Ce_nter True True False True 0 True halign_justify 1 1 1 1 _Right True True False True 0 True halign_justify 2 1 1 1 _Fill True True False True 0 True halign_justify 1 2 1 1 _Justify True True False True 0 True True 2 2 1 1 D_istributed True True False True 0 True halign_justify 2 3 1 1 True True • True False False adjustment1 1 True if-valid 1 4 1 1 _Top True True False 24 6 True 0 True True 0 6 1 1 C_enter True True False 24 True 0 True valign_top 0 7 1 1 _Bottom True True False 24 True 0 True valign_top 0 8 1 1 J_ustify True True False True 0 True valign_top 1 7 1 1 _Distributed True True False True 0 True valign_top 1 8 1 1 True False 6 0 <b>Control</b> True 0 9 3 1 _Wrap text True True False 24 6 True 0 True 0 10 2 1 Shrin_k to fit True False True False 24 True 0 True 0 11 2 1 True False 3 0 1 12 True False Alignment center False True False 12 1 True False Font center 1 False True False start 12 6 12 True False center start 24 6 6 True True True True True Reverse Diagonal Reverse Diagonal center center 0 0 1 1 True True True True Top Top center center 2 0 1 1 True True True True Diagonal Diagonal center center 4 0 1 1 True True True True Left Left center center 0 2 1 1 True True True True Right Right center center 4 2 1 1 True True True True Bottom Bottom center center 2 4 1 1 True True True True None None center center 6 0 5 1 1 True True True True Outline Outline center center 6 1 5 1 1 True True True True Inside Vertical Inside Vertical center center 6 2 5 1 1 True True True True Inside Inside center center 6 3 5 1 1 True True True True Inside Horizontal Inside Horizontal center center 6 4 5 1 1 True False 1 1 3 3 0 0 1 4 True False 0 <b>Line</b> True 1 0 2 1 True False 18 0 Style: True 1 1 2 1 True False 24 6 6 6 None True True True True 0 0 1 1 True True True 1 0 1 1 True True True 0 1 1 1 True True True 1 1 1 1 True True True 0 2 1 1 True True True 1 2 1 1 True True True 0 3 1 1 True True True 1 3 1 1 True True True 0 4 1 1 True True True 1 4 1 1 True True True 0 5 1 1 True True True 1 5 1 1 True True True 0 6 1 1 True True True 1 6 1 1 1 2 2 1 True False 18 C_olor: True center 1 3 1 1 True False 2 3 1 1 2 True False Border center 2 False True False start 12 6 12 True False start 0 <b>Background</b> True 0 0 2 1 True False 0 <b>Sample</b> True 2 0 1 1 True False start 18 0 0 in 2 1 1 5 True False 18 0 C_olor: True center 0 1 1 1 True False start 12 0 <b>Pattern</b> True 0 2 2 1 True False 18 0 C_olor: True center 0 3 1 1 True False 18 0 Style: 0 4 1 1 True False start 0 0 True False 18 6 6 True True True True Solid Solid 3 0 0 1 1 True True True True 75% Grey 75% Grey 3 1 0 1 1 True True True True 50% Grey 50% Grey 3 2 0 1 1 True True True True 25% Grey 25% Grey 3 3 0 1 1 True True True True 12.5% Grey 12.5% Grey 3 4 0 1 1 True True True True 6.25% Grey 6.25% Grey 3 5 0 1 1 True True True True Horizontal Stripe Horizontal Stripe 3 0 1 1 1 True True True True Vertical Stripe Vertical Stripe 3 1 1 1 1 True True True True Reverse Diagonal Stripe Reverse Diagonal Stripe 3 2 1 1 1 True True True True Diagonal Stripe Diagonal Stripe 3 3 1 1 1 True True True True Diagonal Crosshatch Diagonal Crosshatch 3 4 1 1 1 True True True True Thick Diagonal Crosshatch Thick Diagonal Crosshatch 3 5 1 1 1 True True True True Thin Horizontal Stripe Thin Horizontal Stripe 3 0 2 1 1 True True True True Thin Vertical Stripe Thin Vertical Stripe 3 1 2 1 1 True True True True Thin Reverse Diagonal Stripe Thin Reverse Diagonal Stripe 3 2 2 1 1 True True True True Thin Diagonal Stripe Thin Diagonal Stripe 3 3 2 1 1 True True True True Thin Horizontal Crosshatch Thin Horizontal Crosshatch 3 4 2 1 1 True True True True Thin Diagonal Crosshatch Thin Diagonal Crosshatch 3 5 2 1 1 True True True True Foreground Solid Foreground Solid 3 0 3 1 1 True True True True Small Circles Small Circles 3 1 3 1 1 True True True True Semi Circles Semi Circles 3 2 3 1 1 True True True True Thatch Thatch 3 3 3 1 1 True True True True Large Circles Large Circles 3 4 3 1 1 True True True True Bricks Bricks 3 5 3 1 1 0 5 2 1 True False 1 1 1 1 True False 1 3 1 1 3 True False Background center 3 False True False start 12 6 _Lock True True False True 0 True 0 0 1 1 Hi_de True True False True 0 True 0 1 1 1 True False 0 0 10 Locking cells or hiding formulæ only affects protected worksheets. True 0 2 1 1 _Protect worksheet True True False True 0 True 0 3 1 1 4 True False Protection center 4 False True False start 12 6 12 True False 0 <span weight="bold">Criteria</span> True 0 0 3 1 True False 18 0 Allo_w: True center validation_constraint_type 0 1 1 1 True False 18 0 Con_dition: True center validation_operator 0 2 1 1 True False True model1 0 1 1 3 1 True True model2 0 1 2 3 1 Ignore _blank cells True True False 18 True 0 True 0 5 2 1 I_n-cell dropdown True True False True 0 True 2 5 2 1 True False 6 0 <b>Error alerts</b> True 0 6 3 1 True False 18 0 Ac_tion: True center validation_error_action 0 7 1 1 True False 1 7 3 1 True False 18 0 Titl_e: True center validation_error_title 0 8 1 1 True False 18 0 0 _Message: True center validation_error_msg 0 9 1 1 True True • True False False 1 8 3 1 True True in True True word 1 9 2 1 True False 3 9 1 1 True False 18 0 0 3 1 1 True False 18 0 0 4 1 1 5 True False Validation center 5 False True False 12 6 12 _Show input message when cell is selected True True False True 0 True 0 0 2 1 True False 0 Titl_e: True center input_msg_title 0 1 1 1 True False 0 0 _Message: True center 0 2 1 1 True True in True True word 1 2 1 1 True True True • True False False 1 1 1 1 6 False Input Message center 6 False True True 1 helpbutton applybutton cancelbutton okbutton Any Value (no validation) Whole numbers Numbers In a list Date Time Text length Custom min <= val <= max (between) val <= min || max <= val (not between) val == bound (equal to) val <> bound (not equal to) val > bound (greater than) val < bound (less than) val >= bound (greater than or equal) val <= bound (less than or equal)