Trying to insert a row. Insert wont Activate

T

todflog1

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
 
J

Jim Cone

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
 
T

todflog1

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...
 
C

CommerceMary

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?
 
G

Gord Dibben

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
 
T

todflog1

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...
 
Top