Post 5

1. Inserting Rows and Columns

Insert rows and columns into a worksheet to fill in blanks or add data.

Columns are added to the left of the specified column, and rows are added above the specified row.

How to Insert Rows

1. Click the row heading to the right of where We want the new row to appear.
2. On the Home tab, select the Insert command.
3. The new row will be shown above the already chosen row.

Note: We can also insert a row by right-clicking the header of the row above which we wish to add the new row and selecting Insert from the shortcut menu.

Note:  When we enter additional rows, columns, or cells, the Insert Options button appears next to the added cells. This option lets us choose how Excel formats the cells. Excel formats added rows using the same formatting as the cells in the row above by default. Hover the cursor over the Insert Choices button, then click the drop-down arrow to view more options.

How to Insert Column

1. Click the column heading to the right of the location where we want the new column to appear.
2. On the Home tab, select the Insert command.
3. The new column will be added to the left of the already chosen column.

Note: We may alternatively insert a column by right-clicking the header of the column to the left of which we want to add a new column, then selecting Insert from the shortcut menu.