Clear Row Formatting with the Range.ClearFormats Method.

Specify Entire Row with the Range.EntireRow Property.

Specify a Cell Range a Specific Number of Rows Below or Above a Cell or Cell Range with the Range.Offset Property.

Specify a Cell with the Worksheet.Cells and Range.Item Properties.

Specify a Cell Range with the Worksheet.Range Property.

Specify the Active Cell with the Application.ActiveCell Property.

Specify Rows with the Worksheet.Rows Property.

Insert Rows with the Range.Insert Method.

If you want to delete the contents of the column, press the Delete key on the keyboard. Using the steps above, delete the column and move the columns to the right over to the left. You can also right-click with your mouse on the highlighted column and select Delete.

In the menu bar, click Edit and select Delete.

You can also right-click the highlighted column and select Delete.

On the Home tab in the Ribbon menu, click Delete and select Delete Sheet Columns.

Highlight the column or columns you want to delete.

Alternatively, with column C highlighted, hold Shift and click the F column header. Then, additionally highlight the three columns to the right, by clicking and dragging on the C, D, E, and F letters. For example, if you want to add four rows on column C, highlight the C column. If you want to add multiple columns at once, highlight more than one column, click Insert and select Columns. You can also right-click the selected cell, select Insert, then select the Entire column option.

On the Home tab in the Ribbon menu, click Insert and select Insert Sheet Columns.

For example, to add a column on the 'C' column, select the C1 cell or any other cell in column C.

Select the cell where you want to add a column.

If you want to delete the contents of the row, press the Delete key on the keyboard. Using the above steps, delete the row and move the rows under the deleted row up. You can also right-click with your mouse on the highlighted row and select Delete.

Using the steps above, delete the row and move the rows under the deleted row up. You can also right-click the highlighted row and select Delete. On the Home tab in the Ribbon menu, click Delete and select Delete Sheet Rows.Do this by clicking and dragging your mouse on the number 3, 4, 5, and 6. For example, to add four rows beginning at row 3, highlight row 3 and the three rows following it. If you want to add multiple rows at once, highlight more than one row and then click Insert and select Rows.

Insert rows in excel