Tips

Today I’ve experienced, again, the problem with Excel that it was calculating formulas only after clicking save, not while entering data. As it was pretty annoying I’ve googled the solution, it was for some ancient version of Excel, but I was able to adjust it to 2010 version. Here you go:

1. Go to **Formulas **-> Calculation Options.
2. Set it to Automatic.

It switches to manual if you open Excel file where somebody set it like that. Why people are doing it, I don’t know. Enjoy!

Quick note how to list files without directories.

Windows:
dir /a:-d

Linux:
ls -l | grep ^-

Second command should work also in Mac OS X from terminal, but will have to check it just to be sure.

As newbie Mac OS user I’ve faced problem “where the f**k are page up, page down, etc. keys?”. A little of exploration and here it is (MacBook Pro):
fn + arrow down = page down
fn + arrow up = page up
cmd + arrow down = end
cmd + arrow up = home
fn + backspace = delete (this is quite annoying that on PC I’ve had one button for that)