• Join
  • Meeting Times and Locations
    • Caloundra Technology Education Centre
    • Buderim Technology Education Centre
  • Contact Us
  • Q and A
  • Free Resourses
    • Security Basics
    • WiFi Safety Guide
    • Open Office Tutorials
    • Apple Tutorials
    • Stress Management
    • The Gimp Tutorial Videos
    • Members Website Design Group
  • Interests Supported
    • Linux Operating Systems
    • Apple Mac Operating Systems
    • DIY Website Design and Marketing
    • Graphics & Digital Image Manipulation (Including Slide Shows)
  • Articles
    • Newest Articles
    • Article Index
    • Magazine Bits’N’Bytes Library
    • Health and Environmental Effects of Technology
    • Computer Security
    • Open Office
    • Audio and Sound
    • Linux
    • Buying and Selling on Ebay
    • Web Artist, Basic Web Page Creation
    • The Food Lab
    • Daily Local Background Radiation Levels and Advisories
  • Members Websites

Open Office Calc – Deleting from a Cell or Cells

By
Thursday, March 31st, 2011

Open Office Spreadsheet – Deleting from a Cell or Cells

 

 

(This blog was written for versions of OpenOffice up to Version 3.4.0)

 

 

 

Save a bit of time and effort when working on an Open Office Spreadsheet and needing to delete the contents from a cell. Click the cell (to make the cell active) - Pressing on the Del(ete) key on the Keyboard brings up the Window 'Delete Contents' with a list of options – Delete all, Text, Numbers, Date and time, Formulas, Notes, Formats, Objects.  Generally from Text down to Notes have a tick in the boxes beside them.  Click on the OK button and all contents of the cell will be removed.

 

A much easier and quicker way is available. Click in the cell (to make the cell active) – then press the Backspace Key on the Keyboard (instead of the Del(ete) key on the keyboard). This clears the contents of the cell.

 

If you want to clear a number of adjacent cells - hold the Shift Key down and select all the cells you want to clear (this highlights all the cells) – then press the Backspace Key.  The contents of all the cells selected will be deleted.

Categories : Open Office

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Recent Posts

  • PhoneGate Alert Update 2020!
  • Social Distancing Is Very Important!
  • Coronavirus COVID-19 & Flu Season, first line of defense!
  • Potential 110 Times Regulatory Exposure Limit For Children!
  • Modern Technology Eroding Freedom, Privacy and Health!
  • Legal Opinion & Duty of Care

The Food Lab

Subscribe for Periodic Alerts & Updates from The Food Lab on Radiation Contamination Testing in Food and the Environment
Please Ceck Your Email after Subscribing to Validate your Email Subscription.

Categories

 

Sunshine Coast Computer Club
Copyright © 2021 All Rights Reserved
Website Design by Website Design Centre
Powered by WordPress