Open office

Tips

Calc — Remove the delete confirmation box

By default, backspace is mapped to immediate deletion, and delete to open a dialog box with different delete options.

This can be changed in menu Tools → Customize..., panel Keyboard. (Make sure Calc radio button is selected), pick Category Edit:

• 1st Function Delete Contents is the one showing dialog box (default Delete)
• 2nd Function Delete Contents is the one that deletes without confirmation (default Backspace)

Calc — Move rows or columns

See [1]:

1. Click row/column head
2. Drag row/column by clicking in the selected area (NOT on header)
3. Hold ALT to insert where you want it to be

Note that ALT+drag may conflict in Gnome with shortcut to move Windows (see Preferences → Windows → Windows movement).