An Excel workbook is the complete spreadsheet file: it contains one or more sheets, and each worksheet organizes data in a grid of rows and columns. Cells hold values, formulas, or formatting, while workbook-level features such as names, links, and protection apply across or between sheets.
What an Excel workbook is
Workbook is Excel’s name for the file you open and save. A worksheet is one grid inside that file. For example, a workbook for a small shop might include a Sales worksheet, an Inventory worksheet, and a Summary worksheet. Each can serve a different purpose while remaining part of the same file.
This distinction matters when people say they are opening a spreadsheet: they may mean the workbook file or one worksheet within it. The sheet tabs along the bottom of an Excel window let you switch between worksheets. A workbook can also contain chart sheets, which display a chart on its own sheet rather than showing a cell grid.
In Microsoft 365 for Windows, a new blank workbook usually starts with one worksheet. You can add more with the plus button beside the sheet tabs. The number of sheets a workbook can hold is limited by available computer memory, rather than by a small fixed worksheet count, although a very large workbook may become difficult to use or slow to calculate.
How workbook files are stored
The common modern Excel format is .xlsx. Technically, an .xlsx file is a package of related components, including XML files that describe workbook settings, worksheets, styles, and other content. The package uses relationships to connect its parts. Excel presents this complexity as one file, so most users do not need to inspect those internal components.
Other formats serve different purposes. The .xlsm format can store VBA macros, while .xlsb stores workbook content in a binary format and may be useful for some large or performance-sensitive files. The older .xls format is intended for compatibility with earlier Excel versions and has more restrictive worksheet dimensions. Saving in a format that does not support a feature can remove or change that feature, so Excel may warn you when converting.
- .xlsx: A standard workbook format that does not store VBA macro code.
- .xlsm: A macro-enabled workbook format for files that contain VBA.
- .xlsb: A binary workbook format that supports many of the same workbook features.
- .csv: A text format for tabular data, not a full workbook. It generally saves the active sheet’s data and does not preserve workbook features such as multiple sheets, formulas as formulas, or formatting.
Worksheets, sheet tabs, and their roles
Each worksheet has a grid with 1,048,576 rows and 16,384 columns in current Excel versions. Columns run from A through Z, then AA and onward to XFD. A sheet can be renamed, moved, copied, hidden, or deleted. Its tab color can also help distinguish categories such as input data, calculations, and reports.
Sheet names are useful labels, not just decoration. Names such as Raw Data, Monthly Summary, and Lookup Values tell a reader what to expect. Excel restricts certain characters in sheet names, limits their length to 31 characters, and does not allow two sheets in the same workbook to have identical names. A clear naming pattern is especially helpful when formulas refer to other sheets.
Sheet order affects navigation and presentation, but it does not by itself determine how formulas calculate. For example, a Summary sheet can appear first even when its figures depend on data stored in later tabs. Grouping related sheets and keeping a consistent order helps people find the relevant material without changing the calculations.
Cells, ranges, and the grid
A cell is the intersection of a row and a column. Its address combines the column letter and row number: B3 means column B, row 3. A range is a group of cells, often written with a colon between its first and last addresses, such as B2:D10. The active cell is the cell currently selected, and its address normally appears in the Name Box near the formula bar.
A cell may contain a number, text, a date or time, a formula, or be blank. Formatting controls how a value appears: a stored number might be displayed as a percentage, currency, date, or decimal. Formatting generally does not change the underlying value. For instance, displaying 0.25 as 25% changes its presentation, not the stored number.
Rows and columns can be inserted, deleted, resized, hidden, or unhidden. Merged cells combine a visible area, but they can complicate sorting, filtering, and selecting data. For rectangular datasets, it is usually more reliable to use one header row and consistent columns than to create elaborate merged headings inside the data.
Formulas and connections between sheets
Formulas are expressions that calculate results from cell values. A cell can refer to another cell on the same sheet or to a cell on a different sheet. For example, with a unit price of 12 in B2 and a quantity of 5 in C2 on a worksheet, the formula =B2*C2 in D2 returns 60. The formula is stored in D2; the displayed result is calculated from the referenced inputs.
A formula can refer to another sheet by including its name and an exclamation point, as in =Sales!D2. If a sheet name contains spaces, Excel surrounds it with single quotation marks in the reference, for example ='Monthly Sales'!D2. When you rename a sheet through Excel, references are normally adjusted automatically. Moving or deleting cells, sheets, or source files can still change or break references.
Formulas can create dependencies: a summary cell may rely on totals, which in turn rely on individual entries. Excel recalculates formulas when relevant inputs change, subject to the workbook’s calculation settings. This is why a workbook with many linked calculations can behave differently from a static report containing only pasted values.
Workbook-level features beyond the cell grid
Several features add structure without creating another worksheet. Excel tables turn a rectangular data range into a named object with header filters and consistent formatting. Tables can expand as new rows are added, and formulas can refer to table columns by name. This is often easier to maintain than relying on fixed cell ranges when records are appended over time.
Defined names give a cell or range a readable label, such as TaxRate or ProductList. Names can be scoped to the whole workbook or, in some cases, to an individual worksheet. They can make formulas easier to interpret, but old names that refer to deleted cells can become confusing and should be reviewed when maintaining a workbook.
Charts, PivotTables, data validation rules, conditional formatting, comments or notes, and external links may also be stored in a workbook. These features do not all behave like ordinary cell values. A chart can draw from a range, a validation rule can restrict what someone enters, and a link can depend on another file being available. When troubleshooting, consider both the visible grid and the workbook features attached to it.
How to organize a workbook that stays understandable
A useful structure separates raw records, calculations, and presentation where that makes the file easier to inspect. It need not mean creating a separate sheet for every small task. A compact workbook might have one table of transactions and one summary sheet; a larger operational file might use additional sheets for reference lists or monthly reports.
- Use clear, stable sheet names and put the most frequently used or reader-facing sheet near the beginning.
- Keep each dataset rectangular, with one header row, one record per row, and one type of information per column.
- Use Excel tables for lists that will grow, and avoid blank rows or columns inside the table’s data area.
- Separate user-entered values from calculated outputs visually or by location, and label units such as dollars, hours, or units sold.
- Use formulas consistently instead of typing over calculated results. Document unusual assumptions close to the relevant input or calculation.
- Remove obsolete sheets, broken links, and unused names when it is safe to do so; retain an archived copy when the workbook’s history matters.
For example, an order-tracking workbook could store one order per row in a table on an Orders sheet, keep allowed status labels on a Lists sheet, and show totals or trends on a Summary sheet. This arrangement makes the underlying records easier to filter while keeping the overview separate. If several people will edit the file, clear labels and a short note explaining where to enter new records can prevent accidental changes to formulas.
Protection, sharing, and safe editing
Excel has different kinds of protection, and they solve different problems. Worksheet protection can restrict actions such as editing locked cells, but it should not be treated as strong encryption or as a guarantee that information is confidential. Workbook structure protection can restrict sheet-level actions such as adding, deleting, moving, hiding, or renaming sheets. File encryption with a password is a separate option for limiting access to the workbook.
In Excel for Microsoft 365 on Windows, worksheet and workbook protection controls are on the Review tab. Before protecting a sheet, decide which cells users should be able to edit; cells are commonly locked by default, and protection makes that setting effective. Protection can help prevent accidental edits, but it does not replace a backup or careful access control. For collaborative editing, store the file in a supported cloud location and use Excel’s sharing features rather than passing around multiple conflicting copies.
Before making structural changes to an important workbook, save a copy. This is particularly sensible before deleting sheets, replacing formulas with values, changing file formats, or removing links. Version history may be available when a file is stored in OneDrive or SharePoint, but its availability depends on the storage and account setup.
Common workbook structure problems
Many apparent formula errors originate in the workbook’s structure or assumptions. A reference may point to the wrong sheet, a new record may sit outside a range used by a summary, or a column may contain a mixture of numbers and text. A date that looks correct may be stored as text, which can interfere with sorting and calculations. Checking the actual cell contents and the formula bar often reveals more than looking at the displayed formatting alone.
Other frequent issues include hidden sheets that contain important inputs, duplicated versions of a dataset, external links to files that have moved, and blank rows that interrupt a table or selection. Filters can also make rows appear missing when they are simply hidden by the current filter. If a workbook is slow, large formulas, extensive formatting applied to unused cells, volatile calculations, or many external connections may contribute; the cause depends on the particular file.
When you inherit a workbook, start by identifying its sheets and their purpose. Then inspect the main data ranges, formulas, names, and links before editing. Unhide sheets only when appropriate, check filters, and trace a few key totals back to their source records. This cautious review helps distinguish an intentional design choice from an accidental error.
Frequently Asked Questions
What is the difference between an Excel workbook and a worksheet?
A workbook is the complete Excel file. A worksheet is one sheet, usually a grid of cells, inside that file. A workbook can contain multiple worksheets and other elements such as chart sheets.
How many sheets can an Excel workbook have?
There is no small fixed sheet limit for current Excel workbooks; the practical limit depends on available memory and workbook complexity. A workbook with many sheets can still become cumbersome or slow even if Excel can open it.
What is the difference between .xlsx and .xlsm?
Both are modern Excel workbook formats, but .xlsm supports saving VBA macro code and .xlsx does not. Use the macro-enabled format when a workbook needs to retain VBA, and only enable macros from sources you trust.
Does a CSV file keep the workbook structure?
No. CSV is a plain-text format for tabular data, not a complete Excel workbook. It does not preserve multiple worksheets, most formatting, charts, or workbook features; export typically saves the active sheet’s data.
How do I add or rename a worksheet?
In Excel for Microsoft 365 on Windows, select the plus button beside the sheet tabs to add a sheet. Double-click a tab to rename it, type the new name, and press Enter. The same basic sheet-tab actions are available in Excel for Mac, though ribbon layout and keyboard shortcuts can differ.
Related
- Data Validation Greyed Out in Excel? Causes and Fixes
- Excel Data Validation Guidelines for Reliable Spreadsheets
- Excel Data Validation From Another Workbook: Best Methods
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Scatter Plot: Color Points by Value AutomaticallyExcel can color scatter-plot points by value, but an XY scatter chart does not automatically apply a continuous…
- Google Sheets IMPORTRANGE: Setup, Uses, and Common FixesGoogle Sheets’ IMPORTRANGE function brings a cell range from one spreadsheet into another and keeps the imported results…
- Excel Data Table Relationships and How to Create ThemIn Excel, table relationships link separate tables through matching key columns, letting PivotTables and the Data Model analyze…
- How to Insert a Table of Contents in Word for the WebTo insert a table of contents in Word for the web, first format your section titles with built-in…
- How to Keep Track of Bills in ExcelTo keep track of bills in Excel, create a list with one row per bill due, record its…
- How to Freeze Selected Rows in Excel While You ScrollTo freeze selected rows in Excel, click the cell in column A immediately below the last row you…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.