In my previous blog post, I gave you a handy shortcut in Excel. Ready for more? In my previous blog post, I gave you a handy shortcut in Excel. Ready for more?
Entering today’s date
You don’t always have a calendar available, and, because of our hectic lives, we may forget today’s date. To avoid wasting time, you can insert the current date in your specified Excel spreadsheet cell by using the following shortcut key: ‘CTRL +
Displaying the current time
Want to quickly enter the exact hour? You can do this almost instantly with this shortcut key: ‘CTRL + :’
You have compiled an Excel spreadsheet with a number of formulas, but, in the meantime, some of the data has been changed. No problem; after reopening that file, this will always be updated automatically. However, sometimes it needs to be done quicker, and you want to update it before closing your file. Do this with just 1 click of the ‘F9’ button.
Could your Excel knowledge do with a boost? Sign up for one of our Excel training programmes or contact us at firstname.lastname@example.org for a free quote tailored to your needs.