Desktop apps

How to edit a cell in Excel or Openoffice

This was one of those things that bugged me for ages but because I wasn’t sure of the terminology I could never find an answer for it. How do I edit a cell in Openoffice without doing either of the following?

  1. Double clicking on the cell.
  2. Clicking on the cell, then clicking on the edit bar at the top of the window.

The answer is quite simple, and it’s probably in some FAQ somewhere but each time I had a want to find it, I would have been up to my eyeballs in receipts working on my VAT return. Luckily, Lifehacker linked to this Excel keystrokes post which has a couple of magic key combos but look in the comments for the real meat.

How do I edit a cell in my spreadsheet? Hit F2.

F2 F2 F2 F2

Hit the F2 key to edit a cell. When I first discovered this keystroke, it was like the clouds parted and the light of God beamed down on my keyboard. Give it a shot right now if you haven’t used the F2 key before. (Hint: it will allow you to edit the data in the selected cell)

Desktop apps

Excel password remover

If, as sometimes happens, you’re working at something and are called away from your desk, it’s nice to know you can lock Excel and stop others fiddling with it. Unfortunately it’s also possible that you might forget your password. *ahem*
If so, go download the Free Excel password remover and watch it work wonders and crack that password and get you back into work mode faster than you can read a long winded run-on sentence that’s meandering nowhere, fast.