How to Insert Rows, Columns and Cells in MS Excel

Insert Rows, Columns and Cells in MS Excel

71853.image0

Inserting rows, columns, and cells in MS Excel

It is very easy to add new rows, columns or cells to an existing worksheet. But, before you learn how to do this, create a worksheet.First move the cell cursor to cell B2 where insertion is to be done. In the Cells group under the Home tab , click on the Insert down arrow to open the Insert drop-down menu.

  • The Shift cells right option will add a blank cell at B2 and shift the contents of cell B2 to C2 and so on.
  • The Shift cells down option will add a blank cell at B2 and shift the contents of cell B2 to B3 and so on.
  • To insert a blank row, click on Insert Sheet Rows. This can also be done by selecting the Entire row option in the Insert dialog box. This will insert a blank row 2 and shift the contents of row 2 to row 3 and so on.
  • To insert a blank column, click on Insert Sheet Columns. This can also be done by selecting the Entire column option in the Insert dialog box. This will insert a blank column B and shift the contents of column B to column C and so on.
  • To insert a blank sheet, click on Insert Sheet. This will add a new worksheet to your workbook.