Excel allows changing text font type, size, color, bold, italic, and underline. Font type changes automatically when new text is typed. Font size can be adjusted from default 11 or 12. Text color can be changed using drop-down menu or More Colors option
Default formatting makes large workbooks difficult to read. Font size can be changed using keyboard or commands. Standard fonts include Calibri, Cambria, Times New Roman, and Arial. Bold, italic, and underline can be applied using keyboard shortcuts
Format objects are created using workbook add_format() method. Format properties can be set using object interface or dictionary. Default Excel 2007+ format is Calibri 11 with all other properties off
Excel stores dates and times as numbers by default. Time to hours: multiply by 24. Time to minutes: multiply by 24*60. Time to seconds: multiply by 24*60*60
Fill Color option allows customizing background using HEX codes. Cell Styles provide pre-configured formatting options. Page Setup enables using images or solid colors as backgrounds. VBA macros offer automated background customization
Windows: Control + 5 for strikethrough. Mac: Command + Shift + X for strikethrough. Shortcut works as toggle for single or multiple cells