Excel Tips
GetPivotData() Functions in Excel XP »
February 4, 2004
Formula pointing at a cell inside the pivot table keeps pointing at the original cell when copying the formula down to the next rows.
Bug with Rand() in Excel 2003 »
December 11, 2003
Excel RAND function bug causes it to return negative results.
Lock a Range of Cells in Excel »
August 25, 2003
How to lock only a particular range of cells along with the formula instead of locking the entire sheet.
Change the Column Headers in Excel »
June 25, 2003
Go back to the usual "Lotus 1-2-3" reference style in Excel.
Using Circular References to our Advantage »
May 30, 2003
Usually, circular references are a bad thing, but sometimes they can be used to our advantage. Here is the non-macro way of doing what you want to do.
Format Existing Numbers as Text »
May 29, 2003
How to format existing numbers as text without having to tap F2 and Enter for every cell.
May 28, 2003
How to use macro recorder to write my own routine to automate what I need.
May 27, 2003
Freezing panes in Excel to see the top row as heading when scrolling.