Difference between revisions of "Documentation/FAQ/Calc/Miscellaneous/How can I delete cell contents immediately with the backspace key like in Excel?"
From Apache OpenOffice Wiki
< Documentation | FAQ | Calc | Miscellaneous
m |
m |
||
Line 9: | Line 9: | ||
If you want to use the Delete key for immediate deletion you have to do the following: | If you want to use the Delete key for immediate deletion you have to do the following: | ||
− | # Choose | + | # Choose {{menu|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. | # 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 | + | # Click the {{button|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 | + | # If you don't want Backspace to delete contents, then select "Backspace" in the Keys list in the lower right corner and click the {{button|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. | # 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. | # 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 | + | # Click the {{button|Modify}} button to bring up the interactive Delete window by pressing the {{key|Backspace}} key. |
<section end=answer/> | <section end=answer/> | ||
Revision as of 13:18, 17 March 2021
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). |