Adding a tab in Excel takes one click or right-click, depending on what you want to name it

A sheet tab is the labeled button at the bottom of your Excel window that lets you switch between different sheets in the same file. When you open a new workbook, Excel gives you one sheet called "Sheet1". To add another sheet, right-click on any existing tab at the bottom and select "Insert Sheet", or click the small plus icon next to the last tab. Either method opens a dialog where you can name the new sheet before it appears.

Most people use multiple sheets to organize different types of data in one file — one sheet for January sales, another for February, a third for totals. This keeps related information together without creating separate files.

Key Takeaways

  • The fastest way to add a sheet is clicking the plus icon next to the last tab at the bottom of the window.
  • Right-clicking a tab and selecting "Insert Sheet" lets you name the new sheet before it appears, rather than renaming it afterward.
  • Sheet names can contain spaces and most punctuation, but Excel does not allow forward slashes, backslashes, colons, asterisks, question marks, or brackets.
  • You can reorder sheets by dragging their tabs left or right, and delete a sheet by right-clicking its tab and selecting "Delete Sheet".

The quickest method: click the plus icon

Look at the bottom of your Excel window, where the sheet tabs are. To the right of the last tab (usually "Sheet1"), you will see a small plus sign icon. Click it once. A new sheet appears when ready with a default name like "Sheet2" or "Sheet3", and the tab becomes active so you can start entering data.

This method is fastest if you do not care about the sheet name yet and plan to rename it later. The new sheet is ready to use in less than a second.

The controlled method: right-click and name it first

Right-click on any sheet tab at the bottom of the window. A menu appears with several options. Click "Insert Sheet". A dialog box opens with a text field labeled "Name". Type the name you want for the new sheet — for example, "January Sales" or "Customer List" — and then click OK.

The new sheet appears with your chosen name already on the tab. This method takes a few extra seconds but saves you from renaming the sheet later, which is useful if you are setting up a workbook with many sheets and want them labeled correctly from the start.

Naming rules and what to avoid

Sheet names can be up to 31 characters long and can include spaces, numbers, and most punctuation. However, Excel does not allow these characters in a sheet name: forward slash (/), backslash (\), colon (:), asterisk (*), question mark (?), or square brackets ([ ]). If you try to type one of these, Excel will reject it and ask you to choose a different name.

Sheet names are not case-sensitive — "January Sales" and "january sales" are treated as the same name, and Excel will not let you create both. If you need to distinguish sheets visually, use different words or numbers instead.

Reordering and deleting sheets

Once you have created multiple sheets, you can rearrange them by dragging their tabs. Click and hold on a tab, then drag it left or right to move it past other tabs. Release the mouse button when the tab is in the position you want. This is useful for organizing sheets in a logical order — for example, putting "Summary" first, then "January", "February", "March".

To delete a sheet you no longer need, right-click its tab and select "Delete Sheet". Excel will ask you to confirm, because deleted sheets cannot be recovered. If you delete a sheet by mistake, use Ctrl+Z (or Cmd+Z on Mac) when ready to undo the deletion.

Moving data between sheets

You can copy data from one sheet to another by selecting the cells you want, pressing Ctrl+C (or Cmd+C on Mac) to copy, clicking the tab of the sheet where you want the data, clicking the cell where you want it to go, and pressing Ctrl+V (or Cmd+V on Mac) to paste. The original data stays in the first sheet unless you cut it instead of copying it.

If you want to reference data from one sheet in another — for example, to sum values from a column in "January Sales" while working in "Summary" — you can type a formula that includes the sheet name. In the Summary sheet, you might type =SUM(January Sales!A1:A10) to add up cells A1 through A10 from the January Sales sheet. The sheet name comes first, followed by an exclamation point, then the cell range.

Frequently Asked Questions

Can I rename a sheet after I create it?

Yes. Right-click the sheet tab and select "Rename Sheet", or double-click the tab itself. The name becomes editable and you can type a new one. Press Enter when you are done. The same naming rules explore — no forward slashes, backslashes, colons, asterisks, question marks, or brackets.

What happens if I delete a sheet by accident?

Press Ctrl+Z (or Cmd+Z on Mac) when ready to undo the deletion. If you have already closed the file or performed other actions, the sheet cannot be recovered. This is why Excel asks you to confirm before deleting.

Can I hide a sheet instead of deleting it?

Yes. Right-click the sheet tab and select "Hide". The sheet remains in the file but the tab disappears from view. To unhide it later, right-click any visible tab and select "Unhide Sheet", then choose the sheet you want to show again. This is useful for keeping reference data or old versions without cluttering the tab bar.

How many sheets can I have in one file?

Excel allows thousands of sheets in a single workbook, though having more than a few dozen can slow down the file and make it harder to navigate. Most people keep between 3 and 20 sheets per file, depending on the project.