Add a row or column in Datasheet view
By default, the star (*) row - a blank row marked by an asterisk (*) in the row header - is displayed after the last row in a list. You can use this row to add a new item to the list.
- If the blank row is not visible, click New Row in the toolbar to move the focus to the blank row.
Note You cannot insert a blank row between two existing rows. If the view is read-only, the star row is not displayed.
- Right-click a cell in the list.
- Click Add Column.
- In the
Add Column page, specify the column
details, and click
OK.
The column will be added to the right of the selected column. To move the column, simply click the column header and drag it to the new position.
Note You can add only one column at a time. If cells in multiple columns are selected, the column containing the active cell will be taken as the selected column.