+ Reply to Thread
Results 1 to 2 of 2

Limited column range, can't insert column

  1. #1
    Registered User
    Join Date
    01-04-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    1

    Limited column range, can't insert column

    hi, my worksheet seems to have limited column range. Last column is R and I can't insert any more column. I cant also move my cursor to the right of R. Im getting the error:

    "To prevent possible loss of data, Excel cannot shift nonblank cells off of the worksheet. Select another location in which 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 of the worksheet, you can reset which 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 then save."

    I have tried the instruction above but still last column is R and cant insert more. Last nonblank cell is already in column R. There's also no hidden columns either. I've selected all and unhide but still, last column is R.

    Help pls on how to expand the range and add column. Thanks!

  2. #2
    Forum Contributor BlastRanger's Avatar
    Join Date
    09-02-2010
    Location
    Indonesia
    MS-Off Ver
    2003, 2007, 2010
    Posts
    238

    Re: Limited column range, can't insert column

    Your file seems too big.
    Excel read all the blank cell NOT EMPTY. To prove if this is it, see the vertical scroll bar, scroll until the end of it. if you see for example the row is 1048576, or the scroll should not scroll so long which it scroll too far from the last of your value row, then this must be the problem.

    To clear those not empty blank cell, you click the row next to your last value row. For example your last value row is at 100, so you click 101. then hold shift, press END+down. right click the row then choose delete. Do not do anything now, just save your document then reopen it. Should fix the problem you got
    Please give a Reputation as a gift for a thanks.
    By clicking the second icon at the top right corner of a user post or reply

+ 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