Be sure to "Delete Selected Columns" and "Delete Selected Rows". Simply
clearing cell contents with the Delete key will *not* do what you need. Then
save workbook & reopen.

--
HTH,
George



"Idaho old guy" wrote in message
...
Thank you. I did that and have no change. It still says cannot shift
items
off sheet. This is excel 07 if that makes a difference.

"Gord Dibben" wrote:

After following FSt1's advice..............save the workbook for the
reset to
take place.


Gord Dibben MS Excel MVP

On Sat, 3 Nov 2007 10:38:01 -0700, FSt1
wrote:

hi
excel is confused. it's internal reference to used space is off. not to
worry. it happen now and then.
to correct.... select all unused columns to the right of your data and
delete
select all unused rows below your data and delete. that should reset
everything.

Regards
FSt1

"Idaho old guy" wrote:

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?