Posted on

This won't help the diet

diet

An advert in the Lifehacker RSS feed tells people how to lose stomach fat. Good thing too. The next post tells people how to put it on…

Could this be an evil plan by the Lifehacker folks to get more ad clicks? It’s a devious idea of course, and subtle but I’ll be keeping a close eye on future posts!

Posted on

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)