+ Reply to Thread
Results 1 to 2 of 2

have a spreadsheet made but it wont let me add additional column

Hybrid View

  1. #1
    mari-claire
    Guest

    have a spreadsheet made but it wont let me add additional column

    i have a worksheet already made up but when i try to add a column it says not
    able to due to data

  2. #2
    Stephen
    Guest

    Re: have a spreadsheet made but it wont let me add additional column

    "mari-claire" <mari-claire@discussions.microsoft.com> wrote in message
    news:1B91610D-E261-43F4-9D78-9D5D6EC8EA2D@microsoft.com...
    >i have a worksheet already made up but when i try to add a column it says
    >not
    > able to due to data


    If you have something in column IV (the 256th, or last, column) and you try
    to insert another column you will get a message: "To prevent possible loss
    of data, Microsoft Excel cannot shift nonblank cells off the worksheet." Is
    this what you mean? If so, you need to delete some data to free up at least
    one column. You can use CTRL+END to take you to the last used cell. This
    will show you if you have anything in column IV. Perhaps you have something
    there that you didn't mean to have.



+ 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