To insert a column, know where you need to insert the column. For example, to insert a column between column number C and D, click on a cell in column number D and do the following:
On the Home tab, in the Cells group, click Insert and click Insert Sheet Columns.
Alternate way to insert a column is to right click on the column header and click Insert.
The quickest way to insert a row is to add the Insert Sheet Columns command to the Quick Access Toolbar by performing the following:
On the Home tab, in the Cells group, click Insert. Right click Insert Sheet Columns and click Add to Quick Access Toolbar.
Note:
When you insert a column, the data in the selected column and the data to the right of the selected column moves one column right.
On the Home tab, in the Cells group, click Insert and click Insert Sheet Columns.
Alternate way to insert a column is to right click on the column header and click Insert.
The quickest way to insert a row is to add the Insert Sheet Columns command to the Quick Access Toolbar by performing the following:
On the Home tab, in the Cells group, click Insert. Right click Insert Sheet Columns and click Add to Quick Access Toolbar.
Note:
When you insert a column, the data in the selected column and the data to the right of the selected column moves one column right.
0 comments:
Post a Comment