Microsoft Excel

Styles in Tables and PivotTables and Grand Total Calculation - Excel

Chris Menard

12 Aug 2023 — 1 min read

When you create a Table or PivotTable in Excel, you can work with Styles. There are three style groups - Light, Medium, and Dark. Within each group are multiple styles. This is both for Tables and PivotTables. With Styles comes Banded Rows and Banded Columns.

**PivotTable Styles**

YouTube Video

Styles in Tables and PivotTables and Grand Total Calculation - Excel

Banded Rows and Banded Columns

After picking PivotTable Styles, you can use **Banded Columns** or **Banded Rows**. Banded Row and Banded Columns are located in the PivotTable Styles Options Group.

**Banded Columns in a PivotTable**

**Banded Rows in a PivotTable**

Chris Menard to Present “Executive Insights: Harnessing Excel for Strategic Analysis” at EA Ignite Conference

November 4, 2025 Microsoft MVP and productivity expert Chris Menard will be presenting a highly anticipated session titled “Executive Insights: Harnessing Excel for Strategic Analysis” at the EA Ignite Conference, held at the Renaissance Nashville Hotel. This premier event, running from November 3–5, 2025, is tailored for executive assistants

Chris Menard to Present “Mastering Microsoft 365 Copilot” at EA Ignite Conference

Chris Menard will present “Mastering Microsoft 365 Copilot” at EA Ignite in Nashville on Nov 3, 2025. Learn how Copilot boosts productivity in Word, Excel, PowerPoint, Outlook, and Teams during this hands-on session.

Microsoft Teams: Save Chat and Channel Messages is Back!

How to use the newly returned feature that lets you save Chat and Channel Messages in Teams so you can keep important conversations at your fingertips.

OneDrive Request Files: How to Use OneDrive to Collect Files Securely

OneDrive Request Files feature allows you to collect files from people inside or outside your organization, without letting those people see anyone else’s uploads.