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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top