Question
How to insert worksheet rows & columns in Excel?
Answer
Adding rows and columns is very simple. On the Home tab in the Cells group, click the down arrow under the Insert command.
From here you can insert cells, rows, and columns simply by clicking on the appropriate command.
You can also use the Insert dialog box. This figure depicts the Insert dialog box, which appears when you select a range of cells, right click on the selection, and then choose Insert from the shortcut menu.
Selecting one of these options controls what happens to existing cells when the new row or column is inserted. You can tell Excel whether to adjust your formulas accordingly with the change (this is called cell referencing, which we will go over in a later section).
For more information about Microsoft Excel Basics, please view the full tutorial from the CTL here: Excel Part 1
If you need further assistance, please click the blue Support Request button on this page.