New Feature: Playlist Center! Pick a topic and let our playlists guide the way.

Start learning with our library of video tutorials taught by experts. Get started

Excel 2010 Power Shortcuts
Illustration by

Auto-Fill techniques for entering dates


From:

Excel 2010 Power Shortcuts

with Dennis Taylor

Video: Auto-Fill techniques for entering dates

Excel has a variety of methods for entering times quickly and easily, dates and times. Keep in mind also, a well known shortcut, anytime you have a month in an entry, if you would like to have the next month, next month, next month, etcetera, drag the fill handle from the lower right- hand corner either downward or rightward, as the case may be, to get the next month, next month, next month. Rarely but occasionally, you might drag upward or leftward to go in the reverse direction. If it's an abbreviation that works well too. Jul, typically you'd probably start with January. You got to be a three-letter abbreviation though.
Expand all | Collapse all
  1. 1m 37s
    1. Welcome
      1m 17s
    2. Using the exercise files
      20s
  2. 22m 45s
    1. Entering data or formulas in non-adjacent cells simultaneously
      2m 28s
    2. Converting formulas to values with a simple drag
      2m 34s
    3. Copying data or formulas down a column instantly
      2m 56s
    4. Adjusting all or selected column widths or row heights in a flash
      2m 21s
    5. Instantly displaying all worksheet formulas
      3m 16s
    6. Two quick shortcuts for creating charts
      1m 18s
    7. Print Preview
      1m 7s
    8. Instant date or time entry
      1m 16s
    9. Undo/Redo/Repeat
      3m 19s
    10. Zooming in and out quickly
      2m 10s
  3. 7m 37s
    1. Expanding and collapsing the Ribbon and Full Screen view
      1m 23s
    2. Keyboard command access
      2m 22s
    3. Quick Access toolbar display tips
      3m 52s
  4. 14m 30s
    1. Split screens and frozen titles in a flash
      5m 56s
    2. Repeating title creation and suppression
      6m 17s
    3. Customizing your display of Status Bar totals
      2m 17s
  5. 11m 31s
    1. Navigation shortcuts
      2m 30s
    2. Tips for navigating between workbooks
      3m 48s
    3. Navigating within worksheets
      5m 13s
  6. 11m 12s
    1. Selecting an entire row, column, or worksheet
      3m 20s
    2. Selecting noncontiguous ranges and visible cells only
      4m 39s
    3. Selecting the current region and moving around region corners
      3m 13s
  7. 22m 16s
    1. Accelerating data entry
      6m 27s
    2. Auto-Fill techniques for entering dates
      4m 59s
    3. Auto-Fill techniques for entering times
      2m 37s
    4. Custom lists for rapid entry
      5m 54s
    5. Cell editing tips
      2m 19s
  8. 12m 38s
    1. Copy/Move acceleration tips
      3m 27s
    2. Worksheet Copy/Move shortcuts
      2m 29s
    3. Dragging and inserting variations
      3m 47s
    4. Instantly displaying Paste Special options
      2m 55s
  9. 29m 31s
    1. Rapid formula creation
      3m 48s
    2. Selecting all cells that depend on the active cell
      5m 24s
    3. Selecting all cells that can affect the active cell
      2m 38s
    4. AutoSum shortcuts
      2m 57s
    5. Rounding shortcuts
      5m 14s
    6. Generating random numbers
      3m 16s
    7. Counting unique entries
      3m 11s
    8. Performing calculations without formulas
      3m 3s
  10. 17m 4s
    1. Controlling rows and columns
      5m 50s
    2. Realigning imported text
      2m 27s
    3. Handling blank cells
      4m 20s
    4. Collapsing and expanding detail
      4m 27s
  11. 28m 8s
    1. Formatting numbers
      6m 49s
    2. Aligning data
      3m 49s
    3. Adding background color for readability
      3m 43s
    4. Formatting data conditionally
      1m 54s
    5. Creating custom formats
      6m 23s
    6. Formatting periods over 24 hours
      3m 2s
    7. Applying strikethroughs and borders
      2m 28s
  12. 25m 46s
    1. Sorting shortcuts
      2m 40s
    2. Cleaning up spaces
      4m 47s
    3. Identifying duplicates
      6m 10s
    4. Splitting columns
      3m 57s
    5. Ensuring unique entries
      2m 46s
    6. Forcing dates to be weekdays only
      3m 56s
    7. Displaying unique items from large lists
      1m 30s
  13. 18m 38s
    1. Placing and adjusting charts
      2m 37s
    2. Creating chart titles from cell content
      2m 22s
    3. Creating and manipulating shapes
      5m 31s
    4. Linking and unlinking pictures
      8m 8s
  14. 9s
    1. Goodbye
      9s

Watch this entire course now—plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
please wait ...
Excel 2010 Power Shortcuts
3h 43m Intermediate Aug 12, 2010

Viewers: in countries Watching now:

In Excel 2010 Power Shortcuts, Excel expert Dennis Taylor shares tips and shortcuts to vastly increase efficiency and get the full power out of Excel 2010. There are tips for working with the Ribbon and Quick Access toolbar, navigating workbooks and selecting cells, rapid data entry and editing, working with formulas, formatting data, working with charts, sorting data, and much more. Exercise files accompany the course.

Topics include:
  • Creating charts with keyboard shortcuts
  • Converting formulas to values by dragging
  • Repeating Undo and Redo actions
  • Displaying formulas instantly
  • Navigating quickly through worksheets and across workbooks
  • Formatting numeric, and date/time data in a flash with keystroke shortcuts
  • Inserting dates or times instantly
  • Grouping rows or columns to create collapsible regions
  • Building data-entry shortcuts with Auto-fill
  • Displaying unique items from large lists
Subjects:
Business Productivity
Software:
Excel
Author:
Dennis Taylor

Auto-Fill techniques for entering dates

Excel has a variety of methods for entering times quickly and easily, dates and times. Keep in mind also, a well known shortcut, anytime you have a month in an entry, if you would like to have the next month, next month, next month, etcetera, drag the fill handle from the lower right- hand corner either downward or rightward, as the case may be, to get the next month, next month, next month. Rarely but occasionally, you might drag upward or leftward to go in the reverse direction. If it's an abbreviation that works well too. Jul, typically you'd probably start with January. You got to be a three-letter abbreviation though.

And of course, if you drag it farther than the end of the year, simply wraps around, works the same way with days or the week. Three letter abbreviations or full spellings. If you use all uppercase, you will get all upper case and so on. Pretty predictable and generally, this is down a column although it can certainly be a crossover as well. Those are all built-in, easy to get to. Now with date entries, sometimes you need to put in the current date. There are two ways to do this. One of the top ten shortcuts was Ctrl+ Semicolon. Just simply put in the current date. This is the date of the recording, do that at anytime, but sometimes you want to put in the date in such a way that it will always adjust and change. In other words we want this to be current, as of now, but if we open this file at a later time after we saved it, we want it to be accurate.

The function =today, and you need only type it with the left parenthesis press Enter, you will have the entry, puts in today's date. But it is different than having typed it or using the keystroke shortcut, because this will adjust over time and every time you will open this file, even if you don't change it, it changes and when you close the file, you get a prompt for saving even if you have made no other changes. That's always up-to-date, and it can be used in creative ways with other formulas too. For example, to calculate anniversary dates and birthdates.

Simply use the today function compared with another date. So it's a great feature for putting in dates. Sometimes you want to put in a date series. Now for example, we start with May 6, 5/6/11. If you drag from the corner, you will automatically get next day, next day, next day. If you want to get the same day repeated, and it might be just once or twice, hold down the Ctrl key as you drag. Be sure to let go with the mouse first. Now maybe we do want to change this whatever, but whenever you are dragging a date, if you hold down the Ctrl key it does not change.

If you don't hold down Ctrl, it simply gives you the next day, next day, and next day, and you can create a date series pretty efficiently too. I am not sure what day of the week this is, but if I want a seven day interval here, I might type in the 13th right here and then with both of these highlighted, because that interval was 7. If we drag from the corner, we are going to get every 7 days. So that's a series of Mondays or Fridays or whatever day of the week it happens to be. And of course, the interval might be five days. It might be 10 days. So when you put in two entries and then drag from the corner, you will get that number repeated.

And a reminder of the date system works until the year 10,000. So we are all pretty safe there. It goes all the way back to 1900. Now you can also create series in a different way, in a way that's perhaps unexpected. Suppose you do a mid-month report, down to 15th, and let's say you might start your list here beginning in January. You don't have to, but imagine maybe we did not have any data here. So we would like a month report. Maybe the heading will say mid-month report. Here is the date for January. We would have our data here perhaps, but I am about to drag with the right mouse button, pulling down the right mouse button dragging this as far as I think I need it, letting go, and there is the menu that always comes with the right mouse button, and we want to fill this with months, here we go, every month as far as we might drag this.

If the starting date here happens to be the last day of a month, for example January 31st, if we drag similarly here and fill months, we'll get the last day of every month. Same thing would have happened if we had started with April 30th or if we'd started with February 28th and sure enough, if we have dragged this far enough, we would get, and I didn't quite drag it far enough, but we will get as you will see here by filling months, February 29th, which is a leap year in 2012. So that works nicely and beautifully as well.

Last of all in this series, the one that I hear a lot about. People need this. I want a list here of our working days where you tabulate hours worked on project for example. So I am not sure what day of the week this is, but if we were to drag the fill handle with the right mouse button, we also have an option called Fill Weekdays, and you will notice gaps in here for example. That looks like it is a Monday, Tuesday, Wednesday, Thursday, Friday, no Saturday, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday and so on. Again, these are achieved by dragging with the right mouse button.

You can also create a yearly series here too. You probably saw that in the options,. drag this as far as you want, Fill Years, The same day every year. So, quite a few options with the right mouse button, and we saw some other techniques here too for quickly creating date series.

Find answers to the most frequently asked questions about Excel 2010 Power Shortcuts.


Expand all | Collapse all
please wait ...
Q: Where can I learn more about Excel formulas?
A: Discover more on this topic by visiting Excel formulas on lynda.com.
 
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.
Upgrade now


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

join now Upgrade now

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Excel 2010 Power Shortcuts.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Notes cannot be added for locked videos.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.