+ Reply to Thread
Results 1 to 2 of 2

cannot shift nonblank cells off worsheet

  1. #1
    Forum Contributor
    Join Date
    04-26-2013
    Location
    Chennai
    MS-Off Ver
    Excel 2003
    Posts
    119

    cannot shift nonblank cells off worsheet

    I have a worksheet, which has a multitude of data in the form of text, numbers, and some simple formulas

    however, i want to add a column and every time i highlight a column, right click, and select insert, i get the following message:

    "To prevent possible loss of data, Excel cannot shift nonblank cells off the worksheet.

    Try to delete or clear the cells to the right and below the data. Then select cell A1 and save your workbook to reset the last cell used.

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

    pls help

  2. #2
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: cannot shift nonblank cells off worsheet

    Hi
    It sounds like you have reached the maximum number of columns allowable in Excel, this is why you are getting the message.
    Tony

+ 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