In my work as a Trainer and also as a Data Scientist (I love that term), Shortcuts in Excel are a vital part of doing things efficiently. This shortcut helps you when you select data. Let’s assume this is our data.

A bunch of dates from A1 to Z12000. Working with this amount of data, one frequently has a need to select the data or just one column of data. And when you do that either by Ctrl+A or by Ctrl+Shift+Down Arrrow, what you get is not all that satisfying.

You select the first cell

Press Ctrl+A (or Ctrl + Shift + Down Arrow for a column of data) and feel enthusiastic since everything is selected at once, but what you get is

1. The active Cell is still A1
2. Excel has moved the focus down to Z12000 (or A12000 if you selected the column)
3. And the only way to get back up is by the vertical Scroll Bar

But there is another way in Excel to get to the Active Cell and that is Ctrl + Backspace.

Here’s what you get.

It always gets you back to the Active cell. I still get chills J. Before this I was used to pressing Enter and then Shift+Enter to get back to that Cell. I believe this is what is or should be called eternal happiness in Excel.