Edit Menu /text/scalc/00/00000402.xhp

Edit Menu

Choose Edit - Select.

Icon Select Select

Choose Edit - Select - Select all Sheets.

Open context menu of a sheet tab, choose Select all Sheets.

Icon Select all Sheets Select all Sheets

Choose Edit - Select - Select Sheets.

Icon Select Sheets Select Sheets

Choose Edit - Select - Select to Next Sheet.

Choose Edit - Select - Select to Previous Sheet.

Choose Edit - Select - Select Row.

On the Home menu of the Home tab, choose Select Row.

Icon Select Row Select Row

Shift + Space

Choose Edit - Select - Select Column.

On the Home menu of the Home tab, choose Select Column.

Icon Select Column Select Column

CommandCtrl + Space

Choose Edit - Select - Select Data Area.

On the Home menu of the Home tab, choose Select Data Area.

Icon Select Data Area Select Data Area

CommandCtrl + * (asterisk)

Choose Edit - Select - Select Unprotected Cells.

Choose Edit - Select - Select Visible Rows.

Choose Edit - Select - Select Visible Columns.

Choose Edit - Cell Edit Mode.

Choose Sheet - Fill Cells.

Choose Sheet - Fill Cells - Fill Down.

Icon Fill Down Fill Down

CommandCtrl + D

Choose Sheet - Fill Cells - Fill Right.

Icon Fill Right Fill Right

Choose Sheet - Fill Cells - Fill Up.

Icon Fill Up Fill Up

Choose Sheet - Fill Cells - Fill Left.

Icon Fill Left Fill Left

Choose Sheet - Fill Cells - Fill Sheets.

Choose Sheet - Fill Cells - Fill Series.

Choose Sheet - Fill Cells - Fill Random Number

Choose Sheet - Clear Cells.

Choose Clear Contents.

Icon Clear Cells Clear Cells

Backspace

Choose Sheet - Delete Cells.

Choose Delete Cells.

On the Layout menu of the Layout tab, choose Delete.

Icon Delete Cells Delete Cells

CommandCtrl + "-"

Choose Edit - Cell Protection to activate sheet protection with current cell protection settings.