Add or Delete Colums and rows in MS Excel

Add or Delete Colums and rows in MS Excel

You can insert blank cells above or to the left of the active cell on a worksheet. When you insert blank cells, Excel shifts other cells in the same column down or cells in the same row to the right to accommodate the new cells. Similarly, you can insert rows above a selected row and columns to the left of a selected column. You can also delete cells, rows, and columns.

Microsoft Office Excel  has more rows and columns than ever before, with the following new limits: 16,384 (A to XFD) columns wide by 1,048,576 rows tall.

Insert blank cells on a worksheet

  • Select the cell or the range of cells where you want to insert the new blank cells. Select the same number of cells as you want to insert. For example, to insert five blank cells, you have to select five cells.Insert rows on a worksheet

Do one of the following:

To insert a single row, select either the whole row or a cell in the row above which you want to insert the new row. For example, to insert a new row above row 5, click a cell in row 5.

To insert multiple rows, select the rows above which you want to insert rows. Select the same number of rows as you want to insert. For example, to insert three new rows, you select three rows.

To insert nonadjacent rows, hold down CTRL while you select nonadjacent rows.

Delete cells, rows, or columns

  1. Select the cells, rows, or columns that you want to delete.
        • To delete selected cells, click the arrow next to Delete, and then click Delete Cells.
        • To delete selected rows, click the arrow next to Delete, and then click Delete Sheet Rows.
        • To delete selected columns, click the arrow next to Delete, and then click Delete Sheet Columns.You can right-click a selection of cells, click Delete, and then click the option that you want. You can also right-click a selection of rows or columns and then click Delete.
      1. If you are deleting a cell or a range of cells, in the Delete dialog box, click Shift cells left, Shift cells up, Entire row, orEntire column.If you are deleting rows or columns, other rows or columns automatically shift up or to the left.

Leave a Reply

Your email address will not be published. Required fields are marked *