Preventing The TODAY( ) Function From Changing
This is going to be a brief post, but I came across this today and wanted to share it with everyone. I was over perusing around on the MrExcel forums and someone was asking how to insert today's date without using the TODAY( ) function. The user did not want to use the TODAY( ) function because he wanted to prevent the date from changing when his files were opened up in the future.
Well I thought to myself, "Why don't you just manually type in the date?" However, Aladin Akyurek (MrExcel MVP) answered back with a hotkey solution that I was unaware of. Aladin recommended using the shortcut key Ctrl + Semi-colon to insert the current date into the target cell.
So I curiously opened up a new workbook, selected cell A1, keyed in the shortcut, and sure enough today's date popped right in! Amazing! I have a ton of files that require me to hardcode the current date, so I will definitely be using this shortcut on a regular basis. Another benefit to using this key combination is that it prevents the user from keying in the wrong date. Which I'm sure can cause major spreadsheet problems from time to time!
Is this news to anyone else? Let's try to discover some more! Leave a comment below if you've come across any interesting or useful keyboard shortcuts! I look forward to reading your responses.