Can’t insert columns

0

Hi there,

I made a table and inserted data. There are no formulas or formatting in the sheet. Now I can not insert columns or rows in this sheet. While other sheets have complicated table and array formulas etc; and I easily add or delete columns or rows.

Appreciate is you give me tips to resolve this problem.

Kind regards,

Waseem

Answer
Discuss

Discussion

Do you get any message when you try to insert a row or column?
Variatus (rep: 3063) Oct 2, '19 at 10:02 pm
Add to Discussion

Answers

0

The sheet or workbook is likely protected. Unprotect it so you can change the structure.

Discuss

Discussion

It’s neither protected nor freeze nor filter. I am surprised. I can’t insert or delete columns or rows. I can do same action on other sheets 
Wasempk Oct 2, '19 at 12:00 pm
Copy the sheet to another workbook and see if it duplicates the issue there. If not, obfuscate that file's data and attach here for us to troubleshoot.

Rght click the sheet's tab, View Code, and see if any code is triggering the problem.
KenHobson (rep: 50) Oct 2, '19 at 12:15 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login