How can we help you?

All actions on a sheet are performed within the area referred to as the workspace.

By default, when the file is created, the spreadsheet on the first sheet consists of 300 rows and 26 columns . All subsequent spreadsheets will have 20 rows and 10 columns. Beyond the workspace, there is also an area that can be used to expand the workspace. Cells outside the active area are colored gray.

Workspace borders expand automatically if you insert more rows or columns than the current workspace has.

To expand the workspace manually, use one of the methods:

Double-click a cell in a row or column in the inactive area that you want to include in the workspace. When you expand the workspace to the right with a double click, the formatting is not copied.

Right-click the row or column heading that you want to include in the workspace and select the Add row/Add column context menu option. The number of rows and columns is suggested by MyOffice Spreadsheet depending on the number of line or rows between the workspace and the selected row or cell.

Select any cell in a row or column before the expansion area. To enlarge the workspace by one or more columns, use the Tab key. To enlarge the workspace by one or more rows, click Enter (return Return).

Was this helpful?
Yes
No
Next
Cell ranges