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.

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
YouTube Video

Online Microsoft Teams Training with Chris Menard
50% off coupon
Just some of the topics covered
-
Navigation Teams
-
Using private Chat
-
Using group Chat
-
Teams Meetings
-
Scheduling Meetings
-
Meeting controls
-
Roles in a meeting
-
Sharing resources
-
PowerPoint in a meeting
-
Scheduling Team meetings from Outlook
-
Working with Teams and Channels
-
Conversations
-
Files
-
Wiki and OneNote
-
Using Outlook and Teams
-
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,
-
Click the Page Layout tab.
-
Click Print Titles
-
Select the row or rows you want to repeat on each page.
-
Click Print Preview to test.

Excel Print Titles

Excel Rows to repeat at top
Recent Articles
3 AWESOME TIPS when working with OneNote & Outlook
Need to stay organized with Outlook? Use Microsoft OneNote and Outlook together. Three tips on working with OneNote and Outlook. Tip 1 - Insert your meeting invitation into OneNote. You can see a list of attendees and check that they attended, and take meeting notes.
Excel - Combine the SORT, UNIQUE, and COUNT functions
Excel has dynamic array functions. Two of the dynamic array function are SORT and UNIQUE. I will combine SORT and UNIQUE and also combine them with COUNT and the COUNTA functions. This came from a user that asked how many unique zip codes were in a spreadsheet.
Excel Import Data from the Web
Excel allows you to pull data on a webpage into Excel. This is a great time-saving feature. Getting data from a webpage is done in Excel on the Data Tab using Get and Transform Data group, From Web command.
Excel - Turn on Multiple Filters in a PivotTable
Filter in PivotTables only allows one filter by default. To filter by more than one field, you need to turn on the PivotTable Option - Totals and Filters tab and check Allow multiple filters per field.
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