ctrl+shift+;

Copper Contributor

excel

ctrl+shift+; instead of entering the date, copy the contents of the cell above 

pls help thanks

1 Reply
So what you finally want.? ctrl+; will enter current date, ctrl+shift+; will enter current time.