+ Reply to Thread
Results 1 to 4 of 4

Unable to insert or delete rows

  1. #1
    Registered User
    Join Date
    04-08-2016
    Location
    South Arica
    MS-Off Ver
    10
    Posts
    4

    Unable to insert or delete rows

    Unable to insert or delete a row in a spreadsheet.

    Error Message: This operation is not allowed. The operation is attempting to shift cells inyour table on your worksheet.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,967

    Re: Unable to insert or delete rows

    Hi Avril, welkom aan die forum

    (ex PE and K-dorp here, now in USA)

    what exactly are you trying to do here?

    Which version of excel are you useing (please include that in your profile)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    04-08-2016
    Location
    South Arica
    MS-Off Ver
    10
    Posts
    4

    Re: Unable to insert or delete rows

    Goeie More / Good Morning

    Excel 2010. Created a spreadsheet. It does not allow me to insert or delete row.
    I used table tool design to insert coloured rows.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,967

    Re: Unable to insert or delete rows

    What does the rest of the worksheet contain, can you share a copy with me?

+ 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. Unable to delete rows
    By Kingsta in forum Excel General
    Replies: 1
    Last Post: 06-01-2014, 05:49 AM
  2. Unable to Insert Columns or Rows
    By navajo_23 in forum Excel General
    Replies: 10
    Last Post: 09-09-2013, 12:25 PM
  3. [SOLVED] Unable to Insert Columns or Rows
    By Jack K in forum Excel General
    Replies: 18
    Last Post: 04-09-2013, 12:13 AM
  4. Unable to insert row or delete row or erase values-macro-Indian number format
    By srinivasan1965 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-16-2012, 07:12 AM
  5. [SOLVED] Unable to delete rows
    By Mrowe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-19-2012, 03:08 PM
  6. Unable to insert rows
    By DivinationX in forum Excel General
    Replies: 1
    Last Post: 12-30-2009, 04:10 AM
  7. Unable to delete rows or columns? Why?
    By Barney Quinn in forum Excel General
    Replies: 3
    Last Post: 09-17-2006, 09:43 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