Excel Worksheets and Workbooks: A Complete Beginner's Guide

Last updated: November 2026 · Works in Excel for Microsoft 365, Excel 2021 and Excel 2019

Every Excel file is a workbook, and every workbook contains one or more worksheets, the grids of rows and columns where you type your data. Learning to organise worksheets well is the first step to building spreadsheets that are easy to use and easy to share. This guide shows you how to add, rename, move, copy, colour, hide, group and protect worksheets, and how to link data between them.

In this guide: Workbook vs worksheet · Managing sheets · Moving around · Freeze panes and split · Linking sheets · Grouping sheets · Protecting a sheet · Templates

Workbook vs worksheet

Think of a workbook as a folder and worksheets as the pages inside it. A sales workbook might have one sheet per month, a summary sheet and a sheet of product prices. The sheet tabs at the bottom of the window show every worksheet in the file. Each worksheet has 1,048,576 rows and 16,384 columns (A to XFD), so space is rarely a problem; clarity is.

Term	What it means
Cell	One box in the grid, named by column letter and row number, such as `B4`.
Range	A block of cells, such as `A1:D20`.
Worksheet	A single grid of cells with its own tab.
Workbook	The whole .xlsx file, containing all the worksheets.

Adding, renaming and organising worksheets

Insert a new worksheet

Click the + button to the right of the sheet tabs, or press Shift + F11. The new sheet appears with a name like Sheet2.

Rename a worksheet

Double-click the sheet tab (or right-click it and choose Rename).
Type a short, clear name such as Jan Sales or Price List.
Press Enter.

Sheet names can be up to 31 characters and cannot contain / \ ? * : [ ].

Move or copy a worksheet

Drag a tab left or right to change the order. To make a copy, hold Ctrl while you drag; Excel adds "(2)" to the copy's name. To move a sheet into a different workbook, right-click the tab, choose Move or Copy, pick the destination file, and tick Create a copy if you want to keep the original.

Colour-code sheet tabs

Right-click a tab and choose Tab Color. Using one colour for input sheets and another for reports helps everyone see at a glance where to type and where to read.

Hide and unhide worksheets

Right-click a tab and choose Hide to tuck away lookup tables or workings. To bring it back, right-click any tab, choose Unhide and select the sheet. Hiding is for tidiness only; it is not security.

Delete a worksheet

Right-click the tab and choose Delete. This cannot be undone with Ctrl + Z, so check formulas on other sheets do not depend on it first.

Moving around quickly

Shortcut	Action
`Ctrl` + `Page Down`	Next worksheet
`Ctrl` + `Page Up`	Previous worksheet
`Ctrl` + `Home`	Go to cell A1
`Ctrl` + `End`	Go to the last used cell
`Ctrl` + arrow key	Jump to the edge of the current data block
`Ctrl` + `G`	Go To a specific cell or named range

With many sheets, right-click the small arrows to the left of the tabs to see a list of every sheet and jump straight to one.

Keep headings visible: Freeze Panes and Split

On long lists, the header row scrolls out of view. To keep it on screen, go to View > Freeze Panes > Freeze Top Row. To freeze both the top row and the first column, click cell B2 and choose View > Freeze Panes > Freeze Panes; everything above and to the left of the selected cell stays fixed.

View > Split divides the window into separately scrolling areas, which is handy for comparing row 10 with row 900 on the same sheet. To view two different sheets side by side, use View > New Window, then View > Arrange All.

Linking data between worksheets

To use a value from another sheet, type =, click the other sheet's tab, click the cell and press Enter. Excel writes a reference like this:

='Jan Sales'!B12

The apostrophes are needed when a sheet name contains spaces. To add up the same cell across a run of sheets, use a 3D reference. If you have sheets named Jan, Feb and Mar next to each other, this formula totals cell B12 on all three:

=SUM(Jan:Mar!B12)

Tip: Any sheet you later move between Jan and Mar is automatically included in the 3D total, and a sheet moved outside them is dropped.

Editing several sheets at once (grouping)

If every monthly sheet has the same layout, you can format or type into all of them in one go. Hold Ctrl and click each tab, or click the first tab and Shift-click the last. The title bar shows [Group]. Anything you do now happens on every selected sheet. Right-click a tab and choose Ungroup Sheets when you are finished.

Watch out: Forgetting to ungroup is a common way to overwrite data on several sheets by accident. Always check for [Group] in the title bar.

Protecting a worksheet

Select the cells people should be able to edit, press Ctrl + 1, open the Protection tab and untick Locked.
Go to Review > Protect Sheet, choose what users may do and, optionally, enter a password.
Click OK. Locked cells can now be viewed but not changed.

To stop people adding, deleting or renaming sheets, use Review > Protect Workbook as well.

Start faster with templates

A template is a ready-made workbook with layout, formatting and formulas already in place. Choose File > New to browse Microsoft's templates for budgets, invoices and planners. To make your own, build a clean workbook, then choose File > Save As and pick Excel Template (*.xltx). Each time you open it, Excel creates a fresh copy, so the original stays clean.

Summary

Give every sheet a short, meaningful name and a consistent tab colour.
Use Freeze Panes so headings stay visible.
Link sheets with references like ='Jan Sales'!B12 and total across sheets with =SUM(Jan:Mar!B12).
Group sheets to edit identical layouts at once, and remember to ungroup.
Protect sheets that other people will fill in.

Next: learn how to enter and clean up information in Excel Data.