Comments on: How to add columns in Excel: single, multiple, every other

In this article, we will explore various methods to insert columns in Excel, ranging from simple right-click options to VBA macro for adding every other column automatically. Whether you need to add more data to your report, rearrange existing columns … Continue reading →

Table of contents

Comments page 2. Total comments: 31

  1. I'm trying to insert a large number (366) of sequential rows between two exiting rows in Excel 2016. None of the options in your add-ons do this except to insert every x number of rows. I had a look at the VBA macro (scares the crap out of me) and was wondering if by removing the +1 parameter it would stop the row skipping option. Advice please

    1. no, it has something to do with the colstep (currenlty set to 2, set it to 1)

      you do have to define a new counting method

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)