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

  • Thread starter Thread starter dot
  • Start date Start date
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel-Adding rows to master sheet that will be inserted on following worksheets 1
Insert worksheet grayed out 2
Excel Unable to insert cut rows into Excel online anymore? 0
Options are grayed out... 1
Alt codes 4
VBA - retrieve data on last create named range from previous inserted named range 0
Insert row including formula 3
copy worksheet 2

Back
Top