View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] alice@fearofdolls.com is offline
external usenet poster
 
Posts: 6
Default How to make excel auto fill in date and current time

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.