Excel Workbook vs Worksheet: A Deep Dive

Most guides treat opening Excel like it's the hard part. It isn't. The part that actually trips people up is what happens after the app loads: the blank screen, the unfamiliar interface, the quiet panic of not knowing what to click first. If you've ever closed Excel within 30 seconds of opening it, that's what this is about.

This guide walks you through launching Excel, creating and naming a new workbook, saving it correctly, and opening an existing file, including what to do when Compatibility Mode shows up uninvited. I've been opening Excel every workday as a data analyst since 2017, and I tested every step here on both Windows 11 (Dell Inspiron 15) and a MacBook Air M1, both running Microsoft 365. If your screen looks slightly different from what I describe, that's normal. Microsoft updates the interface on a rolling basis without much announcement.

---

What You'll Be Able to Do (and What to Have Ready Before You Open an Excel Workbook)

By the end of this, you'll know how to launch Excel, create a new workbook, save it with a real name, and open a file you've already got sitting somewhere. That's the whole scope. No VBA, no advanced features, just your first productive five minutes.

Before we get there, you need one of three things: Microsoft 365 (subscription-based, what most people have in 2026), a standalone Excel license, or access to Excel for the web via Microsoft 365 online.

Excel for the web and desktop Excel are not the same product. The web version runs in your browser through OneDrive and handles most basic tasks fine, but named ranges, certain formatting behaviors, and some features don't carry over. If you're doing anything beyond simple lists and numbers, the desktop app is what you want. I'll flag the differences as we go.

If you're newer to spreadsheets and want broader context first, the Excel for Beginners starter guide is a good place to start before coming back here.

---

Step 1: Launch Excel and Open a New Workbook

Finding Excel on Your Device

On Windows, press the Start button and type Excel. It'll appear in the search results almost immediately. Click it. On a Mac, open Launchpad and look for the green Excel icon, or search for it with Spotlight (Cmd+Space, then type "Excel").

Excel opens to a Start Screen. A lot of first-timers get stuck here because they expect to land directly in a spreadsheet. You won't. The Start Screen shows your recent files on the left and a grid of templates in the center. Don't get distracted by the templates.

Using the File Menu to Start Fresh

1. From the Start Screen, click Blank workbook. That's the fastest way.
2. If Excel is already open and you need a second workbook, go to File > New > Blank workbook.
3. Use the keyboard shortcut Ctrl+N on Windows (Cmd+N on Mac). Once you've done this a few times, that shortcut becomes muscle memory.

You're now looking at a fresh spreadsheet: rows, columns, a tab at the bottom labeled "Sheet1." This is your workbook. One workbook can hold multiple sheets, like a notebook where each sheet is a page. If that distinction matters for what you're building, the deep dive on workbooks vs. worksheets is worth a read.

---

Step 2: Save Your Excel Workbook Before You Do Anything Else

Now that you've got a blank workbook open, the single best habit you can build is saving it immediately, before you type a single cell. I learned this the hard way early in my career: a workbook with hours of work in it, a crash, and everything gone. Save first.

Naming Your File and Choosing Where to Save

Hit Ctrl+S (Cmd+S on Mac). If this is a new, unsaved file, Excel will prompt you to choose a location and file name. Give it a real name, something like "Monthly Budget 2026" or "Client Contact List," not "Book1." You'll thank yourself later when you're searching through a folder of 40 files.

For save location, you've got two choices: save locally to your computer, or save to OneDrive. OneDrive enables AutoSave, which syncs changes automatically.

AutoSave is not the same as manually saving. AutoSave keeps a continuous cloud backup, but it also commits changes as you make them, which matters if you're editing a shared file and don't want others seeing your half-finished work. For your first workbook, local saves are fine.

Save as .xlsx format unless you have a specific reason not to. It's the current standard. The older .xls format is from Excel 97–2003 and will come up again in Step 3.

For a fuller breakdown of save options and formats, the guide to saving your Excel workbook properly covers what this section can only skim.

---

Step 3: Open an Existing Excel File (and What to Do If It Opens in Compatibility Mode)

Once you've created and saved a workbook of your own, you'll eventually need to open one someone else made. Here's how.

Go to File > Open. From there you can browse your computer, access OneDrive files, open something from your recent workbooks list, or (in Microsoft 365) open files shared with you directly via Open > Shared with Me. That last option doesn't exist in older Excel versions, and none of the other beginner guides seem to mention it, but it's genuinely useful if a colleague has shared something through OneDrive.

From File Explorer on Windows (or Finder on Mac), you can also double-click any .xlsx or .xls file to open it directly without going through Excel first.

About Compatibility Mode

If you open an older .xls file, you'll see "Compatibility Mode" in brackets next to the file name in the title bar. Don't panic. It just means the file was created in an older Excel format and some newer features are temporarily disabled. To get back to full functionality, go to File > Info > Convert and save it as .xlsx. The banner disappears and you've got the full feature set again.

---

Common Mistakes When Opening an Excel Workbook (and How to Avoid Them)

Three things catch beginners most often, and I've seen all of them derail people who were otherwise doing everything right.

The first is Protected View. When you open an Excel file downloaded from the internet or received via email, it may open in Protected View, a read-only mode with a yellow banner at the top. You can't edit anything until you click Enable Editing. A lot of people stare at the screen confused, not realizing edits are blocked. Click that banner first.

Watch out for saving over the original file by accident. If someone gives you a template and you hit Ctrl+S, you've just overwritten their original with your edits. Use File > Save As to create your own copy before you change anything.

The third mistake (and this one matters if you're working on a shared device or switching between laptop and phone) is assuming desktop Excel and Excel for the web behave identically. They don't. Features available in the desktop app may be missing or limited in the browser version. If something isn't working the way you expect on Excel Online, that's probably why.

Open Excel right now and create a workbook for something you actually need: a budget, a reading list, a simple project tracker. Don't practice on fake data. Real use is what makes it stick, and the Excel Basics for Beginners: Advanced Edition is ready when you want to go further.

---