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

By default, the Workspace in a new sheet consists of 10 columns and 20 rows. Beyond the Workspace, there is also an inactive area of that sheet which can be used to expand the Workspace. Cells outside the Workspace, i.e. in the inactive area, are colored gray. This helps to make the process of expanding the Workspace intuitive and convenient.

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

To expand the Workspace:

Double-click a cell in a row or column in the inactive area that you want to include in the Workspace.

Right-click the row or column heading outside the Workspace in the inactive area and select the Double click to add N rows and N columns context menu. The number of rows and columns is suggested by "MyOffice Spreadsheet".

Select any cell outside the Workspace. Move through the cells with the Tab key to expand its range to the right, and with the Enter key to expand the range of the Workspace down.

 

Was the material useful?
Yes
No
Users found this material useful: 0 из 0