Excel New Sheet: How to Add and Open One

To add a new worksheet in Excel for Microsoft 365 on Windows, click the plus sign beside the sheet tabs, or press Shift+F11. Excel creates a blank worksheet in the current workbook and makes it active; if you mean a separate new workbook, press Ctrl+N instead.

What “new sheet” means in Excel

Excel uses “worksheet” for an individual grid of cells and “workbook” for the file that contains one or more worksheets. A worksheet has its own rows, columns, formulas, and sheet tab. A workbook can hold several related worksheets, such as one sheet for each month, department, or type of calculation.

That distinction matters when someone says they want to “open a new sheet.” Usually, they want to add a worksheet to the file they already have open. If they want a separate Excel file, they need a new workbook. Adding a sheet does not create another file, and creating a workbook does not add a tab to the current one.

Look along the bottom of the Excel window for the tabs, often named Sheet1, Sheet2, or similar. The selected tab is the active worksheet. When you add a sheet, Excel selects it, so you can begin entering data immediately. You can switch back to another sheet by clicking its tab.

Three ways to add a worksheet

Choose whichever method is easiest in your setup. The plus button and keyboard shortcut are usually the quickest; the ribbon and right-click menu are useful when you want to see the command or insert a sheet in a particular place.

Click the plus button: Select the plus sign next to the sheet tabs. Excel inserts a new worksheet and activates it.
Use the keyboard: Press Shift+F11. Excel inserts a worksheet before the active sheet and switches to it. On some keyboards, you may need to hold the Fn key as well to use F11 as a function key.
Use the ribbon: Select Home > Insert > Insert Sheet. This adds a worksheet to the current workbook.
Use a sheet tab’s menu: Right-click a sheet tab and choose Insert. In the dialog box, select Worksheet and confirm. This method is also useful if you want to insert a different kind of sheet that your Excel version offers.

These options add a worksheet to the workbook that is currently open. If Excel has several workbook windows open, check the title bar and selected workbook before using a shortcut or command.

Choose where the new sheet appears

The plus button adds the sheet at the end of the existing sheet tabs. The keyboard shortcut and ribbon command generally insert it before the active worksheet. For example, if you have tabs named January, February, and March and February is active, Shift+F11 places the new sheet before February. It does not erase or replace February.

You can change the order after inserting a sheet by dragging its tab left or right. Watch for the small insertion marker as you drag, then release the mouse button where you want the tab to sit. Reordering tabs changes their position in the workbook, not the content inside the sheets.

For a more precise move, right-click the sheet tab and choose Move or Copy. The dialog lets you choose a destination workbook and the position for the sheet. Select Create a copy if you want to keep the original and make a duplicate. Moving or copying a sheet to another workbook can affect formulas that refer to other sheets, so check important links afterward.

Name and organize the new sheet

Excel gives a new worksheet a default name, but a descriptive tab makes a workbook easier to navigate. Double-click the new tab, type a name, and press Enter. You can also right-click the tab and choose Rename.

Worksheet names must be unique within the workbook and can contain up to 31 characters. Excel does not allow these characters in a sheet name: colon, backslash, slash, question mark, asterisk, or square brackets. Names such as “Q1 Sales,” “2026 Budget,” and “West Region” are valid; a second sheet cannot also be named “Q1 Sales.”

For a workbook with many sheets, consider a consistent naming pattern. Dates can be written in a sortable format such as “2026-01” and “2026-02,” while repeating report sheets might use names such as “Sales – North” and “Sales – South.” You can also apply a tab color by right-clicking a tab and choosing Tab Color. Color is a visual cue, not a replacement for a clear name.

If you need another sheet with the same layout, copying an existing worksheet may save time. Right-click its tab, choose Move or Copy, select where the copy should go, and check Create a copy. A copied sheet may include formatting, formulas, and other sheet-level settings, so review the copy before entering new information.

Open an existing sheet or a separate workbook

If the worksheet already exists in the open workbook, you do not need to create another one. Click its visible tab to open it. If you cannot see the tab, it may be outside the visible portion of the tab bar; use the sheet navigation arrows near the lower-left corner of the Excel window to scroll through the tabs.

A worksheet can also be hidden. Right-click any visible sheet tab and choose Unhide, select the sheet in the list, and confirm. If Unhide is unavailable, there may be no normally hidden worksheet to show, or workbook protection may prevent changes. Excel’s ordinary Unhide dialog does not list sheets set to “VeryHidden” through VBA.

To open a different workbook file, use File > Open and browse to the file, or open it from its folder. To create a new, separate workbook, press Ctrl+N or choose File > New. Save that file with a name and location so it is distinct from the workbook you were already editing.

Why the new-sheet button or command may not work

If the plus sign is missing, hidden, or disabled, the workbook may have restrictions or the sheet tabs may not be displayed. Check these common causes before assuming Excel cannot add a sheet:

Workbook structure is protected: Workbook protection can block inserting, deleting, moving, renaming, or hiding sheets. Check the Review tab for workbook-protection controls. If you have permission and the password, remove the structure protection before making the change. Protect Sheet is different: it primarily controls editing on a worksheet and does not, by itself, protect the workbook’s sheet structure.
Sheet tabs are turned off: In Windows desktop Excel, open File > Options > Advanced. Under Display options for this workbook, check Show sheet tabs. The setting applies to the selected workbook.
The tab area is crowded: A wide horizontal scroll bar can leave little room for sheet tabs. Drag the divider between the tabs and the scroll bar to give the tabs more space, or use the navigation arrows to find other tabs.
You are in a restricted or read-only file: A workbook opened with limited editing permissions may prevent changes. If Excel shows a protected or read-only status, ask the file owner for access or save an editable copy if permitted.
You are trying to add a sheet in the wrong window: The shortcut acts on the active workbook. Click inside the intended workbook first, then add the worksheet.

Excel also requires at least one visible worksheet in a workbook, so a workbook cannot be left with every worksheet hidden. In a shared or business file, protection and permissions may be deliberate; do not remove them unless you are authorized to do so.

Excel for the web and Mac

In Excel for the web, use the plus button beside the sheet tabs to add a worksheet. The browser version has a different interface from the Windows desktop app, and keyboard shortcuts can depend on the browser and its shortcut settings. If Shift+F11 does not add a sheet, use the plus button rather than assuming the workbook is broken.

In Excel for Mac, the plus button beside the sheet tabs is also a straightforward way to add a worksheet. The keyboard behavior can depend on the Mac keyboard’s function-key settings; on some keyboards, press Fn+Shift+F11 to send the F11 key to Excel. If that combination controls a hardware feature or does not work, use the plus button or the sheet-tab menu. Mac menus and settings are not identical to the Windows ribbon and Options dialog.

Sheets added in Excel for the web, Mac, and Windows are part of the same workbook format. When a workbook is saved to a cloud location, changes may sync for collaborators, subject to their access and the workbook’s current sharing settings.

Frequently Asked Questions

How do I open a new sheet in Excel with a shortcut?
In Windows desktop Excel, press Shift+F11 to insert a worksheet before the active sheet. On some keyboards, hold Fn as well. To create a separate workbook instead, use Ctrl+N.

Does adding a new sheet delete my current sheet?
No. Excel adds another worksheet and leaves the existing sheets in place. The new sheet becomes active, but you can return to the previous one by clicking its tab.

How do I open a sheet that is already in the workbook?
Click its tab. If the tab is hidden, right-click another visible tab, choose Unhide, and select the sheet. If tabs are not displayed at all, check the workbook’s sheet-tab display setting.

What is the difference between a sheet and a workbook?
A sheet is one worksheet tab containing a grid of cells. A workbook is the Excel file that can contain multiple worksheets. Use the plus button to add a sheet to the current file; use Ctrl+N to start a separate workbook.

Why can’t I add a new sheet to my Excel file?
Workbook-structure protection, limited editing permissions, or a hidden sheet-tab display can prevent or obscure the command. Check those conditions first, and ask the workbook owner for access if the file is protected.

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.