Excel Worksheets and Workbooks

In Excel, every file is called a workbook. Inside a workbook, there are one or more worksheets. Understanding the difference between these two terms and knowing how to manage them is essential for keeping data organized, especially when working on larger projects.

What is a Workbook?

A workbook is the entire Excel file. It is saved as a single file with the .xlsx extension (or .xls for older versions). Think of it like a binder — the binder itself is the workbook, and the individual pages inside are the worksheets.

Saving a Workbook

• Press Ctrl + S to save.
• Press Ctrl + Shift + S or go to File → Save As to save with a new name or location.
• The file can be saved in different formats: .xlsx (default), .xls (older), .csv (plain text data), .pdf (for sharing).

Opening a Workbook

• Press Ctrl + O to open an existing file.
• Go to File → Open to browse for a file.

Creating a New Workbook

• Press Ctrl + N to create a blank new workbook.
• Go to File → New to choose from templates.

What is a Worksheet?

A worksheet (also called a sheet or tab) is a single spreadsheet within a workbook. It has its own rows, columns, and cells. By default, a new workbook opens with one worksheet named Sheet1.

Worksheets are useful for organizing related data. For example, a monthly budget workbook might have a separate sheet for each month: January, February, March, and so on.

Managing Worksheet Tabs

The worksheet tabs appear at the bottom of the Excel window. Each tab represents one sheet.

Adding a New Worksheet

• Click the + (plus) icon to the right of the last tab.
• Or right-click any tab and select Insert → Worksheet.
• Keyboard shortcut: Shift + F11.

Renaming a Worksheet

1. Double-click the sheet tab at the bottom.
2. The name becomes editable — type the new name.
3. Press Enter to confirm.

Good naming conventions make navigation easier. For example: "Jan Sales", "Feb Sales", "Summary".

Deleting a Worksheet

1. Right-click the sheet tab.
2. Select Delete.
3. Confirm the deletion in the warning dialog.

Warning: Deleting a sheet is permanent and cannot be undone with Ctrl + Z.

Moving or Copying a Worksheet

1. Right-click the tab.
2. Select Move or Copy.
3. Choose the position and check Create a Copy if a copy is needed.

Alternatively, click and drag a tab to move it to a new position.

Changing the Tab Color

1. Right-click the sheet tab.
2. Select Tab Color and choose a color.

Color-coding tabs makes it easy to identify different types of sheets at a glance.

Hiding and Unhiding a Worksheet

• Right-click the tab → Hide. The sheet disappears from the tab bar but data is preserved.
• To unhide: Right-click any visible tab → Unhide → select the hidden sheet.

Switching Between Worksheets

• Click any tab to switch to that sheet.
• Use Ctrl + Page Down to move to the next sheet.
• Use Ctrl + Page Up to move to the previous sheet.

Referencing Cells Across Worksheets

Data from one worksheet can be used in a formula on another worksheet. This is called a cross-sheet reference.

Syntax

  =SheetName!CellAddress

Example

  Two sheets: "January" and "Summary"

  In the Summary sheet, to reference cell B2 from the January sheet:
  =January!B2

  If the sheet name has spaces:
  ='Jan Sales'!B2   (use single quotes when the name has spaces)

Practical Use

  Summary sheet cell B2: =January!B10 + February!B10 + March!B10
  → Adds up the totals from each monthly sheet into one summary figure.

Grouping Worksheets

Multiple sheets can be grouped so that data or formatting entered on one sheet applies to all grouped sheets simultaneously.

How to Group Sheets

1. Click the first sheet tab.
2. Hold Shift and click the last sheet tab to group consecutive sheets.
3. Hold Ctrl and click individual tabs to group non-consecutive sheets.

When sheets are grouped, "[Group]" appears in the title bar. Any changes made will apply to all sheets in the group.

Ungrouping Sheets

Right-click any tab in the group and select Ungroup Sheets, or simply click on a tab that is not part of the group.

Practical Example: Monthly Sales Workbook

  Workbook: "AnnualSales.xlsx"

  Sheets:
  - January   → Sales data for January
  - February  → Sales data for February
  - March     → Sales data for March
  - Summary   → =January!B10 + February!B10 + March!B10

  The Summary sheet pulls totals from each monthly sheet
  to create an annual overview without duplicating data.

Summary

• A workbook is the entire Excel file (.xlsx); a worksheet is a single sheet within that file.
• Sheets can be added, renamed, deleted, moved, copied, colored, hidden, and unhidden.
• Cross-sheet references use the syntax =SheetName!CellAddress to pull data from another sheet.
• Grouping sheets allows the same data or formatting to be applied to multiple sheets at once.
• Organizing data across multiple sheets keeps workbooks clean and manageable.