BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Some tasks in Excel always seem to take longer than they should - if only you knew a bunch of quick shortcuts to speed up the simple things. Read on to see how much time you could save!
- Excel Quick Tip #1 - Copying a Formula
- Excel Quick Tip #2 - Putting Dollar Signs in a Formula
- Excel Quick Tip #3 - Adding Totals to Columns
- Excel Quick Tip #4 - Selecting a Table
- Excel Quick Tip #5 - Sorting a List
- Excel Quick Tip #6 - Creating Range Names
- Excel Quick Tip #7 - Creating a Chart
- Excel Quick Tip #8 - Copying a Worksheet
- Excel Quick Tip #9 - Entering Today's Date (this blog)
- Excel Quick Tip #10 - Copying Days and Months
Posted by Andrew Gould on 02 December 2011
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Excel Quick Tip #9 - Entering Today's Date
The most common date entered into Excel is today's date. Luckily there's a keyboard shortcut for doing this.
- Select the cell you want the date to appear in.

An important expenses claim being entered today.
- Press CTRL + ;.

A quick and simple way to avoid having to type the same date again and again.
You can also press CTRL + SHIFT + ; to enter the current time.
You can see this technique in action in this short video.
- Excel Quick Tip #1 - Copying a Formula
- Excel Quick Tip #2 - Putting Dollar Signs in a Formula
- Excel Quick Tip #3 - Adding Totals to Columns
- Excel Quick Tip #4 - Selecting a Table
- Excel Quick Tip #5 - Sorting a List
- Excel Quick Tip #6 - Creating Range Names
- Excel Quick Tip #7 - Creating a Chart
- Excel Quick Tip #8 - Copying a Worksheet
- Excel Quick Tip #9 - Entering Today's Date (this blog)
- Excel Quick Tip #10 - Copying Days and Months