Insert Or Delete A Worksheet - Microsoft Support

Related topics × Get started with Excel Get started

• What is Excel?
• Use Excel as your calculator
• Add a watermark in Excel
• Merge and unmerge cells
• Insert or delete rows and columns
• Collaborate on Excel workbooks at the same time with co-authoring
• Move or copy worksheets or worksheet data
• Hide or show rows or columns
• Select cell contents in Excel
• Insert or delete a worksheet
• Change the format of a cell
• Create and format tables
• Save your workbook to OneDrive in Excel
• Copy cell formatting
• Create a chart from start to finish
• Available number formats in Excel

Collaborate

• Protect an Excel file
• Print a worksheet or workbook
• Share your Excel workbook with others

Formulas and functions

• Calculate the difference between two dates
• Formulas and functions
• SUM function
• IF function
• XLOOKUP function
• Display or hide zero values

Import and analyze data

• Create a PivotTable to analyze worksheet data
• Filter data in a range or table
• Use slicers to filter data
• Use the Field List to arrange fields in a PivotTable
• Import or export text (.txt or .csv) files
• Filter for unique values or remove duplicate values
• Quick start: Create a macro
• Import data from the web
• Create Power Query formulas in Excel
• Find or replace text and numbers on a worksheet
• Apply data validation to cells

Format data

• Lock or unlock specific areas of a protected worksheet
• Group or ungroup data in a PivotTable
• Create a PivotChart
• Use sparklines to show data trends
• Create a drop-down list
• Combine text from two or more cells into one cell
• Freeze panes to lock rows and columns
• Quick start: Sort data in an Excel worksheet
• Split data into multiple columns

Skip to main content Sign in with Microsoft Sign in or create an account. Hello, Select a different account. You have multiple accounts Choose the account you want to sign in with. Related topics Get started with Excel Get started

• What is Excel?
• Use Excel as your calculator
• Add a watermark in Excel
• Merge and unmerge cells
• Insert or delete rows and columns
• Collaborate on Excel workbooks at the same time with co-authoring
• Move or copy worksheets or worksheet data
• Hide or show rows or columns
• Select cell contents in Excel
• Insert or delete a worksheet
• Change the format of a cell
• Create and format tables
• Save your workbook to OneDrive in Excel
• Copy cell formatting
• Create a chart from start to finish
• Available number formats in Excel

Collaborate

• Protect an Excel file
• Print a worksheet or workbook
• Share your Excel workbook with others

Formulas and functions

• Calculate the difference between two dates
• Formulas and functions
• SUM function
• IF function
• XLOOKUP function
• Display or hide zero values

Import and analyze data

• Create a PivotTable to analyze worksheet data
• Filter data in a range or table
• Use slicers to filter data
• Use the Field List to arrange fields in a PivotTable
• Import or export text (.txt or .csv) files
• Filter for unique values or remove duplicate values
• Quick start: Create a macro
• Import data from the web
• Create Power Query formulas in Excel
• Find or replace text and numbers on a worksheet
• Apply data validation to cells

Format data

• Lock or unlock specific areas of a protected worksheet
• Group or ungroup data in a PivotTable
• Create a PivotChart
• Use sparklines to show data trends
• Create a drop-down list
• Combine text from two or more cells into one cell
• Freeze panes to lock rows and columns
• Quick start: Sort data in an Excel worksheet
• Split data into multiple columns

Applies ToExcel for Microsoft 365 Excel 2024 Excel 2021 Excel 2019 Excel 2016

In Excel, you can easily insert, rename, and delete worksheets in your workbook.

Insert a worksheet

• Select the New Sheet plus icon  at the bottom of the workbook.

• Or, select Home > Insert > Insert Sheet.

  

Rename a worksheet

• Double-click the sheet name on the Sheet tab to quickly rename it.

• Or right-click on the Sheet tab, select Rename then type a new name.

Move a worksheet

• To move the tab to the end, right-click the Sheet tab then Reorder... > (move to end) > OK 

• Or click and drag to tab to any spot.

Delete a worksheet

• Right-click the Sheet tab and select Delete.

• Or, in the ribbon menu, select the sheet, and then select Home > Delete > Delete Sheet.

  

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

Need more help?

Want more options?

DiscoverCommunity

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Ask the Microsoft Community

Microsoft Tech Community

Windows Insiders

Microsoft 365 Insiders

Was this information helpful?

Yes No Thank you! Any more feedback for Microsoft? Can you help us improve? (Send feedback to Microsoft so we can help.) What affected your experience? Resolved my issue Clear instructions Easy to follow No jargon Pictures helped Other Didn't match my screen Incorrect instructions Too technical Not enough information Not enough pictures Other Any additional feedback? (Optional) Submit feedback By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×