You can perform a variety of actions on cells, rows, and columns in the DataSheet.
Before performing an action, you often select the area you want to affect. If you do not select a row or column before doing an operation that affects the entire row or column (such as insert column), the column that contains the active cell is considered selected. The active cell is always selected or is part of a selected area.
When you select a column, a contextual tab named Selected Column appears, allowing you to perform various actions on the selected column.
You can also change header and footer of the selected columns.
When you select a row, a contextual tab named Selected Row appears, allowing you to perform various actions.