Sunday, January 6, 2013

Inserting Rows o Columns in Excel Not Permitted

I'm opening an Excel file and when I try to insert a new row or column I get a message error giving me a large text about how this is not possible. I have seen many people facing this message, although this gives the solution, sometimes it's hard to understand what this message is trying to say.



But, what's happening? Let me tell you that you' re using all the rows or columns of the file, yes, believe it or not you are having information (even blank space) at least at the last row or column allowed. So, when you want to add a new one, Excel tries to delete this row or column because it will be out of range with the new element inserted.

The solution is going to the last column or row, to do so you can use this shortcut: Ctrl + Down arrow if you want to go to the last row or Ctrl + Right arrow to go to the last column, as shown in the images.





Then, you just have to select the entire row or column and delete, the next step is to save the file to to let Excel to detect this change, once you did this you'll be able to add one row or column, if you need more just follow the same procedure but deleting more rows or columns.


18 comments:

  1. Yes, I think most of ous know this. When all this is tried and you still get the message, then what?

    ReplyDelete
    Replies
    1. I have seen many people who do not read this message, because if you do what I say this message will not appear again.

      Delete
    2. Nice response, Ron. What do you propose when the columns do not delete? For instance, I select column(s), right click & delete... and NOTHING happens - still have column XFD.

      Delete
    3. But, that's the trick, if you select the columns and delete them they are not going to dissapear, you have to save first the file but before that you need to select the first cell of the sheet.

      Delete
  2. thanks, it works. I can insert rows now.

    ReplyDelete
    Replies
    1. Excelent! Sometimes the solution is really easy =)

      Delete
  3. thank you Ronald, good stuff.

    ReplyDelete
  4. Cool, thanks a lot Ronald, it's really help me... ;)

    ReplyDelete
  5. Thanks for posting - just the answer I needed to get me on the right track!

    ReplyDelete
  6. Hi, Its not working for me, I get error as Excel cannot complete the task, choose less data or close other application, can you please help here !!!

    ReplyDelete
    Replies
    1. Hi! what are your PC specs? Probably you need more virtual memory.

      Delete
  7. Thank you very much, it worked for me.

    ReplyDelete
  8. Hi, I did not work for me. I deleted the column, and it still there. Should I write some text in this column and then delete it?

    ReplyDelete
    Replies
    1. Hi Alex! did you delete the lastest column? and did you save it after doing so?

      Delete