Workbook vs Worksheet in Excel: What's the Difference
By ExcelReady TeamUpdated 6 min read
The short answer
A workbook is the whole Excel file, such as Budget.xlsx. A worksheet is one sheet inside that file, shown as a tab at the bottom of the window, with its own grid of rows, columns and cells. One workbook can hold many worksheets. You save, open and email workbooks; you type data and formulas on worksheets.
Key takeaways
- A workbook is the file (.xlsx); a worksheet is one tab of cells inside it.
- Each worksheet has 1,048,576 rows and 16,384 columns, from A to XFD.
- Reference another worksheet with =Sales!B2, and another workbook with =[Budget.xlsx]Sales!$B$2.
- Protect Sheet locks cells on one worksheet; Protect Workbook locks the structure, such as adding or deleting sheets.
On this page+
The short answer to workbook vs worksheet: a workbook is the whole Excel file, and a worksheet is one sheet inside it, shown as a tab at the bottom of the window. A workbook is like a binder; worksheets are the pages. This comparison is for beginners, job seekers preparing for an Excel test, and anyone who wants to use the right word in instructions, emails and interviews.
Workbook vs worksheet at a glance#
The workbook is the container you save; worksheets are where the cells, data and formulas live.
| Feature | Workbook | Worksheet |
|---|---|---|
| What it is | The Excel file | One grid of cells inside the file |
| Where you see it | The file name in the title bar | A tab at the bottom of the window |
| File extension | .xlsx, .xlsm, .xlsb, .csv | None (it lives inside a workbook) |
| How many | One per file | One or more per workbook |
| Size | Limited by memory | 1,048,576 rows × 16,384 columns |
| New one | Ctrl+N (Windows) / ⌘N (Mac) | Shift+F11, or the + button by the tabs |
| Reference from a formula | =[Budget.xlsx]Sales!$B$2 | =Sales!B2 |
| Protection | Protect Workbook (structure) | Protect Sheet (cells) |
| Saved separately | Yes | No, it is saved with its workbook |
People often say spreadsheet for either one, and sheet for a worksheet. A workbook can also contain chart sheets, which hold a single chart and no cells, but worksheets are what you will use almost all the time.
What a workbook is#
A workbook is the file you create, open, save and share. When you double-click Budget.xlsx, you open a workbook. Everything inside it, every sheet, chart, table and named range, is saved together when you press Ctrl+S (Windows) or ⌘S (Mac).
Common workbook file types:
- .xlsx: the standard format for workbooks without macros.
- .xlsm: a workbook that contains macros.
- .xlsb: a binary format that can open and save faster for very large files.
- .csv: plain text with one sheet of values only. Saving as CSV keeps just the active worksheet; see CSV vs XLSX for what you lose.
Workbook-level actions include saving, sharing, setting calculation options and protecting the structure, so nobody can add, delete or rename sheets.
What a worksheet is#
A worksheet is a single grid of cells, made of rows (numbered 1, 2, 3...) and columns (lettered A, B, C...). Each cell has an address, such as B2, which means column B, row 2. The cells, rows and columns lesson walks through this grid, and the guide to cell references explains addresses in depth.
Each worksheet has 1,048,576 rows and 16,384 columns, ending at column XFD. Every worksheet has its own name on its tab. Double-click the tab to rename it; names can be up to 31 characters and can't contain characters such as / \ ? * [ ] :. The guide on how to rename a sheet covers the rules and shortcuts.
To move between worksheets, press Ctrl+Page Down and Ctrl+Page Up on Windows, or Option+Right arrow and Option+Left arrow on a Mac. To insert a new worksheet, press Shift+F11 or click the + next to the last tab.
Same task: references within and across files#
Formulas show the difference most clearly. Suppose a workbook called Budget.xlsx has a worksheet named Sales with a total in B2.
A cell on the same worksheet#
=B2No sheet name is needed, because Excel assumes the current worksheet.
A cell on another worksheet in the same workbook#
=Sales!B2
='Q1 Sales'!B2The sheet name comes first, then an exclamation mark, then the cell. If the name contains spaces, wrap it in single quotes. The easiest way to get this right is to type =, click the other sheet's tab, click the cell and press Enter. The worksheets and cross-sheet formulas lesson practises exactly this.
A cell on a worksheet in another workbook#
=[Budget.xlsx]Sales!$B$2The workbook name goes in square brackets before the sheet name. Excel makes these references absolute (with dollar signs) by default. If the other workbook is closed, Excel shows its full file path. If it is moved or renamed, the link can break.
The same cell on several worksheets#
=SUM(Jan:Mar!B2)This 3D reference adds B2 on every worksheet from Jan to Mar, including any sheets between them. It only works across sheets in the same workbook.
When to think in workbooks#
Think at the workbook level when the action affects the whole file. That includes:
- Saving, sharing and emailing: you always send a workbook, never a lone worksheet.
- Linking files together, such as a summary workbook that pulls numbers from several department files.
- Protecting the structure: Review > Protect Workbook stops people adding, deleting, renaming or moving sheets.
- Choosing a file type, such as .xlsm for macros.
- Calculation settings, such as manual calculation, which apply to the open workbooks.
When to think in worksheets#
Think at the worksheet level for anything about cells and layout. That includes:
- Organising data: one worksheet per month, region or topic, with a summary sheet on top.
- Formulas and references, where the sheet name decides which cells you use.
- Protecting cells: Review > Protect Sheet locks cells on that worksheet only.
- Printing and page layout, which you set per worksheet.
- Navigation: the Name Box lets you jump to a cell, and typing a reference like
Sales!A1jumps to another sheet.
A tidy pattern for most files is one worksheet of raw data, one of lookup lists, and one summary or dashboard that uses formulas to read the others.
Common mistakes with workbooks and worksheets#
- Sending "the worksheet" when you mean the file. Colleagues receive the whole workbook, including hidden sheets. Check what's inside before you share.
- Deleting a worksheet that formulas use. Every formula that pointed at it shows a #REF! error. The guide to the #REF! error explains how to fix it. Deleting a sheet can't be undone, so save first.
- Renaming a workbook with links pointing to it. External references to the old file name break. Rename files before you build links, or use Data > Edit Links to update them.
- Forgetting quotes around sheet names with spaces.
=Q1 Sales!B2fails;='Q1 Sales'!B2works. - Expecting Protect Workbook to lock cells. It only protects the structure. Use Protect Sheet on each worksheet to lock cells.
- Saving as CSV without realising. Only the active worksheet is saved, and formulas become values.
Our recommendation#
Use the words precisely: workbook for the file, worksheet (or sheet) for a tab of cells. In practice, keep related data in one workbook with several well-named worksheets, rather than many separate files, because cross-sheet formulas are simpler and safer than links between workbooks. Protect sheets to lock cells, and protect the workbook to lock its structure. In a job interview, being able to explain this difference clearly, and write a cross-sheet reference on the spot, is a quick way to show you know the basics.
In short: the workbook is the binder, worksheets are the pages, and formulas can read across both.
Practise it#
Try the exercise on this page: count the worksheets listed in a workbook's sheet index. Then practise cross-sheet formulas in a live spreadsheet and review the cells, rows and columns lesson. Learning by doing sticks better than watching; see video courses vs hands-on practice for why. When you're ready, the basic Excel test checks these fundamentals under time pressure.
Try it yourself
This is a live spreadsheet. Type the formula in the green cell and press Enter.
Column A lists the worksheets in a sales workbook. In B7, use COUNTA to count how many worksheets the workbook has.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Rows used | |||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 | ||||
| 6 | ||||
| 7 | Worksheets | |||
| 8 | ||||
| 9 | ||||
| 10 |
Tip: COUNTA counts cells that are not empty. Give it the sheet names in A2:A5.
Practise this in a lesson
Frequently asked questions
What is the difference between a workbook and a worksheet in Excel?
A workbook is the Excel file you save and open. A worksheet is a single page of cells inside the workbook, shown as a tab at the bottom. A workbook contains one or more worksheets.
Is a spreadsheet a workbook or a worksheet?
People use spreadsheet for both. In Microsoft's own terms, the file is a workbook and each tab is a worksheet, often just called a sheet.
How many worksheets can a workbook have?
There is no fixed number; it is limited by your computer's memory. A new workbook in current versions of Excel starts with one worksheet, and you can add more with the plus button next to the tabs.
How do I reference a cell on another worksheet?
Type the sheet name, an exclamation mark and the cell, such as =Sales!B2. If the name has spaces, put it in single quotes: ='Q1 Sales'!B2.
What is the difference between Protect Sheet and Protect Workbook?
Protect Sheet stops people editing locked cells on one worksheet. Protect Workbook stops people adding, deleting, renaming, moving or hiding worksheets, but doesn't lock any cells.