• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

How to Create a Report by Territory in Excel

September 29, 2021 by Andrew Childress
How to create a report by territory in Excel

When you work in Excel, you might find yourself working with data from a variety of territories. Here's how to create a report by territory in Excel.

When you work in Excel, you might find yourself working with data from a variety of territories. Often, these represent geographic selling areas. It’s often useful to generate reports for specific territories. Fortunately, this is easy to do in Excel. We’ll work through a simple example to illustrate this idea. Let’s learn how to create a report by territory in Microsoft Excel.

How to Create a Report by Territory in Excel

Imagine that you’re a manager overseeing four territories. These are labeled North, South, East, and West. You’ve built a list of the last month’s sales for all of the territories. But now, you’ve been asked to create a report of sales for a single territory.

Your data is arranged as you see below. Territories are listed in column A, sales figures in column B, and salespeople in column C. You need to create a report for the West territory only. Of course, you don’t want to delete the data that doesn’t fit the request. Instead, you’ll want to simply filter it out.

Create report by territory Excel

To filter data by territory, you’ll first need to activate Excel’s Filter feature. To do that, start by clicking on row 1 to select the entire row. Then, go to the Home tab on the ribbon. Click on the Sort & Filter dropdown, then click Filter.

How to create a report by territory in Excel

Excel now displays Filter dropdown arrows. Click on the one in cell A1. Uncheck Select All, then click to select West. Excel will create a report by territory for you, showing your table only with the territory data that you selected.

Territory report in Excel

To generate a different report, you can simply select different filters. As you can see, it’s easy to create a report by territory in Microsoft Excel. It takes only moments, thanks to the use of dynamic filters that are included in Excel.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:False discovery rate in ExcelCalculate FDR in Excel
Next Post:Disable Research in ExcelHide research in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top