How can I delete cell contents immediately with the Delete key like in Excel?
From Apache OpenOffice Wiki
< Documentation | FAQ | Calc | Miscellaneous
How can I delete cell contents immediately with the Delete key like in Excel?
If you press Delete in Calc, you get by default a Delete window that lets you delete formats, text, formulas and/or other elements. And to delete cell contents immediately you have to press Backspace.
If you want to use the Delete key for immediate deletion you have to do the following:
- Choose Tools → Customize, Keyboard tab. Be sure that the Calc radio button is selected.
- In the Shortcut Keys area of the window at the top, select "Delete". In the Functions area of the window at the bottom: under Category select "Edit", and under Function select the FIRST of the two "Delete Contents" items. This is the one that just deletes, with no window.
- Click the Modify button. In the Functions area you will see "Delete" now listed as a key.
- If you don't want Backspace to delete contents, then select "Backspace" in the Keys list in the lower right corner and click the Delete button.
- Now scroll through the Shortcut Keys list at the top and select "Backspace" as the function you want to use to bring up the Delete window.
- Then in the lower part of the window, as before, under Category select "Edit" and under Function select the SECOND "Delete Contents" item.
- Click the Modify button to bring up the interactive Delete window by pressing the ← Backspace key.
This FAQ comes from Solveig Haugland's Blog
Content on this page is licensed under the Public Documentation License (PDL). |