From the course: Excel 2016: Tips and Tricks

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Enter dates and date series efficiently

Enter dates and date series efficiently

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

Enter dates and date series efficiently

“

- [Voiceover] Any time you're entering data that's related to dates, there's lots of shortcuts to be considered. We see Jan over in Cell A2, the abbreviation for January. If I point to the fill handle in the lower right-hand corner and click and drag downward, the popup tip to the right suggests what I'm about to see. I'm about to drag this down to December. i might drag it a bit too far and it simply starts wrapping around again. You can start with any month you want. If you drag downward or rightward you'll get an extension based on that starting point. I've chosen Oct here in cell A11. Click and drag rightward. There we are. If you drag upward, here's Jan, goes backward in time. If you drag leftward, it goes backward in time. If you use abbreviations, they must be three letters, as we see here. If you start with four letters, maybe Sept, it's not uncommon to see that by the way, but if you use this as a starting point it simply repeats the entry. So it must be three letters if…

Contents