View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default How do I insert a sheet row when that option is grayed out?

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.

"dot" wrote:

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.