+ Reply to Thread
Results 1 to 4 of 4

Can't insert a new row

  1. #1
    Registered User
    Join Date
    11-05-2005
    Posts
    2

    Question Can't insert a new row

    I have about 20 rows of data and I'm trying to insert a row of data before line 6. I highlight cell 6, click Insert /Rows and then I get an error, "To prevent the possible loss of data, Microsoft Excel cannot shift nonblank cells off the work sheet."
    It goes on with some more garbage, but it's already obvious that Microsoft doesn't know what it's talking about. How do I get this insert to work?
    Thanks!

  2. #2
    Bob Phillips
    Guest

    Re: Can't insert a new row

    Take a look at these, you might find that MS does know what it is talking
    about.

    http://support.microsoft.com?kbid=170081
    XL97: "Cannot Shift Objects Off Sheet" Error Hiding Columns

    http://support.microsoft.com/default.aspx?kbid=211769
    "Cannot shift objects off sheet" error message when you hide columns in
    Excel

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "skywaytraveler"
    <[email protected]> wrote in
    message news:[email protected]...
    >
    > I have about 20 rows of data and I'm trying to insert a row of data
    > before line 6. I highlight cell 6, click Insert /Rows and then I get an
    > error, "To prevent the possible loss of data, Microsoft Excel cannot
    > shift nonblank cells off the work sheet."
    > It goes on with some more garbage, but it's already obvious that
    > Microsoft doesn't know what it's talking about. How do I get this
    > insert to work?
    > Thanks!
    >
    >
    > --
    > skywaytraveler
    > ------------------------------------------------------------------------
    > skywaytraveler's Profile:

    http://www.excelforum.com/member.php...o&userid=28589
    > View this thread: http://www.excelforum.com/showthread...hreadid=482536
    >




  3. #3
    Registered User
    Join Date
    11-05-2005
    Posts
    2

    Unhappy No help there.

    Sorry, Bob. No help there.

  4. #4
    Debra Dalgleish
    Guest

    Re: Can't insert a new row

    What cell is selected when you press Ctrl + End?

    skywaytraveler wrote:
    > Sorry, Bob. No help there.
    >
    >



    --
    Debra Dalgleish
    Excel FAQ, Tips & Book List
    http://www.contextures.com/tiptech.html


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1