Excel - Easily Break Up Data using Subtotals and Conditional Formatting

Posted on:  04/01/2023

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

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. 

YouTube Video

---

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.

Recent Articles

Categories

• Blog » Microsoft » Microsoft Excel » Intermediate