If the cursor is in an input box in a dialog that has a minimize button Switches to Edit mode and places the cursor at the end of the contents of the current cell. When the help browser is already open F1 jumps to the main help page.ĭisplays the note that is attached to the current cell. The / key is the division sign on the numeric key pad.ĭisplays the OOo help browser. Selects the matrix formula range that contains the cursor.

The * key is the multiplication sign on the numeric key pad. A range is a contiguous cell range that contains data and is bounded by empty row and columns.

Selects the data range that contains the cursor. If all the sheets in a spreadsheet are selected If all the sheets in a spreadsheet are selectedĪdds the next sheet to the current selection of sheets. Moves the viewable columns one screen to the right.Īdds the previous sheet to the current selection of sheets. Moves the viewable columns one screen to the left. In the page preview it moves to the next print page. In the page preview it moves to the previous print page. Selects all cells containing data from the current cell to the end of the continuous range of data cells If the row below the cell that contains the cursor is empty Moves the cursor to the bottom edge of the current data range.

If the row above the cell that contains the cursor is empty Moves the cursor to the top edge of the current data range. If the column to the right of the cell that contains the cursor is empty Moves the cursor to the right edge of the current data range. If the column to the left of the cell that contains the cursor is empty Moves the cursor to the left edge of the current data range. Moves the cursor to the last cell of the current row in a column containing data. Moves the cursor to the first cell of the current row.

Moves the cursor to the last cell on the sheet that contains data. Moves the cursor to the first cell in the sheet (A1).

How to freeze a row in openoffice excel