neulaha.blogg.se

Turns additional selection mode on or off. Recalculates all of the formulas in the sheet. Optimizes the column width or row height based on the current cell. Increases the width of the current column. Moves the cursor to the input line where you can enter a formula for the current cell. 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. The / key is the division sign on the numeric key pad.ĭisplays the note that is attached to the current cell. 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).