Workbooks & Sheets

Every Excel file you open is a workbook. And inside every workbook, you can have as many sheets as you need. Understanding how workbooks and sheets relate to each other — and how to manage them properly — is one of those foundational skills that makes everything else in Excel feel more organised and in control. Let's walk through it all.

Workbook vs Worksheet — The Difference

Think of a workbook like a physical binder. The binder itself is the workbook — it is the file you save, share, and open. Inside that binder you can have multiple pages, and each page is a worksheet. You can see your worksheets as tabs running along the bottom of the screen.

When you save your work, you are saving the entire workbook — all sheets included — into a single .xlsx file. Every sheet inside it is saved together.

Creating and Managing Sheets

By default, every new workbook opens with one sheet called Sheet1. That is fine for simple work, but in real projects you will almost always want multiple sheets — one for raw data, one for your analysis, one for charts and dashboards.

Here are all the ways you can manage your sheets, and how to do each one:

Naming Your Sheets Well

This is one of the simplest habits that separates organised Excel users from messy ones. The default names Sheet1, Sheet2, Sheet3 tell you absolutely nothing. When you come back to a workbook three months later — or when a colleague opens it — meaningful names make everything immediately clear.

Referencing Cells Across Sheets

Here is where things get really useful. You are not limited to using data from the same sheet in a formula. You can reference a cell from a completely different sheet inside the same workbook. This is called a cross-sheet reference or a 3D reference.

The syntax is simple — you write the sheet name, followed by an exclamation mark, followed by the cell address:

SheetName!CellAddress

Examples:
  'Raw Data'!B2        →  Cell B2 from the sheet named Raw Data
  Summary!D10          →  Cell D10 from the sheet named Summary
  'Jan Sales'!C5       →  Cell C5 from the sheet named Jan Sales

Notice that when a sheet name contains a space, you wrap it in single quote marks. If the name has no spaces, the quotes are optional. Excel actually adds them automatically when you build a cross-sheet formula by clicking — so you rarely need to type them yourself.

Let's say your Raw Data sheet has monthly sales in column B, and you want your Summary sheet to pull the January total. In the Summary sheet you would write:

='Raw Data'!B2

Or if you want to sum a whole column from another sheet:

=SUM('Raw Data'!B2:B13)

This cross-sheet linking is what makes multi-sheet workbooks so powerful. You keep your raw data on one sheet, untouched and clean. Your analysis and summaries sit on separate sheets pulling from it. If the raw data changes, every summary updates automatically.

A Practical Multi-Sheet Setup

Let me show you how a well-organised real-world workbook is typically structured. This is the kind of setup you will build yourself in the later project lessons of this course:

Grouping Sheets

There is a handy trick for when you need to make the same change to multiple sheets at once — for example, adding the same header row to twelve monthly sheets. Instead of doing it twelve times, you can group the sheets first.

To group sheets, hold Ctrl and click each sheet tab you want to include. The selected tabs turn white and the title bar shows [Group]. Now anything you type or format on one sheet applies to all grouped sheets simultaneously. When you are done, click any ungrouped tab to exit the group.

Protecting a Sheet

Once you have built a workbook and filled it with formulas, the last thing you want is someone accidentally overwriting them. Sheet protection locks all the cells on a sheet so nothing can be edited unless a password is entered.

Go to Review → Protect Sheet. You can set a password, or leave it blank for a simple lock with no password needed. You can also choose which specific actions are still allowed — like selecting cells, or sorting — while everything else stays locked.

If you only want to protect certain cells and leave others editable, you first select the cells that should remain editable, right-click → Format Cells → Protection tab → uncheck Locked. Then apply the sheet protection. Only the unlocked cells will remain editable.

Next up — we get hands-on with cells and ranges, covering how to select, name, and reference them, plus the difference between absolute and relative references which every formula writer needs to understand.