How to quickly insert timestamp in Excel?
When you are creating an invoice or schedule in Excel, you may want to insert the current date or the current time, and this date and time just only a timestamp which will not be changed. We all know the formulas =TODAY() and =NOW() will insert the current date and time, but the problem is that the date and time will be updated automatically when you refresh the current worksheet. Here I introduce the easy shortcuts which can help you quickly insert current timestamp in Excel.
Insert Workbook Information
|Kutools for Excel's Insert Workbook Information utility can quickly insert sheet name, path, user name and
so on to a cell, header or footer.
Recommended Excel Productivity Tools
To insert current timestamp, you can use the shortcuts -- Ctrl + ; and Ctrl + Shift +:.
|Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.|
Press Ctrl + ; to insert current date :
Press Ctrl + Shift + : to insert current time timestamp: