![]() It’s a dynamic date/time that changes every time Excel refreshes the worksheet.Īgain, there are three options. ![]() Other times you want Excel to use the date or time right now. Mac shortcuts:Īs with most Office for Mac shortcuts, they are the same as Office for Windows except you use the Command key ⌘ instead of Control.Ĭommand ⌘ + Shift + insert current timeĬommand ⌘ + then a space, Command ⌘ + Shift + the space is required. You can combine the two to insert both date and time:Ĭtrl + then a space, Ctrl + Shift + the space is required. It’s useful for ‘live’ data entry when you’re updating a worksheet with the today’s sale figures, attendance or whatever.Įxcel enters the current Excel date/time value (ie counting from 1900) see THE TRUTH BEHIND EXCEL DATES, TIME AND DURATION and the table above. ![]() Once typed, the date/time does NOT change. They put into the Excel cell the date/time as you type it. There are long-standing shortcuts to type in the current date/time.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |