Shortcut key to type current date in excel cell [Static]
Static changes are those which does not change by opening or refreshing the excel sheet. That means once a value is typed in then it will remain as is until you or the VBA code does not change it.
If you want to enter the current date into a Cell then need not remember the Current Date or current time and Type it in the Cell. You Just Need to press the following shortcuts:
To enter current date in a cell
Select the Cell and Press Ctrl + ; (semicolon)
To enter current time in a cell
Select the Cell and Press Ctrl + Shift + ; (semicolon)
To enter current date and time both in a cell
Select the Cell and Press Ctrl + ; (semicolon) then press space bar then press Ctrl + Shift + ; (semicolon)
0 Comments