View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ian[_4_] Ian[_4_] is offline
external usenet poster
 
Posts: 85
Default Why does "cannot shift objects off sheet" prevent row insertion?

If there is something in row 65535 you can not insert a row as that would
expect the data to move to row 65536 which doen't exist in Excel (except
2007, I believe). Hit Ctrl & End to move to the last used row/column and see
what's there.

Ian

"Idaho old guy" <Idaho old wrote in message
...
I am unable to insert rows in an existing spreadheet and a new one I just
initiated in a book with multiple sheets. What did I do to cause this and
how do I make it go away?