Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I insert a sheet row when that option is grayed out?
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table option is grayed out | Excel Discussion (Misc queries) | |||
Auto Filter Option grayed out | Excel Discussion (Misc queries) | |||
The password option is grayed out under the Security tab | Excel Discussion (Misc queries) | |||
I can't delete a whole sheet in Excel. Option is grayed out. | Excel Worksheet Functions | |||
unmerge option is grayed out | Excel Discussion (Misc queries) |