Excel - Easily Break Up Data using Subtotals and Conditional Formatting

Posted on:  04/01/2023
Excel - Easily Break Up Data using Subtotals and Conditional Formatting

After sorting in Excel, we will look at two great methods for separating blocks of data or showing a clean separator between our groups. 

Break between groups in Excel

Break between groups in Excel

A group may be departments, states, countries, or cities. We will use the Subtotal command, and Page Breaks between Groups for one example. We will follow up with advanced conditional formatting using borders between groups. We will also print titles or our header rows to it is easy to identify the titles on every page. 

Excel Subtotals to put breaks between groups

Excel Subtotals to put breaks between groups

YouTube Video


Lifetime access to Teams Course Beginner to Pro with coupon

Online Microsoft Teams Training with Chris Menard

50% off coupon

Just some of the topics covered

  1. Navigation Teams
  2. Using private Chat
  3. Using group Chat
  4. Teams Meetings
    1. Scheduling Meetings
    2. Meeting controls
    3. Roles in a meeting
    4. Sharing resources
    5. PowerPoint in a meeting
    6. Scheduling Team meetings from Outlook
  5. Working with Teams and Channels
    1. Conversations
    2. Files
    3. Wiki and OneNote
  6. Using Outlook and Teams
  7. Using apps in Teams

Steps to Print Titles in Excel

Need your header row to repeat on pages when printing? That is called Print Titles. To Print Titles in Excel,

  1. Click the Page Layout tab.
  2. Click Print Titles
  3. Select the row or rows you want to repeat on each page.
  4. Click Print Preview to test.
Excel Print Titles

Excel Print Titles

Excel Rows to repeat at top

Excel Rows to repeat at top

Recent Articles

OneNote - SORT PAGES  - New Feature - 2022

OneNote - SORT PAGES - New Feature - 2022

3 AWESOME TIPS when working with OneNote & Outlook

3 AWESOME TIPS when working with OneNote & Outlook

Breakeven Analysis - Breakeven in Units and Breakeven in Sales

Breakeven Analysis - Breakeven in Units and Breakeven in Sales

Excel - Combine the SORT, UNIQUE, and COUNT functions

Excel - Combine the SORT, UNIQUE, and COUNT functions

Excel Import Data from the Web

Excel Import Data from the Web

Excel - Turn on Multiple Filters in a PivotTable

Excel - Turn on Multiple Filters in a PivotTable

Chris Menard

Chris Menard is a Microsoft Certified Trainer (MCT) and is employed full-time as a Trainer for BakerHostetler, one of the nation’s largest law firms. Menard has a YouTube channel with over 900 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 16 million viewers have appreciated. Menard also does public speaking at conferences for CPAs and Administrative Professionals. Connect with Chris on LinkedIn at chrismenardtraining.com/linked or on YouTube at chrismenardtraining.com/youtube

Categories