Excel Worksheets: Add, Rename, Move, Copy, and Group

An Excel worksheet is one tab of cells inside a workbook. A workbook might use separate worksheets for source data, calculations, monthly results, and a summary. Managing those tabs well makes the file easier to navigate and reduces the chance of editing, copying, or deleting the wrong data.

The key is to treat worksheet structure as part of the workbook’s design. Add a sheet for a clear purpose, give it a useful name, place it where readers expect it, and check formulas before moving or removing it.

Menu paths below use current desktop Excel for Windows. Excel for Mac and Excel for the web support most of the same worksheet tasks, but some labels, shortcuts, and cross-workbook options differ.

Start with a simple worksheet plan

Before adding a long row of tabs, decide what belongs together. A practical reporting workbook might use this order:

Arrange worksheet tabs by purpose so instructions and summaries come first, recurring detail sheets stay together, and supporting sheets remain near the end.

This is a planning pattern, not an Excel rule. The best order follows how people use the file. Keep closely related tabs together, and avoid creating a new sheet when a filter, table, or additional column would keep the same dataset easier to maintain.

Add a worksheet and name it immediately

Select the New Sheet plus button beside the sheet tabs to insert a blank worksheet. In Excel for Windows, Shift+F11 is the keyboard shortcut. You can also use Home > Insert > Insert Sheet.

Rename the new tab before adding data:

1. Double-click the worksheet tab, or right-click it and select Rename.
2. Type a short, specific name such as North Region or Q3 Summary.
3. Press Enter.

Insert a new worksheet by clicking the plus button, then rename the tab to a clear name such as Q3 Summary.

Worksheet names must be unique within the workbook. They cannot be blank, contain more than 31 characters, begin or end with an apostrophe, or include /, \, ?, *, :, [, or ]. Excel also reserves the name History for internal use. Microsoft’s worksheet-renaming guide documents these restrictions.

Names such as Sheet7 and New Sheet reveal little about the content. Prefer stable labels that describe the sheet’s role. If a reporting period belongs in the name, use a consistent pattern such as 2026-01, 2026-02, and 2026-03.

Select and navigate worksheet tabs efficiently

Select a tab to make that worksheet active. If the workbook has more tabs than fit across the window, use the tab-scrolling controls beside the sheet tabs to bring another tab into view.

Hold Ctrl while clicking worksheet tabs to select nonadjacent sheets in Excel for Windows.

On Mac, hold Command to select nonadjacent tabs. Microsoft lists additional navigation and selection methods in its worksheet-selection guide.

Reorder tabs to match the workflow

Drag a worksheet tab left or right to change its position. A small marker shows where Excel will place it when you release the mouse button. Reordering does not rename the sheet or change its cell contents.

Drag a worksheet tab left or right and use the position marker to place it where it fits the workbook workflow.

Use tab color sparingly when it adds meaning. For example, one color might identify input sheets and another might identify reports. Keep the meaning consistent and do not rely on color alone; the sheet name should still explain its purpose.

Moving a sheet can affect formulas or charts that depend on worksheet order, including formulas that refer to a span of sheets. Check key calculations after reorganizing a workbook.

Copy a worksheet without rebuilding it

Copying is useful when a new sheet needs the same layout, formulas, validation, and formatting as an existing sheet. For example, a reviewed project tracker can become the starting point for a new project.

1. Right-click the source worksheet tab and select Move or Copy.
2. Choose where the copied sheet should appear.
3. Select Create a copy.
4. Select OK.
5. Rename the copy and replace only the project-specific inputs.

Use Move or Copy to duplicate an existing worksheet, choose where the copy should appear, and select Create a copy before clicking OK.

In Excel for Windows, you can also hold Ctrl while dragging a sheet tab to copy it within the workbook. On Mac, hold Option while dragging.

Copy or move a sheet to another workbook

In desktop Excel, open both workbooks, use Move or Copy, and choose the destination in the To book list. Select Create a copy if the original workbook should retain its sheet; leave it clear only when you deliberately want to move the sheet.

After moving or copying a sheet between workbooks, inspect formulas, charts, named ranges, data connections, and newer workbook-dependent features. References to sheets that were not moved can become external links or return unintended results.

Excel for the web can duplicate a sheet within its current workbook, but it does not provide the same whole-sheet cross-workbook command as desktop Excel. Microsoft’s move-or-copy guide explains the supported methods for Windows, Mac, and the web.

Group worksheets only for coordinated changes

Grouping lets one edit affect the same cell or range on several selected worksheets. It works well when the sheets share an identical structure—for example, adding the same heading, formula, or formatting to several regional report tabs.

1. Select the worksheet tabs that need the same change.
2. Confirm that the intended tabs are highlighted. In desktop Excel, the workbook title can also show [Group].
3. Make the change in the required cell or range.
4. Check another grouped sheet to confirm the result.
5. Right-click a selected tab and choose Ungroup Sheets.

Select multiple worksheets as a group when you need to enter the same heading, formula, or formatting in the same cell location across several sheets.

Do not leave sheets grouped accidentally. Data entry, deletion, and formatting on the active sheet can also affect the same locations on the other grouped sheets. Ungroup as soon as the shared task is complete.

Microsoft’s group-worksheets instructions cover adjacent, nonadjacent, and all-sheet selections.

Hide supporting sheets without treating them as secure

Hiding a worksheet can reduce clutter when a finished report contains supporting calculations or lookup lists that most readers do not need to open.

• To hide a sheet, right-click its tab and select Hide.
Right-click a worksheet tab and choose Hide to remove a supporting sheet from view while keeping its data available in the workbook.

• To restore it, right-click any visible tab, select Unhide, choose the sheet, and select OK.
Right-click a visible worksheet tab, choose Unhide, select the hidden sheet, and click OK to restore it.

• Formulas can continue to use data from a hidden worksheet.

Hiding is an interface choice, not a security control. A user with access to the workbook can normally unhide the sheet. If the workbook’s sheet structure must not be changed, use the appropriate workbook protection features and manage the password carefully.

Microsoft’s hide-or-unhide guide includes the current steps for Windows, Mac, and Excel for the web.

Reference another worksheet in a formula

A formula can read a cell from another sheet by placing the sheet name before the cell reference, separated by an exclamation mark:

=January!B6

If the worksheet name contains a space or certain other characters, Excel encloses it in single quotation marks:

='North Region'!B6

Use a sheet name followed by an exclamation mark to reference a cell on another worksheet. When the sheet name contains a space, Excel encloses it in single quotation marks.

You do not have to type the reference. Start the formula, select the other worksheet, select the required cell, and finish the formula. This reduces spelling mistakes in sheet names.

When renaming, moving, copying, or deleting tabs, review formulas that cross worksheet boundaries. A sheet name is not merely a navigation label when formulas, charts, validation rules, or defined names depend on it.

Delete a worksheet deliberately

Right-click the sheet tab and select Delete, or use Home > Delete > Delete Sheet. Before confirming, check whether the sheet contains data or supports calculations elsewhere in the workbook.

Right-click the worksheet tab and choose Delete after confirming that the sheet is no longer needed and does not support important workbook calculations.

1. Search formulas and charts for references to the sheet.
2. Confirm that the information is retained elsewhere if it is still required.
3. Save a backup or a separate copy of the workbook when the deletion is significant.
4. Delete the sheet and inspect important totals for reference errors or changed results.

Hiding is a better choice when a sheet is merely distracting but still supports the workbook. Deletion is appropriate when the sheet and its dependencies are genuinely obsolete. Microsoft documents the basic add, rename, move, and delete commands in its worksheet-management guide.

Fix common worksheet-tab problems

Excel worksheet questions

Keep the tab row understandable

Give every worksheet a clear role, name it before it fills with data, and keep related tabs in a predictable order. Copy a reviewed structure instead of rebuilding it, use grouping only while making a deliberate shared change, and treat cross-workbook moves and deletions as dependency checks. A tidy tab row is not cosmetic—it is part of making the workbook reliable.