inserting rows in spreadsheet

M

Mzungucarol

When I try to insert a row I get the response "Cannot shift objects off
sheet". How do I correct this error so that rows can be inserted?

thank you
 
S

Shane Devenshire

Hi,

This means that there is something near the bottom of your spreadsheet and
when you try to insert some rows Excel doesn't know where to push those
things. Select all the row number from the last one with data you want, down
to the end of the worksheet (row 65536 or 1048376) and press Ctrl+- (control
minus). Save the file and try the insert rows command again.
 

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

Top