Most people overlook the row of function keys at the top of their keyboard. They often ignore, misunderstand, or underuse them. If you work with Excel spreadsheets regularly, those F-keys can be your ...

In October of 2001 , we described in this column how to use the dollar sign ($) to make an Excel formula constant—so when you copy a formula to a different location on a spreadsheet it won’t ...