Insert Rows grayed out

[Vegreville_Food_Bank]

Note: I am very new to excel.

When I right click on a row to insert that option is grayed out. It is also grayed out in the ribbon (home tab). When I go into options it is check marked as an option to see. I have not been able to figure out how to add it through customize ribbon in options.

[#2]

Hello,this is simply because you have doubled clicked on the particular selected rows. Hence, everything greyed out including the ribbon tabs group

[#3]

To insert a new row and/or column, select close to the row and/or column and press CTRL + SHIFT = (equal sign) or write click the row or column and select Insert

[#4]

You can do one thing, on top of your right side of excel sheet there is option sonething like show/hide ribbon, unable to recall exact name but this would be near to Cross sign to excel.
Do let me know if this solve your problem.

[#5]

Thank you all, I have no idea what happened but it is working now. I honestly tried so many things for so long I have no idea what I did!!! But thank you so much for trying to help me!

[#6]

So all my work from yesterday was lost due to problems with the content. So I had start all over meaning I had to figure out the no insert issue again (I am using a previous sheet to make a new sheet, rebuilding would take longer). The culprit of the grayed out insert options seems to have been a row at the top of the sheet which was mainly empty with the word January. I had a row like this separating each month, but the one at the top was the only one keeping me from inserting.

[#7]

Many thanks, This has worked.

[#8]

@Vegreville_Food_Bank 

Just in case anyone is in my situation... I was unable to insert a row in my sheet.  It wasn't obvious, but it was because I had two tables side-by-side.  If I selected a row in the sheet that spanned across both tables, then insert was greyed out. I had to do each table individually by highlighting a row in the table, right-click, and insert table row. In each table.