Skip to content

DigiRuns

Surpass Technical Knowledge

Menu
  • Home
  • Fundamentals
  • Digital Marketing
    • WordPress
    • Web Design and Development
  • Microsoft Office
    • Microsoft Word
    • Microsoft Excel
    • Microsoft PowerPoint
Menu

4 Ways to Rename a Worksheet in MS-Excel

Posted on 27/04/201905/01/2022 by DigiRuns

We can rename a worksheet to suit our needs. Renaming is useful to identify the sheet type. Below is how to change the sheet name in different ways.

Method-1 to Rename a Worksheet in MS-Excel:

  1. Double-click the Sheet tab, and then type the name you want.
4 Ways to Rename a Worksheet in Excel
4 Ways to Rename a Worksheet in Excel

Method-2 to Rename a Worksheet Tab in MS-Excel:

  1. Right click on the Sheet tab that you want to rename.
  2. Then click on “Rename” and then enter the name you want.
Rename a Worksheet in Excel
Rename a sheet tab in Excel

Method-3 to Rename a Sheet Tab in MS-Excel:

  1. Press an Alt key then press H → O →R, and enter the name you want.
Rename a Worksheet in Excel
4 ways to rename a worksheet in excel
Rename a Worksheet in Excel

Method-4 to Rename a Sheet Tab in MS-Excel:

  1. Go to the Home tab.
  2. Click on the Format in the Cells group.
  3. Then click on the Rename Sheet under Organize sheets, and then enter the name that you want to change.
4 Ways to Rename a Worksheet in Excel
4 Ways to Rename a Worksheet in Excel
  1. Row Height and Column Width in Excel (Set in Several Ways):
  2. Introduction to MS-Excel Spreadsheet Environment: 
  3. Merge and Unmerge Cells in MS-Excel
  4. 8 Ways to Select All Contents in a Word Document?
  5. Clear Formats, Contents, Comments and Hyperlinks in Excel
  6. Freeze Panes in MS-Excel | Freeze Rows and Columns in Excel.

FAQ:

How to Rename a Worksheet?

Double-click the Sheet tab, and then type the name you want to rename.

See also  Ways to Apply Accounting Number Format in Excel - 2022

How to rename a worksheet using the alt key?

Use Alt + H → O →R, and enter the name you want.

Recent Posts

  • How to Hide Featured Image On a WordPress Post/Page – 2022
  • YouTube Floating Window for Windows, Mac, and Mobiles
  • A Table Generator for Word and Office 360 – Shortcut Trick
  • How to Enable Missing Theme Editor and Plugin Editor in WP
  • (A-Z) Change Text Direction (Rotate, Flip or Mirror) in Word
  • How to Select Objects That are Behind Text in Word – 2022