+ Reply to Thread
Results 1 to 5 of 5

Can't insert and delete rows and columns in Excel 2013

  1. #1
    Registered User
    Join Date
    01-31-2014
    Location
    Sweden
    MS-Off Ver
    Excel 2013
    Posts
    6

    Can't insert and delete rows and columns in Excel 2013

    I can't delete or insert rows or columns in Excel. Insert and delete is not available in the drop down menu and the Excel-sheet is not protected. I haven't disabled it and even though i create a new and blank sheet the options are disabled.

    How can I enable it? Why does this happen?

  2. #2
    Registered User
    Join Date
    12-03-2013
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Can't insert and delete rows and columns in Excel 2013

    Hi. Funny, I never use the menus to insert or delete.

    I select the row or column, and then right click... the option to insert or delete is available.

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Can't insert and delete rows and columns in Excel 2013

    Hi and welcome to the forum.

    Does the following MS response help http://answers.microsoft.com/en-us/o...b-43155ca0b3db
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Registered User
    Join Date
    01-31-2014
    Location
    Sweden
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Can't insert and delete rows and columns in Excel 2013

    Sorry for beeing unclear. I also use right click. But the options are not highlighted..

  5. #5
    Registered User
    Join Date
    01-31-2014
    Location
    Sweden
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Can't insert and delete rows and columns in Excel 2013

    Thanks Richard!

    It resolved my issue

+ 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. VBA Copy insert into another workbook _ excel 2013
    By silverxx12 in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 01-09-2014, 01:47 PM
  2. Excel 2013 Automatically insert a row when the last formatted row is used
    By lisakay in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-21-2013, 02:46 PM
  3. Vba to allow user to insert rows/columns but not delete on unprotected sheet
    By Nicola13 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-12-2012, 06:19 AM
  4. Insert delete columns and rows using vba
    By herwin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-31-2011, 10:51 AM
  5. How to disable insert/delete columns & rows?
    By skysurfer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-11-2010, 04:16 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