Table 2: Selected Excel and Calc default keyboard shortcuts
Function
Excel Shortcut
Calc Shortcut
Rearranges the relative or absolute references (for example, A1, $A$1, $A1, A$1) in the input field
F4
Shift+F4
Edit cell comment (known as “notes” in Calc)
Shift+F2
Control+F1
Fill right or Fill down
Control+R or Control+D
No equivalent
Go to specific cell
F5
F5 (shows Navigator)
Insert Function
No standard equivalent
Control+F2
Enter into all currently selected cells
Control+Enter
Alt+Enter
Alt+Shift+Enter (also applies the cell format)
In both cases cells must be contiguous.
