How to Insert Column/Row in Excel

 

Sometimes we need to add text in written data and want to Insert Row or Column. To Insert Column/ Row there are several methods. I will tell you the easiest way.

First

  • Select the cell you want to insert the row/column before.
  • Right click
  • Select the option “Insert”.
  • Here if you want to Insert Single Cell, select first one of first two options.
  • If you want to Insert the Entire Row Select “Entire row”.
  • If you want to Insert the Entire Column Select “Entire Column”.

Second

Second method is the shortcut key. Using this method you can easily insert Row & Column. Let’s see how?

  1. Select the Cell you want to insert row/ column before.
  2. Press and Hold “Ctrl” and Press “+” (Ctrl+).
  3. You will direct see window Showing insert option.

While using these methods you need to keep always one thing in your mind that select the cell you want to add column/ row before. Because inserted column/row will be inserted before the selected cell.