By | August 14, 2017
LibreOffice Calc

LibreOffice Calc is the spreadsheet element of the LibreOffice software program bundle.After forking from OpenOffice.org in 2010, LibreOffice Calc underwent a big re-work of external reference dealing with to restoration a massive wide variety of defects in formula calculations related to external references, and to boost data caching performance specially when referencing large statistics ranges.


LibreOffice Calc Shortcut Keys

Shortcut Key Information
Ctrl + – Delete cells
Ctrl + F2 Insert Fields
Ctrl + Home Moves the cursor to the first cell in the sheet (A1). Navigating
Ctrl + End Moves the cursor to the last cell on the sheet that contains data. na
Home Moves the cursor to the first cell of the current row. Navigating
End Moves the cursor to the last cell of the current row Navigating
Shift + Home Selects cells from the current cell to the first cell of the current row. Navigating
Shift + End Selects cells from the current cell to the last cell of the current row. Navigating
Shift + Top Arrow Selects cells from the current cell up to one page in the current column or extends the existing selection one page up. Navigating
Shift + PgDN Selects cells from the current cell down to one page in the current column or extends the existing selection one page down.
Ctrl + < Moves the cursor to the left edge of the current data range. If the column to the left of the cell that contains the cursor is empty, the cursor moves to the next column to the left that contains data. Navigating
Ctrl + > Moves the cursor to the right edge of the current data range. If the column to the right of the cell that contains the cursor is empty, the cursor moves to the next column to the right that contains data. Navigating
Ctrl + Top Arrow Moves the cursor to the top edge of the current data range. If the row above the cell that contains the cursor is empty, the cursor moves up to the next row that contains data.
Ctrl + Bottom Arro Moves the cursor to the bottom edge of the current data range. If the row below the cell that contains the cursor is empty, the cursor moves down to the next row that contains data. Navigating
Ctrl + Shift + > Selects all cells containing data from the current cell to the end of the continuous range of data cells, in the direction of the arrow pressed. If used to select rows and columns together, a rectangular cell range is selected. Navigating
Ctrl + PgUp Moves one sheet to the left. In the print preview: Moves to the previous print page. Navigating
Ctrl + PgDN Moves one sheet to the right. In the print preview: Moves to the next print page. Navigating
Alt + PgUp Moves one screen to the left. Navigating
Alt + PgDN Moves one screen page to the right. Navigating
Ctrl + Shift + PgUp Adds the previous sheet to the current selection of sheets. If all the sheets in a spreadsheet are selected, this shortcut key combination only selects the previous sheet. Makes the previous sheet the current sheet. Navigating
Shift + Ctrl + PgDN Adds the next sheet to the current selection of sheets. If all the sheets in a spreadsheet are selected, this shortcut key combination only selects the next sheet. Makes the next sheet the current sheet. Navigating
Ctrl + * where (*) is the multiplication sign on the numeric key pad Selects the data range that contains the cursor. A range is a contiguous cell range that contains data and is bounded by empty row and columns. Navigating
Ctrl + / where (/) is the division sign on the numeric key pad Selects the matrix formula range that contains the cursor. Navigating
Ctrl + + Insert cells (as in menu Insert – Cells) Navigating
Ctrl + – Delete cells (as in menu Edit – Delete Cells) Navigating
Ctrl + F1 Displays the comment that is attached to the current cell Function Keys
End https://help.libreoffice.org/Calc/Shortcut_Keys_for_Spreadsheets Function Keys
Ctrl + F2 Opens the Function Wizard.
Ctrl + Shift + F2 Moves the cursor to the Input line where you can enter a formula for the current cell. Function Keys
Ctrl + Delete Opens the Define Names dialog. Function Keys
Ctrl + Shift + End Shows or Hides the Database explorer. Function Keys
Backspace Rearranges the relative or absolute references (for example, A1, $A$1, $A1, A$1) in the input field. Function Keys
F5 Shows or hides the Navigator. Function Keys
Shift + F5 Traces dependents. Function Keys
Shift + F7 Traces precedents. Function Keys
Shift + Ctrl + F5 Moves the cursor from the Input line to the Sheet area box. Function Keys
F7 Checks spelling in the current sheet. Function Keys
Ctrl + F7 Opens the Thesaurus if the current cell contains text. Function Keys
Ctrl + F8 Turns additional selection mode on or off. In this mode, you can use the arrow keys to extend the selection. You can also click in another cell to extend the selection. Ctrl+F8 Highlights cells containing values. Function Keys
F9 Recalculates changed formulas in the current sheet. Function Keys
Ctrl + Shift + F9 Recalculates all formulas in all sheets. Function Keys
Ctrl + F9 Updates the selected chart. Function Keys
F11 Opens the Styles and Formatting window where you can apply a formatting style to the contents of the cell or to the current sheet. Function Keys
Shift + F11 Creates a document template. Function Keys
Shift + Ctrl + F11 Updates the templates. Function Keys
F12 Groups the selected data range. Function Keys
Ctrl + F12 Ungroups the selected data range. Function Keys
Alt + Bottom Arrow Increases the height of current row (only in OpenOffice.org legacy compatibility mode). Function Keys
Alt + Top Arrow Decreases the height of current row (only in OpenOffice.org legacy compatibility mode). Function Keys
Alt + > Increases the width of the current column. Function Keys
Alt + < Decreases the width of the current column. Function Keys
Alt + Shift + > Optimizes the column width or row height based on the current cell. Function Keys
Ctrl + 1 Open Format Cells dialog Formatting Cells
Ctrl + Shift + 1 Two decimal places, thousands separator Formatting Cells
Ctrl + Shift + 2 Standard exponential format Formatting Cells
Ctrl + Shift + 3 Standard date format Formatting Cells
Ctrl + Shift + 4 Standard currency format Formatting Cells
Ctrl + Shift + 5 Standard percentage format (two decimal places) Formatting Cells
Ctrl + Shift + 6 Standard format Formatting Cells
Tab Changes the focus by moving forwards through the areas and buttons of the dialog. the pivot table
Shift + Tab Changes the focus by moving backwards through the areas and buttons of the dialog. the pivot table
Top Arrow Moves the focus up one item in the current dialog area. the pivot table
Bottom Arrow Moves the focus down one item in the current dialog area. the pivot table
Left Arrow Moves the focus one item to the left in the current dialog area. the pivot table
Right Arrow Moves the focus one item to the right in the current dialog area. the pivot table
Home Selects the first item in the current dialog area. the pivot table
End Selects the last item in the current dialog area. the pivot table
Alt Copies or moves the current field into the “Row” area. the pivot table
Ctrl + Top Arrow Moves the current field up one place. the pivot table
Ctrl + Bottom Arrow Moves the current field down one place. the pivot table
Ctrl + < Moves the current field one place to the left. the pivot table
Ctrl + > Moves the current field one place to the right. the pivot table
Ctrl + Home Moves the current field to the first place. the pivot table
Ctrl + End Moves the current field to the last place. the pivot table
Ctrl + O Displays the options for the current field. the pivot table
Delete Removes the current field from the area. the pivot table

342 total views, 1 views today