LibreOffice Calc Shortcut Keys

LibreOffice Calc Shortcut Keys


Note for Mac users

Some keystrokes and menu items are different on a Mac from those used in Windows and Linux. The table below gives some common substitutions for the instructions in this chapter. For a more detailed list, see the application Help.


Windows or Linux
Mac equivalent
Effect
Tools > Options menu selection
LibreOffice > Preferences
Access setup options
Right-click
Control+click
Opens a context menu
Ctrl (Control)
⌘ (Command)
Used with other keys
F5
Shift+⌘+F5
Opens the Navigator
F11
⌘+T
Opens the Styles and Formatting window


Navigation and selection shortcuts


Shortcut Keys
Effect
Ctrl+Home
Moves the cursor to the first cell in the sheet (cell A1).
Ctrl+End
Moves the cursor to the last cell on the sheet that contains data.
Home
Moves the cursor to the first cell of the current row.
End
Moves the cursor to the last cell of the current row in a column containing data.
Ctrl+Left Arrow
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.
Ctrl+Right Arrow
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.
Ctrl+Up 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+Down Arrow
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.
Ctrl+Shift+Arrow
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.
Ctrl+Page Up
Moves one sheet to the left. In the page preview it moves to the previous print page.
Ctrl+Page Down
Moves one sheet to the right. In the page preview it moves to the next print page.
Page Up
Moves the viewable rows up one screen.
Page Down
Moves the viewable rows down one screen.
Alt+Page Up
Moves the viewable columns one screen to the left.
Alt+Page Down
Moves the viewable columns one screen to the right.
Shift+Ctrl+Page Up
Adds the previous sheet to the current selection of sheets. If all the sheets in a spreadsheet are selected, this combination only selects the previous sheet. Makes the previous sheet the current sheet.
Shift+Ctrl+Page Down
Adds the next sheet to the current selection of sheets. If all the sheets in a spreadsheet are selected, this combination only selects the next sheet. Makes the next sheet the current sheet.
Ctrl+*
Selects the data range that contains the cursor. A range is a contiguous cell range that contains data and is bounded by empty rows and columns. The “*” key is the multiplication sign on the numeric key pad.
Ctrl+/
Selects the matrix formula range that contains the cursor. The “/” key is the division sign on the numeric key pad.
Enter — in a selected range
By default, moves the cursor down one cell in a selected range. To specify the direction that the cursor moves, choose Tools > Options > LibreOffice Calc > General.


Function key shortcuts


Shortcut Keys
Effect
F1
Displays the LibreOffice help browser. When the help browser is already open F1 jumps to the main help page.
Shift+F1
Displays context help.
Ctrl+F1
Displays the comment that is attached to the current cell.
F2
of the current cell. If the cursor is in an input box in a dialog that has a minimize button, the dialog is hidden and the input box remains visible. Press F2 again to show the whole dialog.
Ctrl+F2
Opens the Function Wizard.
Shift+Ctrl+F2
Moves the cursor to the input line where you can enter a formula for the current cell.
Ctrl+F3
Opens the Manage Names dialog.
Shift+F3
Switches between Upper Initials, UPPER and lower cases modes.
F4
Shows or hides the Database Sources pane.
Shift+F4
Rearranges the relative or absolute references (for example, A1, $A$1,$A1, A$1) in the input field.
F5
Shows or hides the Navigator.
Shift+F5
Traces dependents.
Shift+Ctrl+F5
Moves the cursor to the Name box.
F7
Checks spelling in the current sheet.
Ctrl+F7
Opens the Thesaurus if the current cell contains text.
Shift+F7
Traces precedents.
F8
Switches between the standard and extended selection modes. In this mode, you can use the arrow keys to extend the selection. You can also click in another cell to extend the selection.
Shift+F8
Switches between the standard and add selection modes. In this mode, you can easily add individual cells to a range.
Ctrl+F8
Highlights cells containing numeric values (not text) blue, and formulas (text or number) green, or stop this highlight.
F9
Recalculates all of the formulas in the sheet.
Ctrl+F9
Updates the selected chart.
F11 (Command+T on Mac)
Opens the Styles and Formatting window where you can apply a formatting style to the contents of the cell or to the current sheet.
F12
Groups the selected data range.
Ctrl+F12
Ungroups the selected data range.

Arrow key shortcuts


Shortcut Keys
Effect
Alt+Down Arrow
Increases the height of current row.
Alt+Up Arrow
Decreases the height of current row.
Alt+Shift+Arrow Key
Optimizes the column width or row height based on the current cell.


Cell formatting shortcuts

Ctrl+1 opens the Format Cells dialog.

Shortcut Keys
Effect
Ctrl+Shift+1
Two decimal places, thousands separator
Ctrl+Shift+2
Standard exponential format
Ctrl+Shift+3
Standard date format
Ctrl+Shift+4
Standard currency format
Ctrl+Shift+5
Standard percentage format (two decimal places)
Ctrl+Shift+6
Standard format


Pivot table shortcuts


Shortcut Keys
Effect
Tab
Changes the focus by moving forward through the areas and buttons of the dialog.
Shift+Tab
Changes the focus by moving backward through the areas and buttons of the dialog.
Up arrow
Moves the focus up one item in the current dialog area.
Down arrow
Moves the focus down one item in the current dialog area.
Left arrow
Moves the focus one item to the left in the current dialog area.
Right arrow
Moves the focus one item to the right in the current dialog area.
Home
Selects the first field in the current layout area.
End
Selects the last field in the current layout area.
Alt+R
Copies or moves the current field into the “Row” area.
Alt+C
Copies or moves the current field into the “Column” area.
Alt+D
Copies or moves the current field into the “Data” area.
Ctrl+Up Arrow
Moves the current field up one place.
Ctrl+Down Arrow
Moves the current field down one place.
Ctrl+Left Arrow
Moves the current field one place to the left
Ctrl+Right Arrow
Moves the current field one place to the right.
Ctrl+Home
Moves the current field to the first place.
Ctrl+End
Move the current field to the last place.
Alt+O
Displays the options for the current field
Delete
Removes the current field from the area.


Chart shortcuts


Shortcut Keys
Effect
Tab
Selects next object.
Shift+Tab
Selects previous object.
Home
Selects first object.
End
Selects last object.
Esc
Cancels selection.
Arrow keys
Moves the object in the direction of the arrow.
Arrow keys in pie charts
Moves the selected pie segment in the direction of the arrow.
F2 in titles
Enters text input mode.
F3
Opens group so you can edit the individual components (in legend and data series).
Ctrl+F3
Exits group (in legend and data series).
+/–
Enlarges or reduces the chart.
+/– in pie charts
Moves the selected pie segment off or into the pie chart.


CCC Online Test , CCC MCQ Python Programming Tutorials Best Computer Training Institute in Prayagraj (Allahabad) O Level NIELIT Study material and Quiz career counselling in allahabad Website development Company in Allahabad