How-To Geek on MSN

Stop using format painter in Excel: Find and replace formatting instead

First, set up a model cell with the replacement formatting. Next, press Ctrl+H to launch the Find and Replace dialog. There, define both the Find What and Replace With formatting by clicking "Choose ...
PC World

Meet DATEDIF(), Excel’s secret Date & Time function that’s still handy

DATEDIF(), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000, which is the only version that explains how this function works.