Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2006
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Using MS Excel 2003

    Trying to insert a new row in database. Keep getting this message

    To prevent possible loss of edata, Microsoft Office Excel cannot shift nonblank cells off the worksheet.

    Try to locate the last nonblank cell by pressing CTRL+END, and delete or clear all in cells between the last cell and the end of your data. Then select cell A1 and save your workbook to reset the last cell used.

    Or, you can move the the data to a new location and try again.



    This message does not usually come up when inserting new rows and I am unsure of what they are telling me to do to stop this happening.

    Are you able to offer a "basic excel user" some help?

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Try the following:

    Find your last used row.
    Select the next (unused) row, down to the very end. (you can use CTRL & SHIFT & DOWN ARROW)
    In the EDIT menu, select CLEAR > ALL.
    Save the file, close and re-open.

    When re-entering the file, press CTRL & END. This should then find the last USED row.

    Hope this helps.

  4. #3
    3 Star Lounger
    Join Date
    May 2008
    Location
    India
    Posts
    306
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='VegasNath' post='786625' date='29-Jul-2009 05:33']Try the following:

    Find your last used row.
    Select the next (unused) row, down to the very end. (you can use CTRL & SHIFT & DOWN ARROW)
    In the EDIT menu, select CLEAR > ALL.
    Save the file, close and re-open.

    When re-entering the file, press CTRL & END. This should then find the last USED row.

    Hope this helps.[/quote]
    If above is not working, try following :

    Select entire rows/columns below from where you want to insert the row/column. Right click the upper left corner of selected range and drag it down holding right key. It will insert a new row/column.

    [attachment=84900:untitled.JPG]
    Attached Images Attached Images
    Regards
    Prasad

Posting Permissions

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