Open office: Difference between revisions
Jump to navigation
Jump to search
(→Tips) |
|||
| Line 12: | Line 12: | ||
# Drag row/column by clicking in the selected area (''NOT'' on header) |
# Drag row/column by clicking in the selected area (''NOT'' on header) |
||
# Hold '''ALT''' to insert where you want it to be |
# 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''). |
|||
Revision as of 19:54, 22 July 2010
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]:
- Click row/column head
- Drag row/column by clicking in the selected area (NOT on header)
- 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).