excel: pasting only visible cells

Ever tried to paste a range of cells in Excel that included hidden cells, but you didn’t want the hidden stuff? This works: Now Who Told Excel To Paste That Data?

“paste special: values” is special

This saved me a bunch of time yesterday when I was pasting many sets of values into a spreadsheet: Daily Dose of Excel » Blog Archive » Mouse shortcuts.

amalgam squidge

Got yet more mercury alloy trowelled into my head tonight by Dr Choi. I have to say, the best bit about going to the dentist is the squidgy noise the filling paste makes as it compresses into the cavity. It means it’s nearly over, and the burring slow drill is banished until next time.