How to Create a New Workbook in Excel (Beginner Guide)

Written By Sophanith Dith
Last Updated March 03, 2026
Applies to Microsoft Excel 365 (Windows only)
Skill Level Beginner

If you’re just starting with Microsoft Excel, one of the very first skills you need to learn is how to create a new workbook correctly.

Many beginners open Excel and immediately start typing without fully understanding what a workbook is, how it’s created, or what happens behind the scenes. Although creating a new workbook seems simple, doing it correctly helps you build strong file habits from the very beginning.

Before we begin, if you haven’t yet learned how Excel files work, you may want to review What Is Microsoft Excel and What Can You Do With It? to understand the bigger picture.

Let’s start with a quick reference.

Quick Reference

Before we explore each method in detail, here is a simple overview to help you understand the process quickly.

Definition (Simple Explanation):
A workbook is an Excel file that contains one or more worksheets.

Fastest Way to Create a New Workbook:
Press Ctrl + N when Excel is open.

Beginner-Friendly Method:
Open Excel → Click Blank workbook on the Start screen.

While You’re Already Working in Excel (File Tab Method):
Click File → New → Blank workbook.

Create from a Template:
Open Excel → Click New → Choose a template → Click Create.

Important Reminder:
A new workbook is not saved automatically. You must save it manually after creating it.

What Is a Workbook in Excel?

Before learning how to create a new workbook in Excel, it’s important to understand what a workbook actually is. In Excel, a workbook is the entire file you work in.

Think of it this way:

• Workbook = the file
• Worksheet = a single sheet inside that file

When you create a new Excel file, you are creating a new workbook. That workbook can contain:

• One or more worksheets
• Data
• Formulas
• Charts
• Formatting

By default, when Excel opens a new file, it gives it a temporary name like: Book1.

This name appears at the top of the Excel window in the title bar. The file is not permanently saved yet. It only becomes a permanent file after you save it.

Understanding this difference between a workbook and a worksheet prevents confusion later when you begin working with multiple sheets.

Example:
If you’re tracking monthly expenses, each month could be a separate worksheet (January, February, March) inside one workbook called Budget_2026.xlsx.

With that understanding in place, let’s create one.

Method 1: Create a New Workbook from the Excel Start Screen (Recommended)

This is the easiest method for beginners.

Step-by-Step Instructions

When Excel opens, the Start screen appears. In the main area of the screen, click Blank workbook.

Excel will immediately open a brand new, empty workbook.

In rare cases, if you do not see the Blank workbook option in the main area, you can create one manually using the left navigation panel.

Alternative Method (If Blank Workbook Is Not Visible)

1. On the left panel of the Start screen, click New.
2. Then select Blank workbook.

Excel will open a new, empty file.

That’s it.

You will now see:

• A grid of cells
• A worksheet tab (usually named Sheet1)
• A temporary file name at the top (Book1)

This is now your working area.

Why This Method Is Best for Beginners

This method is recommended because:

• It is clear and visual.
• It reduces confusion.
• It ensures you are starting from a blank file.
• It helps you avoid accidentally editing an old file.

If you are just learning Excel, always start this way until you feel comfortable navigating inside the program.

Another way to create a workbook is through the File tab.

Method 2: Create a New Workbook Using the File Tab (While Excel Is Open)

If you are already working inside Excel and prefer using the menu instead of a keyboard shortcut, you can create a new workbook from the File tab.

This method is helpful when:

• You want to stay inside the Excel interface.
• You prefer clicking menus instead of using shortcuts.
• You are still becoming familiar with Excel navigation.

Step-by-Step Instructions

To do this:

1. Click the File tab in the top-left corner of Excel.

Excel will open a Start screen, sometimes also called the Backstage view.

You Are Now in Backstage view, the full-screen menu where you manage your files. In the Backstage view:

2. Click New from the left panel.
3. Select Blank workbook.

Excel opens another new workbook window.

However, if Excel is already open and you want to create another workbook quickly, there is an even faster method — using a keyboard shortcut.

Method 3: Create a New Workbook Using a Keyboard Shortcut (Ctrl + N)

If Excel is already open and you want to create another workbook, you do not need to return to the Start screen.

Instead, use this keyboard shortcut:

Ctrl + N

Pressing Ctrl + N instantly creates a new blank workbook.

Pro Tip:
Most Excel professionals use Ctrl + N daily because it is significantly faster than navigating through menus.

This method is especially useful when:

• You are working with multiple files.
• You want to quickly start a new project.
• You prefer using keyboard shortcuts.

After pressing Ctrl + N, Excel opens a new workbook window with the default name (Book1, Book2, etc.).

Even though this method is faster, beginners should still understand what is happening:

• You are not opening an existing file.
• You are creating a completely new workbook.

So far, we’ve focused on creating a completely blank workbook. But sometimes starting from scratch isn’t the most efficient option

Method 4: Create a New Workbook from a Template

Sometimes you don’t want to start from scratch. Excel provides built-in templates that give you a structured starting point.

To use a template:

1. On the Start screen, click New in the left panel.
2. Browse available templates. Then, choose any template to preview it.
3. Click Create.

Excel will generate a new workbook based on that template.

Templates may include:

• Budget planners
• Calendars
• Schedules
• Expense trackers
• Reports

They are helpful because they:

• Save time
• Provide professional layouts
• Include prebuilt formulas

However, a template is not the same as an existing file. When you select a template, Excel generates a completely new workbook using that structure. The original template remains unchanged.

Whether you start with a blank workbook or a template, Excel always creates a new file for you to work in. Since each method works slightly differently, let’s compare them to see which one makes the most sense for you.

Which Method You Should Use

All four methods create the same type of blank workbook. The difference is when and why you should use each one.

The table below helps you decide quickly:

Situation	Recommended Method	Why
You just opened Excel	Start Screen	Easiest and most beginner-friendly
You are already working in a file	File → New	Lets you create a new workbook without closing Excel
You prefer working quickly with shortcuts	Ctrl + N	Fastest method when Excel is open
You need a pre-designed layout (budget, calendar, etc.)	Template	Saves time with built-in structure and formulas

Simple Beginner Recommendation

If you are new to Excel, use the Startscreen method first.

As you become more comfortable:

• Use Ctrl + N for speed.
• Use File → New when managing multiple files.
• Use Templates when you want a ready-made layout.

Now that you know the different ways to create a workbook, let’s understand what actually happens behind the scenes when a new file opens.

What Happens After You Create a New Workbook?

When a new workbook opens, several important things happen:

• Excel assigns a temporary name (Book1, Book2, etc.).
• The file is not saved yet.
• You can begin typing immediately.
• The workbook contains at least one worksheet.

You can confirm the file has not been saved by looking at the title bar. If it shows “Book1” and no file path, it is unsaved.

At this stage, you should develop an important beginner habit: Save your file immediately.

We cover saving in detail in our complete guide: How to Open, Save, and Close Excel Files (Beginner Guide). That guide explains:

• Save vs Save As
• File formats (.xlsx, .csv)
• Avoiding data loss
• Closing safely

For now, just remember: Creating a workbook and saving it are two separate actions.

Common Beginner Mistakes When Creating a New Workbook

Even simple actions can cause confusion for beginners. Here are common mistakes to avoid.

Mistake 1: Confusing Workbook and Worksheet

Some beginners say, “I created a new sheet,” when they actually created a new workbook.

Remember:

• Workbook = file
• Worksheet = tab inside the file

Keeping this clear prevents confusion later.

Mistake 2: Forgetting to Save Immediately

Creating a workbook does not automatically save it. If your computer shuts down unexpectedly, your work may be lost.

Microsoft provides official guidance in their documentation on how Excel protects files and how recovery works in case of a crash.

As soon as you create a new workbook:

1. Click File → Save As
2. Choose a location
3. Give it a meaningful name

Building this habit early protects your work.

Important:
Excel does not auto-save a brand-new file until you save it for the first time.

Mistake 3: Editing a Template Without Renaming

When using a template, some beginners start editing without saving a new copy. Always save the template-based workbook with a clear name before making major edits.

Example:

Instead of leaving it as “Budget Template,” rename it to: Budget_March_2026.xlsx.

Mistake 4: Opening Multiple Blank Workbooks Accidentally

If you click Blank workbook multiple times, Excel will create multiple unsaved files (Book1, Book2, Book3). This can be confusing.

If you see multiple workbook windows open, check the file name at the top.

Best Practices When Starting a New Workbook

Now that you understand how to create a new workbook, let’s build strong habits.

1. Save Immediately

Don’t wait until you finish working. Save the file as soon as you create it.

2. Use Clear File Names

Avoid names like:

• Book1.xlsx
• NewFile.xlsx

Instead use:

• Sales_Report_April_2026.xlsx
• Practice_Data.xlsx

Clear names help you stay organized.

3. Keep Files in Organized Folders

Create a simple structure like:

• Documents → Excel Files → 2026 Projects

Organization prevents frustration later.

4. Add Worksheets Only When Needed

A new workbook starts with one worksheet. Add more sheets only when your data requires it. Keeping workbooks clean makes them easier to manage.

Understanding best practices is important, but applying them is what builds real confidence.

Quick Practice

Let’s reinforce what you’ve learned with a simple exercise.

Follow these steps:

1. Open Excel 365.
2. Click Blank workbook.
3. Notice the current file name (Book1).
4. Press Ctrl + N to create a second workbook.
5. Notice the new file name (Book2).
6. Return to the first workbook and save it as: Xceltips_Practice.xlsx
7. Close the file properly.
8. Reopen the saved file to confirm it saved correctly.

If you can complete this without hesitation, you’ve mastered this lesson. Practice this a few times until it feels automatic.

Practice builds confidence. Now let’s review the key ideas you should remember moving forward.

Key Takeaways

You’ve practiced creating and saving a new file, let’s quickly reinforce the most important ideas from this lesson.

Creating a new workbook in Excel is the starting point for every spreadsheet task. Understanding this simple process prevents confusion later when working with multiple files.

Here’s what you should remember:

• A workbook is the entire Excel file (.xlsx).
• A worksheet is one tab inside the workbook.
• You can create a new workbook from the Start screen, from the File tab, or by using keyboard shortcut Ctrl + N.
• Always save your workbook immediately after creating it.
• Use clear file names to stay organized.

If these points feel clear, you’re ready to move forward confidently.

Even though creating a new workbook is simple, beginners often have small but important questions. The answers below will help clarify common doubts.

Frequently Asked Questions (FAQ)

1. How do I create a new workbook in Excel 365?

You can create a new workbook in Excel 365 in several ways:

• Open Excel and click Blank workbook on the Start screen.
• Click File → New → Blank workbook.
• Press Ctrl + N when Excel is already open.

All three methods create a new blank Excel file.

2. What is the difference between a workbook and a worksheet?

A workbook is the entire Excel file (for example, Budget_2026.xlsx).

A worksheet is one tab inside that workbook (for example, January or February).

A workbook can contain multiple worksheets, but a worksheet cannot exist on its own.

3. Why does Excel call my file Book1?

When you create a new workbook, Excel assigns a temporary name like Book1.

This simply means the file has not been saved yet. Once you save it and choose a file named Book1 will be replaced with your chosen name.

4. What happens if I close Excel without saving?

If you close Excel without saving, any changes made to the workbook will be lost.

Excel may show a warning message asking if you want to save before closing. Always click Save if you want to keep your work.

5. Can I create multiple Excel workbooks at the same time?

Yes. You can open multiple blank workbooks at the same time.

Each workbook opens in its own Excel window and will have a temporary name such as Book1, Book2, or Book3 until saved.

Keep Building Strong Excel Foundations

Creating a new workbook may seem simple, but it is one of the most important foundational skills in Excel.

Strong file habits prevent:

• Lost work
• Overwritten files
• Organization problems

Take your time to practice this process until it becomes second nature. Bookmark the Beginner Learning Path and continue progressing step by step.

If any step was unclear or didn’t work as expected, leave a comment and describe what happened — I’ll help you fix it.

What’s Next?

Now that you know how to create a new workbook in Excel, the next step is learning how to properly manage your files.

In the next lesson, we’ll explore: How to Open, Save, and Close Excel Files (Beginner Guide)

Mastering file management will give you confidence and prevent beginner mistakes as you move forward.