View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How do I automatically enter a time and date?

Either of two methods for automatic entry.

1. Double-click on a cell to enter time and date.

2. Enter data in one cell and date and time appear in another cell.

Manually...........Hold CTRL + ; then <space then CTRL + SHIFT + ; then ENTER

Post back for event code for 1 or 2

2 is easist........no clicking.


Gord Dibben MS Excel MVP

On Fri, 28 Sep 2007 11:31:02 -0700, Wayne
wrote:

I am trying to track calls that my sales staff makes on leads that I supply
them. Can anyone tell me how to set a column that automatically inserts a
date and time by just clicking on it? For example:
Name Of Borrower Lead Source Date and Time Called Result Notes