Select colums or rows

Product: MyOffice Professional, MyOffice Standard

Application: Spreadsheet Desktop version macOS

Select a column or row

To select a column or row, use one of the following methods:

•Hover the cursor over a column or row heading so that the cursor looks like down_arrow or right_arrow . Left-click the heading.

•Click any cell in the row or column you want to select. To select a row, press Shift+Space. To select a column, press Ctrl+Space when working in Windows or Linux. Or shift Shift+ command_grey Cmd+Space when working in macOS.

To select all rows that contain the merged cell, select the cell and press Shift+Space.

To select all the columns that contain the merged cell, select the cell and press Ctrl+Space, when working in Windows or Linux. Or shift Shift+ command_grey Cmd+Space, when working in macOS.

Select a range of columns or rows

To select a small range of columns or rows, follow the steps below:

1.Hover the cursor over the heading of the first item to be selected so that the cursor looks like down_arrow or right_arrow .

2.While holding down the left mouse button, drag the cursor over the headings of the items you want to select.

3.Release the left mouse button.

To select a range of columns or rows that extends beyond the visible area of the spreadsheet, follow these steps:

1.Hover the cursor over the heading of the first item to be selected so that the cursor looks like down_arrow or right_arrow .

2.Select this heading with a left mouse click.

3.Hover the mouse cursor over the heading of the last item to be selected so that it looks like down_arrow or right_arrow . Click the heading while holding down the Shift key.

Select multiple non-adjacent columns or rows (multiple selection)

To select multiple non-adjacent columns or rows at the same time, follow these steps:

1.Select a single column or row or a range of columns or rows.

2.Hold down Ctrl / command_grey Cmd and select a non-adjacent column, row or range in the same way.

In the current version of MyOffice Spreadsheet, only columns or column ranges can be added to selected columns, and only rows or row ranges can be added to selected rows.

3.Without releasing Ctrl / command_grey Cmd, repeat the selection for other columns, rows or ranges that you want to add to the current one.

Multiple selection is reset if you right-click, left-click, or use Ctrl / command_grey Cmd + Right-click combination beyond the selected range.

Multiple selection is also reset when the following operations are invoked:

•Inserting the date or time into the selected cells.

•Merging and unmerging selected cells.

•Setting the protection for the selected cells.

•Recalculating selected cells.

•Applying the Autosum operation to the selected cells.

•Inserting and deleting selected cells with shift.

The operation from the list above will be applied to the row, column or range of rows or columns that was selected last.

Specifics of some operations at multiple selection

Functions block	Action	Outcome
Actions with cells, columns, and rows	Resize selected columns or rows by dragging the heading with the mouse	The same size is set for each selected row or column.
	Automatic selection of column widths or row heights	The size is selected by the cell content with the most data in each selected column or row.
	Setting the exact column width or row height	The entered size is set for each selected row or column.
	Setting the exact cell size	The entered size is set for each cell of the selected rows or columns.
	Insert a column on the left or right	Columns are inserted relative to each selected column. The previous selection is discarded and focus is set on the inserted columns.
	Inserting a row from the bottom or top	Rows are inserted relative to each selected row. The previous selection is discarded and focus is set on the inserted rows.
	Inserting cells with shift	Insertion is performed only for the column or row selected last. The focus remains on the selected range.
	Freezing rows and columns	The selected range is fixed by the lower row or the right-most column.
	Hiding rows and columns	Selected columns / rows are hidden, the behavior of surrounding elements corresponds to hiding under single selection.
	Deleting rows and columns	Columns or rows in which cells are selected are deleted.
	Deleting cells with a shift	Deletion is performed only for the column or row selected last. The focus remains on the selected range.
	Copying cells	Only visible cells in selected columns or rows are copied. The copied range is selected by an additional focus.
	Cutting cells	Only visible cells in selected columns or rows are cut.
Actions with data	Inputting data without double-clicking a cell or inputting using a Formula bar	Data is input into the upper cell of the column selected last or the leftmost cell of the row selected last.
	Inserting a special character	The symbol is input into the upper cell of the column selected last or the leftmost cell of the row selected last.
	Clear cell content	Data is deleted from visible cells in selected columns or rows.
	Deleting links	Links are deleted from all visible cells in the selected columns or rows.
	Number format settings	All operations with numeric formats are available. The settings are applied to all selected cells.
Formatting	Font settings	All operations with fonts are available. The setting is applied to all selected cells.
	Alignment	All alignment operations are available. The setting is applied to all selected cells.
	Filling	The settings are applied to cells in the selected rows or columns.
	Cell border settings	The settings are applied to cells in the selected rows or columns.
	Line wrapping	The setting is applied to the content in the selected cells.
	Copying formatting	Only the formatting of visible cells is copied. If the formatting of the selected cells is the same, the copied formatting is applied in full. Different formatting uses the formatting of the upper-left cell of the selected range.
Formulas and functions	Entering a formula via the Formula bar	The formula is entered in the upper cell of the last column selected or in the left-most cell of the last row selected.
Formulas and functions	Automatic calculation of functions	Automatic calculation is performed using data in selected cells once, overlapping of selected ranges does not affect the calculation.

Was this helpful?

Yes