Browse » Home
Tuesday, April 16, 2013
How to Insert a Dynamic Date and Time in Excel
1. Start Microsoft Excel 2007, and open an existing spreadsheet from your files that you want to insert a dynamic date and time into. Or, start a new, blank spreadsheet.
2. Click to select the cell into which you want to insert the dynamic date and time. The cell will be outlined in a thick, black line indicating it is selected.
3. Use your keyboard to type '=now()' (without the quotation marks) into the selected cell. This is the formula that is used to instruct Excel 2007 to insert the dynamic date and time.
4. Press the 'Enter' key on your keyboard to enter the formula into the selected cell. You will now see the current date and time appear in the cell you typed the formula into. This date and time will update every time the 'Enter' key is pressed while working in Microsoft Excel.
5. Repeat Steps 2 through 4 above to insert the dynamic date and time into any other cells inside the open spreadsheet you would like to display the current date and time.