How to Unlock Grayed out Menus in Excel (5 Effective Ways)

In Microsoft Excel, the top of the screen’s Menu Bar provides access to many commands for activities like opening and shutting files, generating reports, formatting data, and other actions. Sometimes, while working with excel we may face the problem of a grayed out menu bar. In this article, we will demonstrate some effective ways to unlock grayed out menus in Excel.


Download Practice Workbook

You can download the workbook and practice with them.


Reasons for Menus to Be Grayed Out

The following are six reasons why Excel menus may be grayed out:

  • Working on a cell / Editing a cell.
  • Password-protected spreadsheet.
  • Workbooks are safeguarded.
  • Worksheets are organized into groups.
  • Obscured objects (Advanced display option).

5 Effective Ways to Unlock Grayed out Means in Excel

A menu shows a list of options. It is sometimes known as a drop-down menu that allows you to conduct activities. Some of these instructions are accompanied by graphics, allowing you to immediately connect the command with the image. The navigation bar, which would be the taskbar at the edge of the window, contains the majority of the options. These grayed out for several reasons shown in the above section in the article. Let’s solve the grayed-out menu problem.


1. Press Enter to Unlock Grayed out Menus in Excel

While editing a cell, all the menu options grayed out. If you look at the picture down, it clearly shows that the menu options are locked because we are editing Cell D10.

5 Effective Ways to Unlock Grayed out Means in Excel

To unlock the grayed out menu, follow the below steps:

  • Press Enter on your keyboard after editing.
  • And, now you will be able to see the grayed out menus are now unlocked.

5 Effective Ways to Unlock Grayed out Means in Excel


2. Unprotect Worksheet to Unlock Grayed out Menus

If you are not editing any cell of your worksheet, but still see that locked grayed out menus. It may be because of protected worksheets.

5 Effective Ways to Unlock Grayed out Means in Excel

To unprotect the worksheet and unlock the grayed out menu, we may follow the small steps below:

  • Firstly, go to the Review tab from the ribbon.
  • Secondly, under the Protect group, click on Unprotect Sheet.

5 Effective Ways to Unlock Grayed out Means in Excel

  • This will appear in the Unprotect Sheet dialog, where we need to put the password.
  • Further, to unprotect the sheet enter the password on the Password box.
  • Then, click on the OK button.

5 Effective Ways to Unlock Grayed out Means in Excel

  • Finally, you can see that all the grayed out menus are now unlocked.

5 Effective Ways to Unlock Grayed out Means in Excel


3. Unlock Grayed out Menus by Unprotecting Workbook

When we right-click on the sheet tab, we may see that many of the menus are grayed out. It is because of the protected workbook.

5 Effective Ways to Unlock Grayed out Means in Excel

The steps to unlock the grayed-out option and unprotect the workbook:

  • To begin with, click the Review tab on the ribbon.
  • Second, choose Protect Workbook from the Protect category.

  • The Unprotect Workbook dialog will display, prompting us to enter the password.
  • To unlock the document, type the password into the Password field.
  • Then press the OK button.

  • Finally, it will unlock all of the options.


4. Ungroup Sheets to Activate Excel Menus

If you checked all the previous methods but still found the grayed out menus. This may be because your sheets are in the group. You may need to group your sheet by clicking on a sheet then press Ctrl and select all the other sheets but forgot to ungroup them.

To ungroup the sheets to unlock grayed out menus:

  • In the first place, right-click on the sheet.
  • Then, click on the Ungroup Sheets.

  • And, that’s it! You will see all the active menus.


5. Excel Advanced Option to Unlock Grayed out Menus

If you’ve tried all of the preceding techniques and the menu is still inactive. This is because you may need to change some settings from the Advanced options in excel.

To change the advanced options to unlock the grayed out menus you need to follow some steps down:

  • Firstly, go to the File tab from the ribbon.

  • Then, click on Options from the bottom left corner of your excel screen.

  • This will open the Excel Options window.
  • Further, click on Advanced.
  • Then, scroll down a little bit, and you will find an option Display options for this workbook.
  • Furthermore, from the For objects show selection box, select All.
  • Then, finally, click OK to complete the procedure.

  • And, lastly, you will be able to see that all the menus are now visible.


Important Note

If you are using the older version of Microsoft Excel like 2010 or something, you may still face lock grayed menus for two more reasons. To solve this problem, we may follow the below procedures.

  • Shared Workbook

Go to the Review tab from the ribbon on your excel file. Then, you will find a group name Changes. Now, from there click on Shared Workbook and uncheck the box beside Allow changes by more than one user at the same time under the Editing option. Finally, click OK to complete the procedure for the Shared Workbook. This will unlock the grayed out menus.

  • Enable Change Tracking

Similarly as before, go to the Review tab from the ribbon. Then, under the Changes group, click on the Track Changes drop-down menu and select Highlight Changes. Now, uncheck the Track changes while editing. Finally, clicking the OK button will solve the problem.


Conclusion

The above methods will assist you to Unlock Grayed Out Means in Excel. Hope this will help you! If you have any questions, suggestions, or feedback please let us know in the comment section. Or you can have a glance at our other articles in the ExcelDemy.com blog!

Sabrina Ayon

Sabrina Ayon

Hi there! This is Sabrina Ayon. I'm really excited to welcome you to my profile. Currently, I'm working in SOFTEKO as a Excel and VBA Content Developer. I'm a student of United International University and my program is Computer Science and Engineering. I love working with computers and solving problems. I’ve always been interested in research and development. So, here I will be posting articles related to Microsoft Excel. Hoped this may help you. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo