+ Reply to Thread
Results 1 to 5 of 5

Unable to insert lines

  1. #1
    Registered User
    Join Date
    02-11-2015
    Location
    Houston
    MS-Off Ver
    Excel 2010
    Posts
    3

    Unable to insert lines

    You were so kind to help me 3 years ago, I thought I'd ask a new question.

    I am using Windows 10 (not willingly) and Office Home & Student 2007. Everything works well except when I try to insert a new line in my Excel spreadsheet, I get this message:

    "To prevent possible loss of data, Excel cannot shift nonblank cells off the worksheet. Select another location to insert new cells or delete data from the end of your worksheet.

    "If you do not have data in cells that can be shifted off the worksheet, you can reset which cells Excel considers nonblank. To do this press CTRL+End to locate the last nonblank cell on the worksheet. Delete this cell and all cells between it and the last row and column of your data and then save."

    Well, my worksheet is only 210 rows and 14 columns, so what gives? I've tried to get to the last nonblank cell, but it shows me something still within the amount of rows I am using (not all rows have data at this point). Given that the number of rows between my last row of data and the end of an Excel spreadsheet is pretty much infinite, I don't think the helpful hint is all that helpful. Short of buying a newer version of Office, what can I do?

    I am hoping that y'all will be more helpful and that it's something as easy as the last time. THANK YOU

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Unable to insert lines

    so we have to see what is wrong in your file without the file ?


    strange
    Leo

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Unable to insert lines

    Hey Marti,

    I'd select the last 100 rows of your sheet (that most likely look blank) and delete them. Then try to insert a row again. I'd bet you have something on those last (bottom) rows that you can't see.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Unable to insert lines

    1. click end/home and see where the cursor lands.
    2, if it is "out in the middle of nowhere", start to CAREFULLY delete rows and columns until you get back to the last row and column that you KNOW contains data
    3. Save the file under a different name (so you don't mess up the orig file)
    4. Close and re-open and see if that helped?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Unable to insert lines

    You could try copying the actaul data range, A1:O210 ? to a blank sheet, leaving any excess / bloat behind.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 01-03-2018, 01:40 PM
  2. Unable to copy formula down but changing the lookup array every 8 lines
    By AdamStratfull in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-25-2017, 06:21 AM
  3. [SOLVED] How do I insert high-low lines on 2 specific lines (out of 4)?
    By radiotower in forum Excel General
    Replies: 0
    Last Post: 01-20-2017, 02:20 AM
  4. [SOLVED] Unable to write code with more than 25 physical lines to create Outlook Email.
    By pipoliveira in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-16-2015, 06:05 AM
  5. Insert lines+ C/P according to lines with keywords
    By jullianm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-05-2014, 08:49 AM
  6. [SOLVED] Insert blank lines to make the total number of lines 67
    By raghuprabhu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-29-2012, 07:34 AM
  7. Replies: 0
    Last Post: 02-09-2012, 11:53 AM

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