title: Excel - Adding new column automatically when adding a new cell line
body: <p><a href="https://i.stack.imgur.com/b2FMw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/b2FMw.png" alt="example" /></a></p>
  <p>Hello guys,</p>
  <p>Is there any way in excel when adding a new cell line it automatically creates a new column with the same name created in the cenll line?
  For example, in the picture I have the line 2:5 with names and columns B:E with the same names, but in case, for instance, I wanted to add a new line called &quot;Legs&quot; between line 2:3 (Head and Nose) and it'd automatically create a new column between B:C (Head and Nose) with the name &quot;Legs&quot;.
  Is there any way to do this since I don't know VBA?</p>
  <p>Thanks</p>