+ Reply to Thread
Results 1 to 6 of 6

Unable to insert new collumn in Excel, there's msg pops up..

  1. #1
    Forum Contributor
    Join Date
    06-05-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    109

    Unable to insert new collumn in Excel, there's msg pops up..

    Hi guys,

    I often bump into this problem
    At times when I would like to insert a new column in between, I can't do it

    Attached the message comes up
    Capture1.JPG

    I've follow what the message mentioned and delete all the unnecessary column but I can't insert a new column

    Please advice, what went wrong and how to get this done..

    Appreciate

    Regards
    Cks1026

  2. #2
    Forum Contributor rajeshturaha's Avatar
    Join Date
    08-22-2012
    Location
    Assam, India
    MS-Off Ver
    Excel 2003, 2007
    Posts
    236

    Re: Unable to insert new collumn in Excel, there's msg pops up..

    Possibly there is some data in the last column, delete all the data from the last col used till the last col, and then try
    Rgd
    RT
    If my answer(s) helped you, please add me reputation by click on *

  3. #3
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Unable to insert new collumn in Excel, there's msg pops up..

    Quote Originally Posted by rajeshturaha View Post
    Possibly there is some data in the last column, delete all the data from the last col used till the last col, and then try
    After deleting (not clearing contents) these extra non-used columns..save the file..then try inserting new columns.
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  4. #4
    Forum Contributor
    Join Date
    08-11-2012
    Location
    bengalur
    MS-Off Ver
    Excel 2003, 2007
    Posts
    152

    Re: Unable to insert new collumn in Excel, there's msg pops up..

    Please can you check whether is there any hidden columns. This might create problem due to this.

    _______________________________________________________________________________________________________________________________________

    Please click * if this has helped.

    “I have not failed. I've just found 10,000 ways that won't work.”
    ― Thomas A. Edison

  5. #5
    Forum Contributor
    Join Date
    06-05-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    109

    Re: Unable to insert new collumn in Excel, there's msg pops up..

    Hi rajeshturaha, Ace_XL, shyamhappy,

    I've tried all the suggestion but still the same...

    Sigh......

  6. #6
    Forum Contributor rajeshturaha's Avatar
    Join Date
    08-22-2012
    Location
    Assam, India
    MS-Off Ver
    Excel 2003, 2007
    Posts
    236

    Re: Unable to insert new collumn in Excel, there's msg pops up..

    Will it be possible to attach your file

+ 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. Excel 2010 - Unable to Insert Column - Error message not helping
    By tplenert in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 07-25-2014, 05:36 AM
  2. Microsoft Office Excel, Unable to get the Insert property of the .... Exel 2003
    By smithcza in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-07-2008, 12:46 PM
  3. [SOLVED] unable to insert columns in excel, insert-> columns (disabled)
    By iam_leearner in forum Excel General
    Replies: 1
    Last Post: 08-13-2006, 09:26 AM
  4. Insert Visio Button sheet pops up automatically
    By quailhunter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-07-2005, 07:57 PM
  5. Replies: 4
    Last Post: 02-18-2005, 12:06 PM

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