Topic area
Formatting & presenting reports
Making a generated workbook look like somebody finished it.
Topics in formatting & presenting reports
Each topic page gathers every guide, how-to, comparison and fix on its subject.
- Cell styling & layoutFonts, fills, borders, widths, frozen panes, merged titles, hyperlinks and print setup.
- Number & date formatsCurrency, percentages, dates and custom format codes that survive the round trip.
- Conditional formattingColour scales, data bars, thresholds, duplicates and whole-row highlighting.
- Charts & imagesNative Excel charts, sparklines, matplotlib figures, logos and pictures in cells.
- Tables, filters & outlinesExcel tables, autofilters, sorting and grouped outline rows.
- Report layouts & templatesMulti-sheet dashboards, summary and contents sheets, and filling a designed template.
- Protection & sharingLocked cells, passwords, hidden sheets and comments for workbooks other people will open.
Cell styling & layout
- OverviewFormatting and Charting Excel Reports with Python
- GuideBuilding Excel Reports with xlsxwriter
- GuideStyling Excel Cells with openpyxl
- How-toWrite Rich Text with Mixed Formats in One Cell with xlsxwriter
Number & date formats
- GuideApplying Number and Date Formats in Excel
- How-toFormat Dates in Excel Cells with Python
- How-toFormat Durations Over 24 Hours in Excel with Python
- How-toFormat Excel Cells as Currency with Python
Conditional formatting
- GuideApplying Conditional Formatting With openpyxl
- How-toAdd Data Bars and Colour Scales with openpyxl
- How-toAdd Icon Sets to Excel Cells with openpyxl
- How-toApply a Colour Scale per Row or per Column with openpyxl
Charts & images
- GuideBuilding Multi-Sheet Excel Dashboards
- OverviewFormatting and Charting Excel Reports with Python
- GuideCreating Charts in Excel with openpyxl
- GuideInserting Images and Logos into Excel
Tables, filters & outlines
- GuideCreating Excel Tables and Autofilters with Python
- How-toAdd a Total Row to an Excel Table with Python
- How-toAdd an Autofilter to an Excel Sheet with openpyxl
- How-toAdd Calculated Columns to an Excel Table with Python
Report layouts & templates
- OverviewAutomating Reporting Workflows with Python and Excel
- GuideBuilding Finance and Operations Reports in Excel with Python
- GuideBuilding Multi-Sheet Excel Dashboards
- GuideGenerating Excel Reports from Templates
Protection & sharing
- GuideProtecting and Sharing Excel Workbooks
- How-toAdd Comments and Notes to Excel Cells with Python
- How-toHide Sheets, Rows and Columns with openpyxl
- How-toLet Different People Edit Different Ranges
Other areas