The Insert Row Option is Grayed out – 9 Solutions

The following picture highlights the problem and the solution.

Insert Row Option Greyed Out in Excel

Solution 1 – Press Windows+R and Change the Microsoft Excel AppData

You can fix the grayed-out Insert Row option by changing the AppData.

  • Close all open Excel files.
  • Press Win + R.
  • Enter %appdata%\Microsoft\Excel  in Open.
  • Click OK.

  • Change the .xlb file extension to .old

The Insert Row option is working.

Fix Greyed Out Insert Row Option by Changing AppData

Read More: Cannot Insert Row in Excel

Solution 2 – Unprotect the Worksheet

  • Select Review >> Unprotect Sheet to unprotect the worksheet.

Fix Greyed Out Insert Row Option by Unprotecting Worksheet

Solution 3 – Unprotect the Workbook

  • Select Review >> Protect Workbook to unprotect the workbook.
  • Enter the password.

Solution 4. Unselect Columns to Re-enable the Insert Row Option

  • Unselect the columns.
  • Unselect the rows to insert or delete columns.

Solution 5. Enable a Grayed out Insert Row Option by Exiting Cell Editing

  • Press Esc to exit cell editing and try to use the insert row command.

Solution 6. Change the Display Options

  • Press ALT+F+T to open Excel Options.
  • Go to Advanced.
  • In Display options for this workbook, select the worksheet.
  • In For Objects,show, choose All.
  • Click Ok.

Fix Greyed Out Insert Row Option by Changing Display Options

Read More: Excel Shortcuts to Insert New Row

Solution 7 – Fix the Disabled Insert Row Option in a Shared Workbook

Select Review >> Share Workbook. Uncheck Allow changes by more than one user at the same time and click OK.

Solution 8 – Remove Unnecessary Add-Ins

Go to File >> Options >> Add-Ins. Remove the Add-Ins one by one to see. Add them again.

Solution 9 – Fix Grayed out Insert Row Option with an Excel VBA

  • Ppress ALT+F11 to open the VBA window.
  • Select Insert >> Module.

Copy the following code.

Public Sub Reset_Menu()
End Sub

Paste the code into the module. Press F5 to run the code.

Things to Remember

  • You can try deleting the following registry from the registry editor to reset the commands >> HKEY_CURRENT_USER\Software\Microsoft\Office|16.0\Excel\Options.
  • Sometimes restarting your PC or updating your Office automatically fixes the bugs.

Download Practice Workbook

Download the practice workbook here.


Related Articles

<< Go Back to Insert Rows | Rows in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Shamim Reza
Md. Shamim Reza

Md. Shamim Reza, a marine engineer with expertise in Excel and a fervent interest in VBA programming, sees programming as a time-saving tool for data manipulation, file handling, and internet interaction. His diverse skill set encompasses Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning. He holds a B.Sc in Naval Architecture & Marine Engineering from BUET and has transitioned into a content developer role, generating technical content focused on Excel and VBA. Beyond his professional pursuits,... Read Full Bio

  1. You can also try to delete rows that you are not using.
    In my case the table for some reason filled up all 100.000 entries of excel and there was no space for a new one anymore.

    Just delete some rows and you will be able to add new ones.

    Good luck!

    • Thank you very much for your suggestion. Good to know that.
      Hopefully, this will help someone.
      And Good Luck to you too!

  2. Thank you Shamim! The 1. Press Windows Key+R and Change Microsoft Excel AppData helped me!

    • Hi GIRIDAR N,

      Thanks for your appreciation and we are glad to help you. For any types of Excel-related problems kindly reach out to us.


  3. thank u very much

  4. Shamima thanks a lot. This solved my problem with option 1.

Leave a reply

Advanced Excel Exercises with Solutions PDF