All actions on the sheet are performed within the workspace (spreadsheet, sheet, table).
Outside the workspace there is a gray expansion zone. Cells in this zone are inactive.
You can expand the workspace boundaries manually or automatically.
Double-click to expand the workspace
To expand the workspace manually, double-click a cell in the row or column you want to include in the workspace.
When you expand the table to the right by double-clicking, formatting is not copied.
Expand the workspace via the header context menu
1.Right-click the header of the row or column to be included in the workspace.
2.From the context menu, select Add row or Add column.
If more than one row or column is selected, the menu will prompt you to add the appropriate number.
Expand the workspace using the Tab and Enter keys
1.Select a cell in the row or column that borders the gray expansion area.
2.To add columns, press the Tab key.
3.To add rows, press the Enter key.
Automatic expansion
Table borders expand automatically if you insert copied rows or columns that are larger than the current table size.