Suppose your Microsoft Excel workbook contains 10
worksheets, and you want to add a time and date stamp to each worksheet. You
could manually enter a time and date formula into a cell in each worksheet, or
you can create a named formula that can enter the current date and time without
having to retype the formula.
To create the named formula, follow these steps:
- Enter DateStamp in the Names In
Workbook text box.
- In the
Refers To text box, enter the following formula:
” ” & TEXT(NOW(),”h:mm
the Add button and then click OK.
Now you can add a time and date stamp to every worksheet in
your workbook by typing =DateStamp in any cell.
Miss a tip?
Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.
Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.
Subscribe to the Developer Insider Newsletter
From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you need to know. Delivered Tuesdays and Thursdays