Rename a Worksheet

 In Genel

In this article, we will be informing you about how to rename a worksheet. Two changes that help to edit and define worksheets and the data they contain is to rename the worksheet and to change the color of the sheet tab under the work area. You will see the instruction and actions concerning this. You can take a look at our blog to find our articles about the other features.

 

3 ways to rename a worksheet

  1. Double-click the sheet tab and type the new name.
  2. Right-click the sheet tab, click Rename, and type the new name.

  3. Use the keyboard shortcut Alt+H > O > R, and type the new name.

 

1- Double-click the Sheet Tab

excel sayfa adını yeniden adlandırma

This method works in all versions of Windows, Mac, 365 and online Excel.

  1. Double-click on the name of the sheet tab to emphasize the name in the tab.
  2. Type a new name for the worksheet.
  3. Press Enter to complete renaming the worksheet.
  4. The new name should be displayed on the sheet tab.

 

sağ tık menüsünden sayfa adını değiştirme2- Right-click the Sheet Tab

This method works in all versions of Windows, Mac, 365 and online Excel.

  1. Right-click the sheet tab of the worksheet you want to rename to open the context menu.
  2. Click Rename on the menu list to emphasize the current sheet name.
  3. Type a new name for the worksheet.
  4. Press Enter to complete renaming the worksheet.
  5. The new name should be displayed on the sheet tab.

 

3- Access the Ribbon Options with your mouse

çalışma sayfalarını adlandırma

This method works in all versions of Windows, Mac, 365 and online Excel.

  1. Click the sheet tab of the worksheet to be renamed to make it the active page.
  2. Click the Home tab of the ribbon.
  3. Click Format on the Cells to open the drop-down menu.
  4. Click Rename Sheet to emphasize the sheet tab on bottom of the screen.
  5. Type a new name for the worksheet.
  6. Press Enter to complete renaming the worksheet.

 

Things to pay attention to while naming a worksheet:

  • Page name cannot be blank.
  • It cannot consist of more than 31 characters.
  • It cannot contain any of these characters: / \ ? * : [ ] For example, 05/04/2020 cannot be a valid worksheet name but 05-04-2020 can be.
  • It cannot start or end with an apostrophe (‘), but it can be used between texts and numbers in the name.
  • It cannot be named “History“. This is a special dictionary used for special purposes within Excel.

 

You can click here to get more information.

See you in other posts, bye. 🙋🏻‍♂️
You can share this post with your friends and enable them to get informed as well. 👍🏻

Önerilen Yazılar

Start typing and press Enter to search

X