Resize columns or rows

When you create a spreadsheet, all rows and columns have the same size by default. You can resize them by doing the following:

1.Hold the pointer over the border between 2 elements. The pointer will change to a double-sided arrow.

2.Press and hold the left mouse button and move the border to the desired position.

3.Release the left mouse button to set the size.

When you reduce the height of cells, MyOffice Spreadsheet takes into account their contents and reduces the height so that all the contents is displayed.

To have cells with different height or width within one column or row, use the merge cells option.

To set the exact cell size, use one of the following methods:

On the Table command menu, select Cell size.

On the Toolbar, click size_sell Cell size.

A window will be displayed on your screen where you can manually enter values in the Width and Height boxes or select a value with the knpk_more_less buttons located next to the Width and Height boxes. One click changes the value by 0.1 cm.

The Width and Height values apply to all cells of the row/column in which the selected cell is located.

To set the same size for all rows/columns of the table, before resizing/entering the width and height values, select the whole table and set the size you want to apply to all rows/columns of the table for one row/column.

For autofit the width or height of a row/column, double-click with the left mouse button on the line separating the row/column names. The line separating the columns control the width, and the line separating the rows control the height of the cells.

The width is autofit based on the longest text in the column. The height is autofit based on the "highest" text in the row.

You can autofit the size for several rows or columns at the same time. To do this, first select these rows or columns.

When you enter a number in a cell, the width of that cell is automatically selected. The automatic width selection is not performed if:

The width of the column in which the cell is located has been changed manually beforehand.

The cell has a text format or you enter text into the cell.

Hide columns or rows

1.Select the entire row(s) or column(s).

2.To hide them, do one of the following:

On the Table menu, select Hide row or Hide column.

Right-click the row or column heading and select the Hide command on the context menu.

 

Hidden rows or columns are marked in the heading as shown:

hiden_element

Hidden rows and columns are not printed.

Unhide columns and rows

When you place the pointer over the marker indicating the hidden element, the heading will display two arrows indicating the direction in which the hidden element will be restored (before or after the marker).

show_hiden_element

To unhide a column or row, click on the desired arrow near the marker or select the two rows or columns between which the hidden element is located. To do this, click the first element and click the second element while holding the Shift key pressed. Unhide the element by executing the command in one of the ways:

1.On the Command menu, click Table > Unhide column or Unhide row.

2.Right-click the element heading and select Unhide from the context menu.

If multiple elements were hidden, selecting Unhide column or Unhide row commands will display all of them.

Insert columns

When you create a new file, the Workspace is generated automatically. If you need to add new columns later on, follow these steps:

1.Select the same number of columns as the number of columns that you want to insert.

To insert columns, you can select the entire columns, as well as individual cells or cell ranges.

2.Insert the columns in one of the following ways:

On the Command menu, select Table > Insert column to the left or Insert column to the right.

On the Toolbar, select editor_insert_column_icon Insert column to the left or editor_insert_column_right_icon Insert column to the right.

Right-click anywhere in the selected range and select the Insert column to the left or Insert column to the right from the context menu. The context menu is only available for the cells within the Workspace. If several columns or several cells (in several columns) are selected to be inserted, then the commands of the context menu will include the number of columns to be inserted, depending on the number of these selected elements.

To double the number of columns on a sheet, select the entire row and execute Insert column to the right or Insert column to the left command.

To quickly insert one column:

1.Select a cell or a column or a range of cells in one column.

2.Insert a column in one of the following ways:

On the Table menu, select Insert column to the left or Insert column to the right.

On the Toolbar, click editor_insert_column_icon Insert column to the left or editor_insert_column_right_icon Insert column to the right.

Right-click anywhere in the selected range and select the Insert column to the left or Insert column to the right command from the context menu. The context menu is only available for the cells within the Workspace.

 

Insert rows

When you create a new file, the Workspace is generated automatically. If you need to add new rows later on, place the pointer on a cell or select a range of cells/multiple cells and insert the rows in one of the following ways:

On the Command menu, select Table > Insert row above or Insert row below to add one row.

On the Toolbar, select editor_insert_row_icon Insert row above or editor_insert_row_below_icon Insert row below.

Right-click anywhere on the cell or in the selected range and select the Insert row above or Insert row below command from the context menu. The context menu is only available for the cells within the Workspace. If several rows or several cells (in several rows) are selected to be inserted, then the commands of the context menu will include the number of rows to be inserted, depending on the number of these selected elements.

Freeze columns, rows or area

Freezing columns, rows and areas is used when working with large amounts of data. If you scroll the sheet to the right and/or down, the frozen row, column or area is always displayed on the screen. When you scroll through the sheet, the frozen element is separated from the other sheet elements with a bold line.

If a row or column is frozen with a row or column already frozen, the previous setting for the identical element is no longer valid.

In MyOffice Spreadsheet, you can freeze the following elements:

One or multiple columns: When you scroll the sheet to the right, only the frozen columns are displayed, and all columns that are to the left are hidden from the screen.

One or multiple rows: When you scroll the sheet to the bottom, only the frozen columns are displayed, and all columns that are above are hidden from the screen.

Columns and rows simultaneously: When you scroll the sheet to the right and down, only the frozen columns and rows are displayed, and all columns that are to the left and rows that are above are hidden from the screen.

The area of the screen where the upper left cell is cell A1 and the lower right cell is the cell specified by the user.

To freeze the first row and/or the first column, choose one of the following ways:

On the Table menu, select Freeze. In the opened sub-menu, select First row to freeze the top row, and/or First column to freeze the first column.

Click editor_freez Freeze on the Toolbar. In the opened sub-menu, select Freeze first row to freeze the top row, and/or First first column to freeze the first column.

Right-click the selected first column or first row header and select Freeze first row context menu command to freeze the top row and/or Freeze first column to freeze the first column.

To freeze one or more columns or one or more rows, follow these steps:

1.Select the desired columns/rows as a whole or select any number of cells located in those columns/rows.

2.Freeze rows or columns in one of the following ways:

On the Table menu, select Freeze. In the opened sub-menu, select Freeze row <row number> to freeze rows, or Freeze column <column number> to freeze columns.

Click editor_freez Freeze on the Toolbar. In the opened sub-menu, select Freeze row <row number> to freeze rows, or Freeze column <column number> to freeze columns.

Right-click the selected column or row header and select the context menu command Freeze row <row number> to freeze the rows or Freeze column <column number> to freeze columns.

To freeze both rows and columns at the same time, follow these steps:

1.Select any number of cells located in the columns/rows you want to freeze.

2.Freeze rows or columns in one of the following ways:

On the Table menu, select Freeze. In the opened sub-menu, select Freeze row <row number> and Freeze column <column number>.

Click editor_freez Freeze on the Toolbar. In the opened sub-menu, select Freeze row <row number> and Freeze column <column number>.

To freeze an area, do the following:

1.Select the cell that will become the bottom right cell of the area.

2.Freeze rows or columns in one of the following ways:

On the Table menu, select Freeze. In the opened sub-menu, select Up to cell <cell number>.

Click editor_freez Freeze on the Toolbar. In the opened sub-menu, select Freeze up to cell <cell number>.

 

To remove freezing of all columns and rows in the document, select Unfreeze in the list which can be opened in one of the following ways:

On the Table menu, select Freeze.

Click editor_freez Freeze on the Toolbar.

Context menu called by right-clicking on the selected row or column header.

If the frozen area takes the entire visible area of the screen, a window will open in the lower right corner warning you that the frozen area is larger than the web browser window. To scroll through the sheet, you must enlarge the window, zoom out on the page, or unfreeze the rows and columns. In the warning window, click the button:

Unfreeze all to unfix all frozen areas in the document.

Fit to window to zoom out to the desired size (the entire frozen area, three rows below and three columns to the right of the frozen area).

If the frozen area is so large that even at its smallest scale it will not fit in the screen, the warning window displays only the Unfreeze button, while the Fit to window button is not displayed.

Limitations:

Frozen areas are not displayed in read-only documents.

If you scroll to the right and/or down, the notes are not displayed.

When you edit a cell, it is enlarged only within the frozen area and does not affect the size of cells located outside the frozen area.

Delete rows or columns

To delete rows or columns, place the pointer on a cell or select a range of cells that you want to delete and delete the elements by doing one of the following:

On the Command menu, select Table > Delete row or Delete column.

On the Toolbar, select editor_delete_row_icon Delete row or editor_delete_column_icon Delete column.

Right-click a cell or anywhere in the selected range and select Delete row or Delete column from the context menu. The context menu is available only for cells within the Workspace. If several rows/columns/cells were selected to be deleted, the context menu commands will include the same number of rows/columns to be deleted as the number of selected elements.

When deleting rows/columns, at least one cell should remain in the Workspace. If the entire Workspace is selected to be deleted, the operation cannot be performed, the Delete row and Delete column commands will not be available.

The Workspace will be automatically decreased by the number of rows and columns that you delete.

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