Question

explain the method to insert multiple columns in a worksheet​

Answer 1

In this method, you will use the copy and paste method in Excel.

Select any 5 blank rows in the worksheet. ...

And then right click the target area in those rows.

After that, choose the option “Copy” in the sub menu. ...

Now click the row header of the target row in the list.

Next right click your mouse