In my work as an Excel Trainer, I do love to challenge the audience. And one of my favorite challenges to extend is the focus of this post. So fill all the cells in a range from A1 to A15000 with today’s date. I also like this challenge because if you do it correctly it takes you 5 seconds tops, but try it any other way and it’s a timeless hassle.
We will do this in three easy steps.
We simply write A1:A15000 into the Name Box and press Enter
After this step you can let go of the mouse! If you click now, the selection will be lost! Do not click!
Had to put that in red because this is where things usually go terribly wrong 🙂 .
This can be achieved in multiple ways, but whatever way you choose, do not click, just start typing. Here are two ways…
Still, do not click!
Press Ctrl + Enter and Voila
To quote a title of Jack Nicholson’s movie, this is almost As Good As It Gets. A real time saver!
Oh yeah, you can click now 🙂