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

Create a dynamic master file 1
Need Help with a VBA subroutine 0
Dealing with a Pivot Table (when I don't want to) 0
Protect workbook for Windows option is grayed out in Excel 2013 3
Insert worksheet grayed out 2
Inserting a Copied Row inside a table 6
Word macro that can call cells out of Excel for a find and replace 0
Insert row option is grayed out 5

Top