Hannah says showing formulae view is easy

Someone's going to have forgotten how to do this...

Hannah says here's the way to do it:

1. is your sheet saved? Good.
2. hold the shift key down. Don't let it go, even if a bee is about to land on your nose.
3. look at the top left hand corner of the keyboard. Find the Esc key. DON'T TOUCH IT
4. look underneath it. You'll find a wierd looking key that only Mr Bagshaw (and other sad geeks) know the name of
5. that's the key you want
6. I call it the Star Wars button because I don't have a better name for it
7. still holding shift down? Good
8. tap - ONCE - the Star Wars button. Feel the force? Excellent!
9. see the formulae? Kewl!

To toggle back again all you need to do is Shift-Star Wars and it'll go back again.

You might need to twiddle around with column widths to show the formulae of course. Beware if you try and toggle back - you'd be better off saving under a different file name before you try and toggle back if you've changed too many column widths.

Hannah says hands that do dishes, they can be as soft as your face...

Hannah decides to do some concatenation

Concatenation is when you link stuff together in a cell.

For example, you might link cells A2 and B2 together using

=A2 &" " &B2

The ampersands (the & thingie) do the linking. The " " just adds a space between the two cell contents. If A2 and B2 had forename and surname in then that might produce a more useful cell to use.

There's an example of how to use concatenation to produce a cool and funky order number at That Blue Square Thing. Check it out, it's cool and funky and there are no chickens to be seen.

Hannah says concatenation is cool.

e2a: I've not thrown the macro code in as a screenshot as well. Just because I'm feeling kind.

Hannah says decompiling flash files is fun...

So, let's say your Flash file is corrupt, but you do still have the swf file.

Now, I know what you're thinking. What kind of doofus doesn't keep a back up of their flash file each time they save it eh? Hmm...

Anyway - it is possible to recover some of the fla - maybe not the Action Script, but at least some of the other bits and pieces.

Hannah says she knows someone who knows someone who used the SWF Decompiler from SourceTec software in the free 30 day trial mode. If you pay it might even be able to get he action script for you (apparently - I know nothing about whether this is true, and neither does Hannah).

Hannah says always keep a backup of your fla files. Hannah also says crumbs DM...

Hannah says dates in Excel are easy

Hannah says, if you want to get an updating date in Excel then it's quite similar to how it works in Access!

All you need is =now() in a cell and it'll sort out the date for you. You can format it to change what's included (Grace says you can also use =today() - but not =date() because that works differently.

You can also, just like in Access, use =now()+7 for example.

Hannah says you get the best of both worlds. Grace, otoh, says sweet niblets.

Hannah says how do I find the command button in Excel 2007

This is specially for Hannah who couldn't find the command button...

http://office.microsoft.com/en-us/excel/HP102366761033.aspx

Aye carumba!

Hannah's Guide to Excel Keyboard Shortcut Heaven

Hannah says...

• Showing Formulas: Ctrl+Star Wars (the star wars button being the odd one without a name underneath Escape in the top left of the keyboard). Think: control the force... :-)
• Showing Macro Code: Alt+F11. You might then need to navigate to the different sheets and modules in the left window pane.
• Spell Checking: F7

Hannah says Cowabunga