Excel Online Tutorial – Insert a Row & a Column in a Worksheet

You can insert a row or column into your existing worksheet data to accommodate more information. This is particularly useful if the information you need to add fits naturally within the existing data, rather than at the end.

When you insert a row, Excel shifts the existing rows down, so you must first determine the row above where you want your new row to appear. Similarly, when you insert a column, Excel shifts the existing columns to the right, so you must first determine the column to the left of where you want your new column to appear.