How to create and rename a worksheet in Microsoft Excel

In Microsoft Excel, you can add one or more worksheets to an Excel spreadsheet file, as well as rename the worksheet to whatever you want to name it.

Add new worksheet

To add a new worksheet to your Excel file, follow the steps below for the version of Excel on your computer.

Add worksheet in ExcelExcel 2013 and later

  1. At the bottom of the Excel window, to the right of the last worksheet listed, click on the + symbol.
  2. A new worksheet will be created, with a default name of “Sheet” plus a number. The number used is the number of existing worksheets plus one. For example, if there are three worksheets in the Excel file, the new worksheet will be named “Sheet4”.

Add worksheet in ExcelExcel 2010 and earlier

  1. At the bottom of the Excel window, to the right of the last worksheet listed, click the small tab with a folder-like icon and star at the upper left corner.
  2. A new worksheet will be created, with a default name of “Sheet” plus a number. The number used is the number of existing worksheets plus one. For example, if there are three worksheets in the Excel file, the new worksheet will be named “Sheet4”.

Rename worksheet

Rename Excel worksheetTo rename a worksheet in an Excel file, follow the steps below.

  1. At the bottom of the Excel window, right-click on the worksheet tab you want to rename.
  2. Type in the new name for the worksheet and press Enter.

Note: There is a 31 character limit for a worksheet name.


Additional information

  • See our worksheet and rename definitions for further information and related terms.




PinIt
submit to reddit

Leave a Reply

Your email address will not be published. Required fields are marked *

Top
Web Design BangladeshWeb Design BangladeshMymensingh