We can make a static function NOW using the below methods: ● Once we enter the NOW() in the target cell, press Ctrl + C to copy the function. And then press Alt + E + S + V one after the other to paste the value into the target cell without the formula. Thus, this method will display the cell content as a static value. ● Apply the keyboard shortcut keys to enter the current date and time in the target cell. First press Ctrl + ;, then a space character, and finally press Ctrl + Shift + ;. We will see the current date and time with a space in between. Thus, using these techniques, we can use the NOW() to enter the current date and time. But these values will not get updated every time we make changes in the spreadsheet or open the workbook, thus making the NOW() behave like a static function.