Find out how to use the various lookup and reference functions, learn about constructing charts and graphs, read up on data validation tools, and more. Scroll through the options, pick the format you want, and then click OK.įor more tips and tricks, take a look at the other items in Bright Hub’s collection of Microsoft Excel user guides and tutorials, including this Excel function guide. When the Format Cells window appears on your screen, click on the Number tab and select Time from the Category list. That is, after entering NOW( ), right-click on the cell and select Format Cells. If you only want to display the time, you can still use the NOW function and reformat the cell so that only the time portion of the information appears. Similarly, the NOW function uses the syntax NOW( ), and it displays both the date and time. It will display the current date as shown below. The TODAY function has a very simple syntax: TODAY( ). For these cases, we can use the TODAY and NOW functions. There are other times when you may want to enter the current date and/or time so that it updates whenever the spreadsheet is recalculated. Method 2: Automatically Updating Date and Time Stamp See the article Changing Date Formats in Excel for more information. If you want to change these formats, you can do so in the standard manner. Note that these values will be displayed in the default format shown in the screenshot below. Next, press Ctrl + Shift + and hit Enter. Time Only – Select the cell, press Ctrl + Shift + and then hit Enter.ĭate and Time – If you want both the current date and time to appear in the cell, press Ctrl + (semi-colon) and then hit the space bar.
If you want to input the current date and/or time into a cell of an Excel spreadsheet in such a manner that it does not update whenever changes are made to that sheet, you can use one of the following command sequences.ĭate Only – Select the cell to which you want to add the date, press Ctrl + (the semi-colon key), and then hit Enter.
That is, do you want whatever is entered now to remain fixed as a mark of the date and time that a task was accomplished? Or, do you want the cell to refresh with new data each time the spreadsheet is used? We’ll look at both cases. Before choosing a method, you should first decide if you want that date and time to be updated each time the spreadsheet is recalculated. There are a few different ways to insert the current date and time into an Excel spreadsheet.