This tip is on how to select the Current Region using a keyboard shortcut:

CTRL + A

Suppose you have the following data:

Pressing CTRL + A will select a square around all the cells that are connected to the current cell.

If you are the left-most cell, press CTRL + A, then SHIFT + TAB, it will take you to the last cell.

Download sheet to practise how to Select Current Region in Excel

Video training on how to select the current region: