insert rows

M

michaelsarna

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

Excel for mac will won't let me insert row. I keep getting a message "Cannot shift objects off sheet" The page I am using are budgets that I have been using for years and worked till I installed the newest Excel for mac 2008.
 
C

CyberTaz

The most likely cause is that there is content near the bottom edge of the
sheet - or at least something is causing Excel to "think" there is.

Try selecting the first empty row below your data, key
Shift+Command+DownArrow to select all rows to the bottom of the sheet, then
go to Edit> Clear> All. If that doesn't correct it let us know.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 
L

libwiz

Any other suggestions? This does not work for me. I've tried both
Clear All and Delete after highlighting unused cells. I still cannot
insert a row or column.
 
C

CyberTaz

Well, if you're sure the sheet isn't protected & there is no content in the
cells "empty" cells it's possible that there is some sort of object *on* the
sheet... Such as an image, drawing object, text box, chart, etc. If you'd
prefer to not take the time to locate the offender the easiest solution is
to copy the active content of the sheet & paste to a new sheet.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 
Top