how to add lines in excel

Your browser does not support video.

Note:Microsoft Excel has the following column and row limits: 16,384 columns wide by 1,048,576 rows tall.

Insert or delete a column

Select any cell within the column, then go toHome > Insert > Insert Sheet Columns or Delete Sheet Columns.
Alternatively, right-click the top of the column, and then selectInsert or Delete.

Insert or delete a row

Select any cell within the row, then go toHome > Insert > Insert Sheet Rowsor Delete Sheet Rows.
Alternatively, right-click the row number, and then selectInsert or Delete.

Formatting options

When you select a row or column that has formatting applied, that formatting will be transferred to a new row or column that you insert. If you don't want the formatting to be applied, you can select the Insert Options button after you insert, and choose from one of the options as follows:

Image of the Insert Options button that's displayed after inserting rows or columns.

If the Insert Options button isn't visible, then go to File > Options > Advanced > in the Cut, copy and paste group, check the Show Insert Options buttons option.

Insert rows

To insert a single row: Right-click the whole row above which you want to insert the new row, and then selectInsert Rows.

To insert multiple rows:Select the same number of rows above which you want to add new ones. Right-click the selection, and then select Insert Rows.

Insert columns

To insert a single column: Right-click the whole column to the right of where you want to add the new column, and then selectInsert Columns.

To insert multiple columns:Select the same number of columns to the right of where you want to add new ones. Right-click the selection, and then selectInsert Columns.

Delete cells, rows, or columns

If you don't need any of the existing cells, rows or columns, here's how to delete them:

Select the cells, rows, or columns that you want to delete.
Right-click, and then select the appropriate delete option, for example, Delete Cells & Shift Up, Delete Cells & Shift Left , Delete Rows, orDelete Columns.

When you delete rows or columns, other rows or columns automatically shift up or to the left.

Tip:If you change your mind right after you deleted a cell, row, or column, just press Ctrl+Z to restore it.

Insert cells

To insert a single cell:

Right-click the cell above which you want to insert a new cell.
SelectInsert, and then selectCells & Shift Down.

To insert multiple cells:

Select the same number of cells above which you want to add the new ones.
Right-click the selection, and then selectInsert > Cells & Shift Down.