Excel Basics · ~3 min read

Excel Workbooks, Worksheets and Cells Explained

What a workbook, a worksheet and a cell are, how cell addresses work, and how to add, rename and switch sheets.

Video link coming soon
What you will learn

Step by step

1. Intro

Welcome back. In this lesson, you will learn three words that Excel uses everywhere: workbook, worksheet and cell.

You will also learn how to add, rename and switch between sheets, and how to jump to any cell in a second.

Excel Workbooks, Worksheets and Cells Explained: Intro
Intro

2. What is a workbook

A workbook is the whole Excel file. When you save your work, you save a workbook, and its name appears in the title bar.

Think of a workbook as a binder. It can hold many pages, and each page is called a worksheet.

Excel Workbooks, Worksheets and Cells Explained: What is a workbook
What is a workbook

3. Worksheets

The worksheets of the workbook are listed as tabs at the bottom of the window. Right now we have just one, called Sheet1.

To add a new worksheet, click the plus button. You can also press Shift and F11, which does the same thing.

Now we have two sheets, and the new one is active. To rename it, press Alt, then H, O and R.

Type the new name, Budget, and press Enter. Double-clicking the tab works too.

To switch sheets, click a tab, or press Control and Page Up and Page Down. Let's go back to the first sheet.

Rename this one as well. Alt, H, O, R, then type Sales and press Enter.

Good worksheet names make a big workbook much easier to understand.

Excel Workbooks, Worksheets and Cells Explained: Worksheets
Worksheets

4. Cells and addresses

Now let's look inside a worksheet. It is a huge grid of cells, and every cell has an address made of its column letter and row number.

Click this cell. Its address, D5, appears in the Name Box.

The Name Box also works as a teleport. Click it, type an address such as H20, and press Enter.

Excel jumped straight to H20. This is the fastest way to reach a faraway cell.

How big is a worksheet? Press Control and the right arrow key to find out.

Excel has sixteen thousand, three hundred and eighty-four columns. The last one is called X F D.

Now Control and the down arrow. Excel has more than one million rows.

Press Control and Home to return to the top-left corner at any time.

Excel Workbooks, Worksheets and Cells Explained: Cells and addresses
Cells and addresses

5. Ranges

A group of cells is called a range. Drag from A2 to C4, and the range is selected.

Its address is written with a colon: A2, colon, C4. You will see ranges again and again in formulas.

Excel Workbooks, Worksheets and Cells Explained: Ranges
Ranges

6. Moving around data

Real worksheets hold data, so let's practice moving around a table of sales. Click A1, the first cell.

Press Control and the down arrow. Excel jumps to the last row of the data, instead of the bottom of the sheet.

Click A1 again and press Control and the right arrow. Now you jump to the last column of the data.

Add Shift, and you select while you jump. Control, Shift and the down arrow selects the column down to the last entry.

Control, Shift and the left arrow extends the selection across all the columns of the table.

A shortcut for the whole table: click any cell inside it, and press Control and A.

The Home key jumps to the start of the row, and Page Down moves one screen down. Control and Home takes you back to A1.

Addresses are not case-sensitive. Click the Name Box, type a lowercase d five, and press Enter.

Every cell can hold three kinds of content: text, numbers, and formulas. We will meet all three in the next lessons.

How many sheets should a workbook have? As many as you need. A good habit is one sheet per topic, such as one per month or one per department.

Excel Workbooks, Worksheets and Cells Explained: Moving around data
Moving around data

7. Recap

Click once to deselect. Let's recap what we learned.

A workbook is the Excel file. A worksheet is one page inside it. A cell is one box on a worksheet, and a range is a group of cells.

Add a sheet with the plus button, switch with Control Page Up and Page Down, and rename with Alt, H, O, R.

Use the Name Box to jump to any address, and Control with the arrow keys to move across the data.

Next time, you will learn how to type and edit data in cells.

Thanks for watching, and see you in the next lesson.

Excel Workbooks, Worksheets and Cells Explained: Recap
Recap
What do you want to learn next? Tell us in the comments on YouTube: your requests decide the next tutorials.

← Previous tutorial: Excel Screen Tour for Beginners (Ribbon, Cells, Formula Bar)
Next tutorial: How to Enter and Edit Data in Excel (Beginner Tutorial) →