Workbook, sheet and saving · Kode bersama Martin

Three words, so we understand each other

People say “Excel” for everything. We will be precise. Otherwise you get lost in a month.

Workbook = the whole file. Like a notebook in a bag. In Sheets it is the whole page in the browser. In Excel on a computer it is an .xlsx file.
Sheet = one tab at the bottom. In one workbook you can have more of them. Like pages in a paper notebook — they do not tear out, they switch.
Cell = one box. For example B3. You will learn the address in Cell kid. For now: a box has a name.

At the bottom you will see Sheet1. That is the first sheet. The workbook is the whole page including all the tabs. When you add a second sheet, it is still one workbook. Not two files.

Think of it as a book. Workbook = the book. Sheet = a chapter. Cell = one word on the page. When you close the book, the chapters stay inside.

💡

In Excel on a computer the workbook is sometimes called workbook and the sheet sheet. In Sheets it is the same idea. When a teacher says “open the sheet”, they mean the tab at the bottom.

What you will see at the bottom and at the top

Open the workbook from last time (sheets.new or from Drive).

At the bottom is the tab bar. The grey tab Sheet1 is active. Next to it is a small plus. In Excel on a computer the plus is at the bottom too, sometimes it looks like + at the end of the tabs.

Top left is the workbook name. In Sheets it often says Untitled spreadsheet. That is the name of the file, not the name of the sheet. They are two different labels.

When you rename the sheet to Grades, the workbook can still be called Untitled. And the other way: workbook Tables with Martin can have sheets Grades and Catatans inside.

Rename and add

Now we tidy the workbook so we can live in it for the whole course.

At the bottom double-click Sheet1. The text is selected. Type Grades. A hook in the sheet name is fine (Známky), but without special letters it is easier to find later when you write formulas between sheets. Enter. The tab is renamed.
Look down. Sheet1 is gone. There is Grades. Click next to it on the grid — the tab stays. Renaming does not delete the sheet. It only gives it a label.
Next to the tabs is a plus. Click it. A second sheet appears. In Sheets it is often called Sheet2. In Excel also Sheet2.
Double-click the new tab. Rename it to Catatans. Enter.
Click Grades again. The grid switches. What you typed on the first sheet (for example a name in A1) is still there. Sheets do not overwrite each other — they only switch. It is like two sides of a notebook, not an eraser.

⚠️

Watch the right mouse button. When you right-click a tab and choose Delete, the sheet disappears with its cells. Plus adds. The bin deletes. If you delete by mistake, in Sheets try Ctrl+Z right away (Mac: Cmd+Z). In Excel too.

Workbook name — so you can find it

The workbook name is top left. In Sheets click Untitled spreadsheet and type Tables with Martin. Enter. Drive will then find it by name, not by “Spreadsheet 17”.

In Excel on a computer it is different: File → Save as. You pick a folder and type a name. The .xlsx ending is added itself. Save again = Ctrl+S (Mac: Cmd+S). Excel does not save itself to Drive until you have OneDrive.

Click the workbook name top left.
Type exactly Tables with Martin. No typo. When you have more workbooks, you will know this one.
Enter. The name at the top changes. For a moment it says “Saving…”, then saved again.

💡

On Google Drive (drive.google.com) you will see the workbook as a spreadsheet icon. When you look for it, type Tables with Martin in the search. A school computer without your account does not see that file — it lives on the account, not on the desktop.

Where it hides

In Google Sheets the workbook lives on the Google Drive of the account you are signed into. It is not a file on the desktop until you download it (File → Download → Excel or PDF). Downloading comes later. For now leave it on Drive.

At home you open the same address, sign in with the same account — the workbook is there. Both sheets too.

In desktop Excel it is a file in a folder: Documents, Desktop, USB… If you do not save the file and you switch the computer off, the work is gone. Sheets does not have that trap, if you are signed in.

⚠️

When you open the workbook on a school computer and you are not signed into your account, after sign-out you may not find it. Maybe you are in the teacher’s account or as a “guest”. At home and at school: the same account, which a parent or a teacher watches. The next lesson is about the password.

🏫 Grade average — its own sheet

Sheet Grades is the start of the project. Do not put a formula here yet. It is enough to know that grades will not be on the same sheet as notes.

Why two sheets? When you try filling and silly number series, do it on Catatans. Leave sheet Grades clean. Otherwise in a week you will not know which 3 is a grade and which is a try.

Now you 💪

You have two sheets and a named workbook. Now type something into cells, so you see that the sheets do not mix.

Click the Grades tab. In A1 type Subject. Enter. (If a name from last time is still there, delete it and type Subject.)
Click the Catatans tab. In A1 type Things to remember. Enter.
Go back to Grades. In A1 there must be Subject, not the sentence from the second sheet.
Check the workbook name top left: Tables with Martin, not “Untitled”.
Check at the bottom: two tabs, two names. No Sheet1.

If you see the same thing in A1 on both sheets, you keep clicking the same tab. The tab you are on is lighter. Click the other one.

✅

Check: At the bottom two tabs named Grades and Catatans. At the top the workbook has a name, not “Untitled”. On each sheet A1 has different text.

What to take from this lesson

Workbook = file. Sheet = tab. Cell = box. They are three different things.
Plus adds a sheet. Double-click renames it. Sheets switch, they do not overwrite.
The workbook name is at the top. The sheet name is at the bottom. Nama both, so you find it in a week.
Sheets saves itself to the account Drive. Excel on a computer you save yourself (Ctrl+S / Cmd+S).
The same account at home and at school. Otherwise the workbook “disappears”.