Trying to insert a row. Insert wont Activate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have one (1) Excel file which when I right click on the start of a row the
menu shows "insert" but it wont activate.
I have many other Excel files all of which I can insert a blank new row or
column.
This one file wont allow that function.
Help!!
Tod
 
The sheet may be protected...
Tools | Protection
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"todflog1" <[email protected]>
wrote in message
I have one (1) Excel file which when I right click on the start of a row the
menu shows "insert" but it wont activate.
I have many other Excel files all of which I can insert a blank new row or
column.
This one file wont allow that function.
Help!!
Tod
 
Jim Cone said:
The sheet may be protected...
Tools | Protection
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"todflog1" <[email protected]>
wrote in message
I have one (1) Excel file which when I right click on the start of a row the
menu shows "insert" but it wont activate.
I have many other Excel files all of which I can insert a blank new row or
column.
This one file wont allow that function.
Help!!
Tod
Click to expand...
 
Sometimes there is only a portion of a file that is protected. Can you cut
and paste the file into another spreadsheet and then insert the row?
 
Is the "Insert" grayed out or available but nothing happens when you click on
it?

How about Insert>Row from the main menu?

How about CTRL + SHIFT + '+' sign?


Gord Dibben MS Excel MVP
 
CommerceMary said:
Sometimes there is only a portion of a file that is protected. Can you cut
and paste the file into another spreadsheet and then insert the row?
Click to expand...
 
You must log in or register to reply here.

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

VBA - retrieve data on last create named range from previous inserted named range 0
insert rows--->protected sheet 1
Excel Unable to insert cut rows into Excel online anymore? 0
insert rows 1
Insert row with a locked cell 1
insert muliple rows, every 4th row 7
Insert a row 1
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1

Back
Top