ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   cannot insert rows -error message "cannot shift object off sheet" (https://www.excelbanter.com/excel-discussion-misc-queries/165525-cannot-insert-rows-error-message-cannot-shift-object-off-sheet.html)

robwan

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

Tim879

cannot insert rows -error message "cannot shift object off sheet"
 
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.



On Nov 10, 8:30 am, robwan wrote:
Attempts to insert rows or columns result in an error message "cannot shift
object off sheet". How can this be corrected? Office 2007 - Excel





All times are GMT +1. The time now is 07:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com