How to Rename, Add and Move Sheets in Excel

To rename a sheet in Excel, double-click its tab at the bottom of the window, type the new name and press Enter. Clear sheet names like "Jan Sales" or "Price List" make a workbook much easier to use, and Excel updates your formulas for you. This guide also covers adding, moving, copying and switching between sheets on Windows and Mac, plus the naming rules that cause most errors.

How to rename a sheet in Excel#

A sheet (also called a worksheet) is one grid inside a workbook, shown as a tab at the bottom. There are three ways to rename one:

1. Double-click the tab. The name is highlighted. Type the new name and press Enter.
2. Right-click the tab and choose Rename, then type and press Enter.
3. Windows keyboard: press Alt, H, O, R (one key after another), type and press Enter.

On a Mac, double-clicking the tab is the easiest way. You can also use Format > Sheet > Rename in the menu bar. Press Esc instead of Enter if you change your mind.

If the difference between a workbook and a worksheet is new to you, read workbook vs worksheet first.

What are the rules for sheet names?#

Excel refuses a name that breaks any of these rules:

Use short, plain names. Spaces are allowed, but they force quotes in formulas, so JanSales or Jan_Sales can be easier to reference than Jan Sales. The exercise on this page uses LEN to check a proposed name against the 31-character limit. The long name in A3 has 43 characters, so the result is Too long.

Good naming habits#

A consistent naming pattern helps everyone who opens the file. Put the type of data first and the period second, like Sales_Jan, Sales_Feb and Sales_Mar, so related tabs sort together in your head. Keep raw data, calculations and the summary on separate, clearly named sheets, such as Data, Calc and Summary. Avoid vague names like Sheet1 (2) or Final_v3, which tell the next person nothing.

How to add a new sheet#

Add a sheet with one click or one shortcut:

• The + button (New sheet) to the right of the last tab adds a sheet after the active one.
• Shift+F11 inserts a sheet before the active one. On a Mac laptop, you may need fn+Shift+F11.
• Right-click a tab > Insert and choose Worksheet (Windows).

New sheets get names like Sheet2 and Sheet3. Rename them straight away, before you write formulas that point to them.

How to move or copy a sheet#

To change the order of your tabs, drag a tab left or right. A small black arrow shows where it will land.

To copy a sheet instead, hold Ctrl (Option on a Mac) while you drag. The copy gets a name like "Jan Sales (2)", which you can rename.

For more control, right-click the tab and choose Move or Copy:

1. Pick the destination workbook in To book. It must be open.
2. Pick the position in Before sheet.
3. Tick Create a copy to copy rather than move.
4. Click OK.

To select several sheets at once, click the first tab, then Ctrl+click (⌘+click on a Mac) the others. Anything you type then goes into every selected sheet, so right-click a tab and choose Ungroup Sheets when you're done.

How to switch between sheets fast#

Use the keyboard to move between tabs without the mouse:

With many sheets, right-click the small arrows to the left of the tabs to see a list of every sheet and jump to one.

What happens to formulas when you rename a sheet?#

Formulas update automatically. If Summary has =Jan!B5 and you rename Jan to "Jan Sales", the formula becomes:

='Jan Sales'!B5

Excel adds the single quotes because the new name has a space. You can type references like this yourself: sheet name, an exclamation mark, then the cell. The guide on how to reference another sheet in Excel explains the format, and XLOOKUP from another sheet shows it inside a lookup.

One caution: formulas in other workbooks only update if those files are open when you rename. If they are closed, their links may break.

Colour, hide and delete sheets#

Right-click a tab for a few more useful options:

• Tab Color marks related sheets, for example all monthly tabs in blue.
• Hide removes a tab from view without deleting it. Right-click any tab and choose Unhide to bring it back.
• Delete removes the sheet and everything on it.

Be careful with Delete: you can't undo deleting a sheet with Ctrl+Z. Save first, or make a copy, if you're not sure. A tidy set of named tabs is the start of most useful workbooks, such as an employee lookup sheet with the data on one tab and the search box on another.

Practise it#

Sheet skills take minutes to learn when you do them yourself. Open the worksheets and cross-sheet references lesson to switch, add and rename tabs in a live spreadsheet, then use other sheets in formulas such as Prices!B3. If cell names like B5 are still new, start with the Cells, rows and columns lesson. Each step is checked instantly.