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.
 

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

Insert worksheet grayed out 2
Insert a row after next 100 rows 3
Insert row option is grayed out 5
Excel Unable to insert cut rows into Excel online anymore? 0
copy worksheet 2
Insert row including formula 3
Inserting a Copied Row inside a table 6
Grayed out Tab in Excel 1

Top