calc short cut keys || important for ccc

Ctrl+Home -Moves the indicator to the primary cell within the sheet (A1).

Ctrl+End -Moves the indicator to the last cell on the sheet that contains information.

Home- Moves the indicator to the primary cell of this row.

End -Moves the indicator to the last cell of this row.

Shift+Home- Selects cells from this cell to the primary cell of this row.

Shift+End -Selects cells from this cell to the last cell of this row.

Shift+Page Up- Selects cells from this cell up to at least one page within the current column or extends the prevailing choice one page up.

Shift+Page Down- Selects cells from this cell all the way down to one page within the current column or extends the prevailing choice one page down.

Ctrl+Left Arrow- Moves the indicator to the left fringe of this information vary. If the column to the left of the cell that contains the indicator is empty, the indicator moves to future column to the left that contains information.

Ctrl+Right Arrow- Moves the indicator to the correct fringe of this information vary. If the column to the correct of the cell that contains the indicator is empty, the indicator moves to future column to the correct that contains information.

Ctrl+Up Arrow- Moves the indicator to the highest fringe of this information vary. If the row higher than the cell that contains the indicator is empty, the indicator moves up to future row that contains information.

Ctrl+Down Arrow -Moves the indicator to the lowest fringe of this information vary. If the row below the cell that contains the indicator is empty, the indicator moves all the way down to future row that contains information.

Ctrl+Shift+Arrow -Selects all cells containing information from this cell to the tip of the continual vary of information cells, within the direction of the arrow ironed. If accustomed choose rows and columns along, an oblong cell vary is chosen.

Ctrl+Page Up- Moves one sheet to the left.

Ctrl+Page Down- Moves one sheet to the proper.

In the print preview: Moves to successive print page.

Alt+Page Up -Moves one screen to the left.

Alt+Page Down -Moves one screen page to the proper.

Shift+Ctrl+Page- Up Adds the previous sheet to the present choice of sheets. If all the sheets in a very program area unit hand-picked, this crosscut key combination solely selects the previous sheet. Makes the previous sheet the present sheet.

Shift+Ctrl+Page Down -Adds successive sheet to the present choice of sheets. If all the sheets in a very program area unit hand-picked, this crosscut key combination solely selects successive sheet. Makes successive sheet the present sheet.

Ctrl+ * -where (*) is that the multiplication sign up the numeric key pad

Selects the information vary that contains the indicator. {a vary|a variety|a spread} may be a contiguous cell range that contains knowledge and is finite by empty row and columns.

Ctrl+ / -where (/) is that the division sign up the numeric key pad

Selects the matrix formula vary that contains the indicator.

Ctrl+Plus key- Insert cells (as in menu Insert - Cells)

Ctrl+Minus key- Delete cells (as in menu Edit - Delete Cells)

Enter (in {a hand-picked|a specific|a particular} vary) Moves the indicator down one cell in a very selected range. To specify the direction that the indicator moves, select Tools - Options' - LibreOffice Calc - General'.

Ctrl+ `- (see note below this table) Displays or hides the formulas rather than the values all told cells.

Function Keys utilized in Spreadsheets

Ctrl+F1 -Displays the comment that's hooked up to the present cell

F2- Switches to Edit mode and places the indicator at the top of the contents of the present cell. Press once more to exit Edit mode.

If the indicator is in associate input hold in a dialog that includes a Minimize button, the dialog is hidden and therefore the input box remains visible. Press F2 once more to point out the total dialog.

Ctrl+F2 -Opens the perform Wizard.

Shift+Ctrl+F2 -Moves the indicator to the Input line wherever you'll enter a formula for the present cell.

Ctrl+F3- Opens the outline Names dialog.

Shift+Ctrl+F4- Shows or Hides the information mortal.

F4 -Rearranges the relative or absolute references (for example, A1, $A$1, $A1, A$1) within the input field.

F5 -Shows or hides the Navigator.

Shift+F5 -Traces dependents.

Shift+F7 -Traces precedents.

Shift+Ctrl+F5- Moves the indicator from the Input line to the Sheet space box.

F7 -Checks writing system within the current sheet.

Ctrl+F7- Opens the wordbook if the present cell contains text.

F8 -Turns further choice mode on or off. during this mode, you'll use the arrow keys to increase the choice. you'll additionally click in another cell to increase the choice.

Ctrl+F8 -Highlights cells containing values.

F9 -Recalculates modified formulas within the current sheet.

Ctrl+Shift+F9- Recalculates all formulas all told sheets.

Ctrl+F9 -Updates the chosen chart.

F11- Opens the designs and data formatting|information|info} window wherever you'll apply a formatting vogue to the contents of the cell or to the present sheet.

Shift+F11 -Creates a document example.

Shift+Ctrl+F11 -Updates the templates.

F12- Groups the chosen knowledge vary.

Ctrl+F12 -Ungroups the chosen knowledge vary.

Alt+Down Arrow- Increases the peak of current row (only in OpenOffice.org heritage compatibility mode).

Alt+Up Arrow -Decreases the peak of current row (only in OpenOffice.org heritage compatibility mode).

Alt+Right Arrow -Increases the breadth of the present column.

Alt+Left Arrow- Decreases the breadth of the present column.

Alt+Shift+Arrow Key- Optimizes the column breadth or row height supported the present cell.

Formatting Cells mistreatment crosscut Keys

The following cell formats are often applied with the keyboard:

Shortcut Keys Effect

Ctrl+1- (not on the quantity pad) Open Format Cells dialog

Ctrl+Shift+1- (not on the quantity pad) Two decimal places, thousands setup

Ctrl+Shift+2 -(not on the quantity pad) Standard exponential format

Ctrl+Shift+3- (not on the quantity pad) Standard date format

Ctrl+Shift+4-- (not on the quantity pad) Standard currency format

Ctrl+Shift+5 -(not on the quantity pad) Standard proportion format (two decimal places)

Ctrl+Shift+6- (not on the quantity pad) Standard format

Using the pivot table

Keys Effect

Tab Changes the main target by moving forwards through the areas and buttons of the dialog.

Shift+Tab -Changes the main target by moving backwards through the areas and buttons of the dialog.

Up Arrow- Moves the main target up one item within the current dialog space.

Down Arrow -Moves the main target down one item within the current dialog space.

Left Arrow- Moves the main target one item to the left within the current dialog space.

Right Arrow -Moves the main target one item to the proper within the current dialog space.

Home -Selects the primary item within the current dialog space.

End- Selects the last item within the current dialog space.

Alt- and therefore the underlined character within the word "Row" Copies or moves the present field into the "Row" space.

Alt and therefore the underlined character within the word "Column" Copies or moves the present field into the "Column" space.

Alt and therefore the underlined character within the word "Data" Copies or moves the present field into the "Data" space.

Ctrl+Up Arrow- Moves the present field up one place.

Ctrl+Down Arrow- Moves the present field down one place.

Ctrl+Left Arrow -Moves the present field one place to the left.

Ctrl+Right Arrow -Moves the present field one place to the proper.

Ctrl+Home Moves -the present field to the primary place.

Ctrl+End Moves- the present field to the last place.

Alt+O Displays- the choices for the present field.

Delete Removes- the present field from the realm.