This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I right click on a worksheet tab, and Rename is greyed out. The worksheet is not protected, but I'm thinking that the workbook is. How do I correct this, step-by-step?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Hi, if the workbook is protected in the ribbon go to review under changes click on protect book, if it ask for a password you will need it if not, the sheet should be unprotected
What if the file is not protected and the rename option or copy options are grayed out?
I just had this problem. I was overlooking the Protect Workbook since the icon read "Protect Workbook". Protect Sheet icon changes between "Unprotect Sheet" & "Protect Sheet" as you turn on & off protect at the sheet level. But at the workbook level the Protect Workbook always says "Protect Work", it does not change to "Unprotect". You need to look at the color of the icon. If it is un-highlighted lighted then protection is OFF for the workbook. If it is highlighted then protection is ON for the workbook which will cause the "Rename" to be grayed out. So click it to un-highlight and rename your worksheet. Hope that works. It did for me.