Excel Tips - unable to insert or delete sheet rows and columns in excel 2016

Excel Tips
Usefull Excel Tips, which helps to resolve excel issue in a minute try below steps.

Solution 1 – using explorer.


1. Press Win key+R and open the RUN, then type following command into Run & press Enter:
%appdata%\Microsoft\Excel


2.  Now find that there is an Excel15.xlb file along with XLSTART folder, here rename Excel15.xlb file to Excel15.old file.

Restart the computer now and you must be now able to manipulate sheet rows and columns with Insert and Delete options.

Solution 2 – Using Registry

Registry Disclaimer: Please before doing this step please create system restore point because if this affected the system so you can restore OS from restore point.
1. Press Win key+ R and put regedit in Run dialog box to open Registry Editor. Click OK.
2. In the left pane of Registry Editor Window, navigate below:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\15.0\Excel\Options

3. In the left pane of this registry location, highlight Options key and right click on it, selectDelete. You can now close Registry Editor and restart the machine. After rebooting the system, launch a new instance of Excel and now you can able to Insert and Delete options without any problem

If this information is helpful to you please subscribe my blog will try to provide some more trick & information which help you to resolve IT issue.
Click below to subscribe 

Post a Comment

Previous Post Next Post