Excel Basics: The Ribbon, Cells, and Saving
Every Excel career starts in the same place: a blank grid, a strange ribbon of buttons, and a save dialog that seems to have too many options. This lesson slows down and names every piece of the Excel window so you stop guessing and start working with confidence. By the end you'll be able to open Excel, enter data cleanly, and save it in the format your employer actually needs.
Why this skill matters professionally
Job postings for admin assistants, bookkeepers, coordinators, and analysts almost universally list 'proficient in Excel' as a requirement, even for roles that barely touch finance. Hiring managers use it as shorthand for 'can this person organize data without hand-holding.' Getting comfortable with the interface — instead of clicking around nervously — is what separates someone who looks confident in an interview skills test from someone who freezes. Most workplace Excel disasters (lost work, overwritten files, data saved in the wrong format so a system can't import it) trace back to not understanding the basics covered here. A new hire who can save a .csv correctly on day one, without asking, immediately looks more capable than their resume claims.
Learning objectives
- Identify the Ribbon, Formula Bar, Name Box, and status bar.
- Enter, edit, and delete data in cells.
- Save a workbook using both .xlsx and .csv formats.
Background concepts
What a workbook actually is
An Excel file is called a 'workbook.' Inside a workbook you can have multiple 'worksheets' (the tabs at the bottom), and each worksheet is a grid of cells. Think of a workbook like a three-ring binder and each worksheet like one page in it — related data can live on separate pages without cluttering a single view.
The Ribbon
The Ribbon is the toolbar strip across the top of the window, organized into tabs. Each tab groups related commands so you're not hunting through endless menus.
- Home — fonts, colors, alignment, number formats, sort & filter, find & replace
- Insert — charts, tables, PivotTables, images
- Page Layout — margins, print area, themes
- Formulas — function library, name manager, formula auditing
- Data — sorting, filtering, data validation, text-to-columns
- Review — spell check, comments, protect sheet
- View — freeze panes, gridlines, zoom
Cell addresses
Every cell is named by its column letter and row number, like B4 or AA112. The Name Box at the top-left always shows the address of whatever cell is currently selected — this is your compass in a large spreadsheet.
The Formula Bar
Directly above the grid sits the Formula Bar. It shows exactly what's stored in the selected cell — the raw formula, not just the displayed result. If a cell shows '$450' but the Formula Bar shows '=B2*1.1', you know it's a calculation, not a typed number.
Step-by-step
1. 1. Open Excel and create a new workbook
Launch Excel and choose 'Blank workbook.' You'll land on Sheet1 with cell A1 already selected (it has a bold border).
2. 2. Click a cell to select it
Click any cell — its address appears in the Name Box, and its border thickens. This is the 'active cell,' the one that receives anything you type.
3. 3. Type data and confirm it
Type a value, then press Enter to move down one row, Tab to move right one column, or Esc to cancel the entry entirely without saving it.
4. 4. Edit an existing cell
Double-click a cell to edit its contents in place (a cursor appears inside the cell), or single-click it and edit directly in the Formula Bar. Press F2 as a keyboard shortcut to jump straight into edit mode.
5. 5. Delete contents vs. delete the cell
Pressing Delete clears the contents but leaves the cell in place. Right-click and choose 'Delete...' to actually remove the cell and shift neighboring cells to fill the gap — these are very different operations.
6. 6. Navigate with the keyboard
Arrow keys move one cell at a time. Ctrl+Arrow jumps to the edge of a block of data. Ctrl+Home returns to A1. Ctrl+End jumps to the last used cell in the sheet.
7. 7. Rename and add worksheet tabs
Double-click a sheet tab at the bottom to rename it (e.g. 'Sheet1' to 'Budget'). Click the + icon next to the tabs to add a new sheet.
8. 8. Save as .xlsx
Press Ctrl+S (Cmd+S on Mac). The first time, choose a location and file name, and keep the default file type: Excel Workbook (*.xlsx). This preserves formulas, formatting, multiple sheets, and charts.
9. 9. Save as .csv when required
Use File > Save As, then choose 'CSV (Comma delimited)' from the file type dropdown. CSV strips out formulas, formatting, and extra sheets — it keeps only raw values, one sheet at a time. Many import systems (payroll platforms, CRMs, accounting software) require CSV uploads.
10. 10. Recognize AutoSave and version history
If your file is stored in OneDrive or SharePoint, Excel may AutoSave continuously. Use File > Info > Version History to recover an earlier version if you or a colleague makes an unwanted change.
Illustration
A B C 1 Name Email Balance 2 Ana Diaz ana@x.com 1250.00 3 Ben Ito ben@x.com 980.50
Real-world workplace examples
Front desk log sheet
An office receptionist keeps a simple workbook with visitor name, time in, and time out. Understanding cell entry and saving reliably means the log never gets lost between shifts.
Exporting to a payroll system
A small-business owner builds a timesheet in Excel, then saves a CSV copy specifically for uploading to their payroll provider, because the provider's importer rejects .xlsx files.
Multiple sheets, one file
A property manager uses one workbook with a tab per building, keeping rent rolls organized without juggling a dozen separate files.
Recovering unsaved work
A new hire's laptop restarts unexpectedly. Because Excel's AutoRecover was on, they reopen Excel and are prompted to restore the unsaved version — a save habit that pays off instantly.
Practical scenarios
The vanished formatting
Maria built a color-coded expense tracker in Excel with bold headers and currency formatting, then saved it as a .csv to email a coworker who 'just wanted the numbers.' When she reopened her own .csv later expecting the same file, all the color and formulas were gone — CSV only stores raw values. The fix: keep a master .xlsx for working files, and only export a .csv copy at the moment it's needed, never overwrite the original.
Two people, one file, no plan
A team stored a shared inventory workbook on a desktop folder and emailed it back and forth. Edits kept getting overwritten because nobody knew who had the newest version. Once they understood workbooks and version tracking, they moved the file to OneDrive, which let multiple people see live edits and roll back mistakes using version history — solving the conflict entirely.
Common mistakes beginners make
Saving as .xls instead of .xlsx
Older file format that lacks modern features and can trigger compatibility warnings. Always default to .xlsx unless a system specifically requires the old format.
Typing over a formula by accident
Clicking a cell that displays a calculated number and typing a new value overwrites the formula permanently. Check the Formula Bar before typing into any cell that looks like a result.
Never saving until the very end
Get in the habit of Ctrl+S every few minutes, or confirm AutoSave is on. Power outages and crashes don't wait for a convenient time.
Confusing Delete and right-click Delete
Pressing the Delete key only clears content. Choosing 'Delete...' from the right-click menu removes the cell itself and shifts data — using the wrong one can silently shuffle an entire table.
Not naming worksheet tabs
Leaving tabs as 'Sheet1,' 'Sheet2,' 'Sheet3' in a multi-tab workbook forces everyone to click through blindly. Rename tabs the moment you create them.
Best practices
- Save your working file as .xlsx and only export to .csv or .pdf when a specific system needs it.
- Rename Sheet1 to something descriptive the moment you start a new tab.
- Use Ctrl+S constantly, or confirm AutoSave is enabled via OneDrive/SharePoint.
- Check the Formula Bar, not just the displayed value, before editing any cell.
- Keep raw source data on one tab and calculations/summaries on another.
- Use Ctrl+Z immediately if something looks wrong — don't just retype over it.
- Freeze the top row (View > Freeze Panes) as soon as a sheet gets long enough to scroll.
- Close files properly (Ctrl+W or File > Close) rather than force-quitting the whole application.
Professional tips
- Right-click any sheet tab and choose 'Move or Copy' with 'Create a copy' checked to safely duplicate a template without touching the original.
- Ctrl+` (backtick) toggles between showing values and showing all formulas at once — a fast way to audit a sheet.
- You can rename a workbook file itself (not just tabs) from within Excel using File > Save As without closing your session.
- Hold Ctrl while dragging a sheet tab to duplicate it instantly instead of using the menu.
- Pin frequently used workbooks in File > Open > Recent so you never dig through folders.
Practice exercises
Interface labeling
Open a blank workbook and, without looking anything up, point to and name the Ribbon, Name Box, Formula Bar, sheet tabs, and status bar.
Enter and edit a mini table
Type a 5-row, 3-column table of made-up product names, quantities, and prices. Then use F2 to edit one entry and Delete to clear another.
Dual save drill
Save your practice table once as .xlsx and once as .csv into the same folder, then reopen both and note exactly what's different.
Tab management
Add two more sheet tabs, rename them 'Q1' and 'Q2', and reorder them by dragging.
Review questions
What is the difference between a workbook and a worksheet?
A workbook is the entire file; a worksheet is one page/tab inside that file. A workbook can contain many worksheets.
How do you tell whether a cell contains a formula or a typed value?
Select the cell and look at the Formula Bar — it shows the real contents, including any formula, even if the cell displays a plain number.
Why would you save a file as .csv instead of .xlsx?
When another system (payroll, CRM, database import tool) only accepts plain comma-separated values without formatting or formulas.
What happens if you press Delete on a cell versus right-click and choose Delete?
Delete key clears the contents only, leaving the cell in place. Right-click Delete removes the cell entirely and shifts surrounding cells to fill the space.
What does the Name Box show?
The address of the currently active cell, and it can also be typed into to jump directly to any cell.
Key takeaways
- A workbook can hold many worksheets; know the difference.
- The Ribbon groups related tools under tabs — Home is used most.
- The Formula Bar reveals what's really stored in a cell.
- Save as .xlsx for working files, .csv only for system imports.
- Ctrl+S often; confirm AutoSave when working in OneDrive/SharePoint.
- Delete key clears content; right-click Delete removes the cell structurally.
- Rename sheet tabs immediately for clarity.
Frequently asked questions
Do I need Excel installed, or can I use it online?
Excel Online (part of Microsoft 365 in a browser) covers most basics in this lesson and autosaves automatically, though some advanced features are desktop-only.
What's the difference between .xlsx and the older .xls?
.xlsx is the modern XML-based format with better performance and features; .xls is a legacy format from Excel 2003 and earlier.
Can I recover a file I closed without saving?
Reopen Excel and check File > Info > Manage Workbook, or File > Open > Recent > Recover Unsaved Workbooks — AutoRecover often has a copy.
Is Google Sheets the same as Excel?
Similar concepts and many identical functions, but the interface, some shortcuts, and file formats differ. Skills transfer well but aren't identical.
What is the status bar at the bottom used for?
It shows quick stats (like the sum or average of a selected range) and lets you switch views and zoom level.
Why does my saved CSV look different when I reopen it in Excel?
CSV stores plain text only; Excel reapplies default formatting when it opens the file, which can look different from your original styled version.
Related lessons
15 min • Easy
20 min • Intermediate
20 min • Advanced
15 min • Beginner