WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business Wise Owl Training
30 years in business
See 479 reviews for our classroom and online training
This page has 0 threads   |  Add post
Five star reviews Outstanding course feedback
Average score 9.41/10, based on our 1,878 latest reviews
If you found this blog useful and you’d like to say thanks you can click here to make a contribution. Thanks for looking at our blogs!

BLOGS BY TOPIC▼

BLOGS BY AUTHOR▼

BLOGS BY YEAR▼

10 Excel Quick Tips
Part nine of a ten-part series of blogs

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!

  1. Excel Quick Tip #1 - Copying a Formula
  2. Excel Quick Tip #2 - Putting Dollar Signs in a Formula
  3. Excel Quick Tip #3 - Adding Totals to Columns
  4. Excel Quick Tip #4 - Selecting a Table
  5. Excel Quick Tip #5 - Sorting a List
  6. Excel Quick Tip #6 - Creating Range Names
  7. Excel Quick Tip #7 - Creating a Chart
  8. Excel Quick Tip #8 - Copying a Worksheet
  9. Excel Quick Tip #9 - Entering Today's Date (this blog)
  10. 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.

  1. Select the cell you want the date to appear in.
Selecting a cell

An important expenses claim being entered today.

  1. Press CTRL + ;.
Today entered

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.

  1. Excel Quick Tip #1 - Copying a Formula
  2. Excel Quick Tip #2 - Putting Dollar Signs in a Formula
  3. Excel Quick Tip #3 - Adding Totals to Columns
  4. Excel Quick Tip #4 - Selecting a Table
  5. Excel Quick Tip #5 - Sorting a List
  6. Excel Quick Tip #6 - Creating Range Names
  7. Excel Quick Tip #7 - Creating a Chart
  8. Excel Quick Tip #8 - Copying a Worksheet
  9. Excel Quick Tip #9 - Entering Today's Date (this blog)
  10. Excel Quick Tip #10 - Copying Days and Months
This blog has 0 threads Add post