Can't insert row

[Angela Byars]

I've got two spreadsheet with identical data types and, I thought, identical
formatting. One spreadsheet allows me to insert rows. When I try to insert
a row in the other one I am told that Excel can not shift non-blank cells
off the worksheet. I've never had a problem with this. What have I done to
that spreadsheet???
TIA - Ange

 

[Frank Kabel]

Hi
you may have accidentically set your used range to the last row. Try
re-setting the used range following the instructions on:
http://www.contextures.com/xlfaqApp.html#Unused

and try again

 

[Angela Byars]

Frank,
That's exactly what it was. Thank you very much -