---
title: "One Copilot prompt that summarises a 20-tab workbook"
date: 2026-07-18T00:00:00Z
updated: 2026-07-12T04:57:39Z
tags: ["Copilot", "Excel", "Microsoft 365", "Efficiency", "Prompting"]
canonical: https://bianca.codes/blog/one-copilot-prompt-that-summarises-a-20-tab-workbook/
---

# One Copilot prompt that summarises a 20-tab workbook

_The one Copilot prompt that turns twenty unlabelled tabs into a sheet-by-sheet summary, outliers included, in under a minute._

Someone forwards you a workbook with twenty tabs, no notes, and a filename that ends in "\_v3\_final". The old move is clicking through every sheet in turn, trying to remember what tab six said by the time you reach tab fourteen. Skip that. Ask Copilot for the map first.

## How to do it

1. Open the workbook in Excel and launch Copilot from the ribbon. It reads whatever file is actually open in front of it, not a description of one, so it has to be the live workbook, not a screenshot or a copy pasted into chat.
2. Use this prompt:

```plaintext
Give me a one-line summary of what's on each tab in this workbook, then tell me which tabs contain numbers that look like outliers compared to the rest of the sheet.
```

1. Read what comes back. You'll get a sheet-by-sheet rundown, and usually two or three tabs flagged as worth a closer look.
2. Open one of the flagged tabs yourself and check the number by eye before you trust it. This is the step people skip, and it's the one that actually matters.

## Why it works

Copilot in Excel reads the structure of whatever workbook is open, tab by tab, the same way you would if you had the patience for all twenty. Asking for the summary and the outliers in one prompt gets both passes done at once, instead of you typing "what's on this sheet" twenty separate times.

What it's doing is pattern-matching: spotting a number that doesn't fit the shape of the column around it. What it isn't doing is auditing the formula that produced that number. A figure can be a textbook outlier and still be completely correct, or blend in perfectly and still be wrong. The manual check above is what catches the difference.

## When not to use it

If the tabs weren't built the same way, some with headers, some without, half the data pasted as values with merged cells scattered through, Copilot's read gets noticeably shakier, and the outlier flagging is the first thing to go soft. And this only ever covers the workbook you have open. If the real question is whether tab six in this file matches tab six in last month's file, that's a different job, and this prompt doesn't do it.

A couple of weeks ago, the argument here was to [stop reading Copilot hot takes and just open the thing](/blog/copilot-hot-take/). This is the thing to open first. The fuller version, a week spent actually living inside Copilot including where it quietly got things wrong, is coming later this month.