Results 1 to 3 of 3

Thread: MS Excel 2003 problem

  1. #1
    Member
    Join Date
    Aug 2004
    Posts
    180

    MS Excel 2003 problem

    Hi. I'm running MS Excel 2003 on a computer with Windows 7. All of a sudden I can no longer insert a row in a particular worksheet. I can do so in other worksheets in the same workbook, but not in this particular one. I did nothing to change the settings in this workbook from when I could insert a row 5 minutes prior to not being able to insert a row.

    I've tried both right clicking on a row and choose "Insert" and going to the top menu "Insert/Rows" and in either case I get the following error mssg:

    cannot shift objects off sheet

    I've run a search through MS's off-line and on-line help system but no solution. Can anyone help or suggest anything?

  2. #2
    Member
    Join Date
    Aug 2004
    Posts
    180
    Also I can no longer hide a column in this worksheet, delete a column or resize a column. I get the same error mssg re: cannot shift objects off sheet. I checked and the worksheet and workbook are not protected or locked in any way that I can see.
    Last edited by Kathleane; 03-11-2010 at 04:01 PM. Reason: add to reply

  3. #3
    Administrator Steve R Jones's Avatar
    Join Date
    May 1999
    Location
    Largo, FL.
    Posts
    5,275
    I Binged-> cannot shift objects off sheet

    and found this and others:

    Error message when you try to insert or hide rows or columns in Excel: "Cannot shift objects off sheet"
    http://support.microsoft.com/kb/211769

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •