inserting a row..

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

WHEN TRYING TO INSERT A ROW AND IT SAYS CANNOT SHIFT OBJECTS OFF ...
 
It means you have something in the last row(s) and cannot shift
the rows down.

Use Ctrl+End to find the last cell, which is the intersection
of the last row with content, and the last column with content.
Spaces are content, and formulas are content as are empty strings.

More information in
http://www.mvps.org/dmcritchie/excel/lastcell.htm

Some people try to hide calculation formulas in an out of the
way place -- a very bad thing to do.

If you try to copy an entire sheet and paste that into another
spreadsheet below row 1 it will not fit.
 
You must log in or register to reply here.

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

Insert Rows 1
error message that I can't shift objects off page with insert com 1
cannot insert rows -error message "cannot shift object off sheet" 1
Excel 2007 Can not insert row. 1
Can't insert a row 6
Problems inserting rows 1
Adding more than 65,536 rows in Excel 2007 5
Rows 2

Back
Top