Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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

excel
MS Office Version: 13
posted by: Wasempk on Wed Oct 2, 2019 at 11:38 am
Answer
Discuss

Discussion

Do you get any message when you try to insert a row or column?
Variatus (rep: 4889) 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.

posted by: KenHobson (rep: 55) on Wed Oct 2, 2019 at 11:52 am
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: 55) 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