How do I insert a sheet row when that option is grayed out?

D

dot

I made a spreadsheet and copied it using copy and paste. I want to be able to
add information to the spredsheet but all the options under Home/Insert/Cells
are grayed out except the option Insert Sheet. I want to Insert Sheet Rows.
 
J

JLatham

Sounds like the sheet is protected. On the Home tab click on Format in the
Cells group and under Protection hopefully you'll see "Unprotect Sheet".
Click that.
 
Top