cannot insert rows -error message "cannot shift object off sheet"

G

Guest

Attempts to insert rows or columns result in an error message "cannot shift
object off sheet". How can this be corrected? Office 2007 - Excel
 
T

Tim879

In Excel 03 this usually fixes the issue...


Somewhere off in the "blank" regions of your spreadsheet one of the
cells has data.


Just highlight all of the blank columns in the spreadsheet and then go
to Edit->delete.

Do the same for the rows.
 

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

"cannot shift objects off sheet" error 8
Insert Rows 1
Cannot shift objects off sheet 7
Cannot shift objects off sheet? 2
Cannot Shift Object off sheet 4
"cannot shift object off sheet". 1
"Cannot shift objects off sheet" in Excel when inserting row/col? 2
Getting error message when trying to hide a column 2

Top