Excel Tips
Protecting a Single Cell in Excel »
September 5, 2004
Is it possible to protect a single cell in an Excel worksheet without protecting the whole worksheet?
May 30, 2004
Excel stores times in an interesting way. Each 24 hour period is equivalent to the number 1. 6AM is actually stored as 0.25. Noon is 0.5. 6PM is 0.75. We see a time on the Excel spreadsheet because the cell is formatted with a time format.
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.