hi again,
the advice i gave along with gord's advice(which i forgot) always worked for
me but in 2003 back. I don't have 2007, haven't worked with it so i don't
know. You may need to seek out a 2007 expert on this one.

sorry
FSt1

"Idaho old guy" wrote:

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?