Excel New Blank Workbook: Create, Save, and Set It Up

To create a new blank workbook in Excel for Microsoft 365 on Windows, press Ctrl+N, or select File > New > Blank workbook. Excel opens a separate workbook with a worksheet ready for data; save it with Ctrl+S and choose a name and location when prompted.

Create a Blank Workbook in Excel

There are a few ways to start fresh, depending on whether Excel is already open or you are at its opening screen. In the Windows desktop app, use whichever method is easiest:

Keyboard shortcut: Press Ctrl+N. Excel creates a new workbook without closing the one you are using.
File menu: Select File > New, then choose Blank workbook. The New page may also show templates alongside the blank option.
Opening screen: If Excel is showing its start page, select Blank workbook.

Ctrl+N is useful when you want to keep an existing workbook open and make a separate file. It does not clear the current workbook. If you want to remove data from the sheet you are already working on, make a copy first or deliberately clear the cells; creating a new workbook is a different action.

What “Workbook” Means

An Excel workbook is the file that contains your spreadsheet work. Its individual tabs are worksheets, often called sheets. A new blank workbook is therefore a new file, while a new blank worksheet is an additional tab inside a file that already exists.

This distinction helps avoid a common mix-up. On Windows, Ctrl+N creates a new workbook. To add a worksheet to the open workbook, select the plus button beside the sheet tabs, or use Shift+F11. Adding a sheet does not create another Excel file, and opening a new workbook does not add a tab to the current file.

A workbook can contain multiple worksheets, charts, tables, and other Excel content. Even if it starts with one empty sheet, you can add more sheets later and rename them—for example, “January,” “February,” and “Summary” for a monthly budget.

What You See in a New Workbook

A blank workbook opens with a grid of cells arranged in columns and rows. Column headings use letters, row headings use numbers, and each cell has an address such as A1 or C5. Select a cell and type to enter a value, label, date, or formula. Press Enter to confirm an entry and move to another cell.

At the bottom of the window, the sheet tab identifies the active worksheet. The ribbon across the top contains commands for tasks such as formatting, inserting tables, and creating charts. A new workbook generally starts with one worksheet, but the configured default can differ. In Excel for Windows, the number of sheets for new workbooks can be set under File > Options > General > When creating new workbooks > Include this many sheets.

“Blank” means Excel has not filled the sheet with a particular dataset or layout. It does not mean the workbook has no structure: it still has rows, columns, a worksheet tab, and default formatting and calculation settings. You can begin typing immediately or shape the layout first.

Save the Workbook and Choose a File Type

A new workbook has no permanent file name or location until you save it. Press Ctrl+S or select File > Save As, then choose a folder, enter a file name, and select a file type if needed. For a normal Excel workbook, the standard format is Excel Workbook (*.xlsx). The title bar may show a temporary name such as “Book1” until you save.

Choose a location that makes sense for how you will use the file. Saving to a local folder keeps it on that computer or connected storage. Saving to OneDrive or another supported cloud location can make it available across devices and allow sharing, depending on your account and settings. Excel’s AutoSave feature is available for supported cloud-stored files; do not assume it is on for a workbook saved only to a local drive. Ctrl+S remains a useful way to save your latest changes.

Other formats have specific trade-offs:

.xlsx is the usual choice for a workbook without VBA macros.
.xlsm supports a workbook containing VBA macros. Excel may display a security warning when a file with macros is opened.
.csv stores text values in a delimited format, not the full workbook experience. It does not preserve multiple worksheets, most formatting, or workbook features.

If a workbook contains several sheets, check carefully before saving a copy as CSV: CSV represents one sheet at a time. Keep the .xlsx or .xlsm original when you need to retain workbook features.

Start Blank or Use a Template?

A blank workbook is a good choice when you are building a layout yourself, entering an uncomplicated list, or need an empty space for calculations. A template is often faster when the structure is predictable. Excel’s New page offers templates for things such as budgets, calendars, schedules, and invoices, though the templates available can depend on the Excel version and internet access.

Templates provide headings, formatting, and sometimes example content or formulas. They can save setup time, but they are not automatically correct for every situation. Before using a template for a real budget or report, check its labels, date ranges, formulas, and assumptions. Remove sample information that does not belong in your file.

If you repeatedly use the same custom layout, you can save a prepared workbook as an Excel template (.xltx) and use it as a starting point later. A template is meant to create a fresh workbook from its design, whereas reopening an ordinary .xlsx file takes you back to the saved workbook and its existing data. This is useful for recurring forms where the layout stays the same but each copy should contain new entries.

Set Up the Sheet Before Entering Data

A little planning can make a blank sheet easier to use. For a simple expense tracker, for example, put clear column headings in the first row—Date, Category, Description, and Amount—then enter one expense per row. Keep each type of information in its own column. That structure makes it easier to sort, filter, summarize, or turn the range into a table later.

Consider these basic setup choices:

Use descriptive headings. “Amount” is clearer than an unexplained abbreviation such as “Amt.”
Keep a consistent data type in a column. Mixing dates and notes in the same column can make sorting and analysis less reliable.
Separate raw entries from summaries. A second worksheet can hold totals or charts while the first keeps the original records.
Format after entering representative data. Apply date, currency, or percentage formats to the relevant cells or columns rather than typing symbols into every entry.
Use a meaningful sheet name. Double-click a sheet tab to rename it, or use its context menu.

For a list that will grow, you can select the data and choose Insert > Table. A table makes it easier to filter and sort records and usually extends its formatting as new rows are added. You do not need to create a table before entering data, but using clear headers from the start makes conversion more straightforward.

Common Problems When Starting a New Workbook

If Ctrl+N seems to do nothing, first check whether Excel has focus. Click inside the Excel window and try again. Some laptops require holding Fn to send a function-row key, although Ctrl+N itself normally does not use a function key. If a browser or another application is active, its shortcut behavior may be different.

If Excel opens an existing workbook instead of its start page, you can still create a separate blank file with Ctrl+N or File > New. The opening screen and the workbook-creation command are related but not identical: changing what appears at startup does not remove the New command. In Windows desktop Excel, the startup-screen preference is in File > Options > General, under the start-up options.

If the new workbook has more than one sheet, that can be an intentional setting rather than a problem. Check the “Include this many sheets” option described above. If a blank workbook will not save, check that the chosen folder is writable, that the file name is acceptable, and that any cloud sign-in or connection issue has been resolved. Saving a local .xlsx copy can help distinguish a cloud-location problem from an issue with Excel itself.

Finally, do not confuse an empty-looking sheet with a missing workbook. A newly created workbook may not show a separate window in the way you expect if Excel is using a single-window interface or you are switching between open files. Look at the workbook title and sheet tabs, or use the View or Window controls to locate open workbooks. Avoid closing an unsaved file until you have saved any information you need.

Excel on Mac and in a Browser

On Excel for Mac, use Command+N to create a new workbook. You can also use the File menu or choose a blank workbook from Excel’s start screen; menu wording and layout can vary by release. The Windows shortcut Ctrl+N does not apply to a Mac keyboard, where Command is the usual equivalent for this action.

In Excel for the web, start from the Excel home page and choose the option to create a new blank workbook. The web app runs in a browser and commonly saves work to OneDrive, so the save and sharing experience differs from a desktop file saved to a local folder. Browser keyboard shortcuts can sometimes take precedence; if a shortcut does not create a workbook, use the visible New or Blank workbook control.

Excel mobile apps also let users create workbooks, though the interface is designed for touch and does not match the desktop ribbon exactly. Across platforms, the key idea is the same: create a new workbook for a separate file, then save it in an appropriate location and format.

Frequently Asked Questions

How do I open a new blank workbook in Excel?
In Excel for Microsoft 365 on Windows, press Ctrl+N, or choose File > New > Blank workbook. On a Mac, use Command+N or the File menu.

What is the shortcut for a new Excel workbook?
The Windows shortcut is Ctrl+N. The Mac equivalent is Command+N. If you are using Excel in a browser and the shortcut is intercepted, choose the blank workbook option on Excel’s home page.

How do I add a blank sheet without creating another file?
Click the plus button beside the worksheet tabs. In Windows desktop Excel, Shift+F11 also inserts a worksheet into the current workbook.

Why does my new workbook have several sheets?
Excel can be configured to include a chosen number of worksheets in each new workbook. In Windows, check File > Options > General and adjust “Include this many sheets” under “When creating new workbooks.”

Does a new blank workbook save automatically?
Not until it has been saved to a location. Press Ctrl+S on Windows or Command+S on Mac and choose a name and location when prompted. AutoSave availability depends on where the workbook is stored and your Excel setup.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.