ExcelBanter - View Single Post - How to make excel auto fill in date and current time

[email protected]

wrote:
Is there a way to make an excel spread sheet with columns that, when
clicking in a cell, will automatically fill in the current date, and in
a different column do the same with the current time? I've looked under
Format Cells, Auto Format, and Conditional Format, and can't find
anything of the sort, but I thought I heard somewhere that this is
possible.

Oh, and to make matter more confusing, at least for me, I still want
the first cells in the columns to have the headers of DATE and TIME.
Is it some kind of formula I need to insert?