Today I learned an Excel trick that really amazed me! I’ve been teaching Excel for a long time and never knew you could double click on the edge of a selected cell to navigate in 4 directions. If you double click on the bottom edge of cell it will navigate to the bottom row. If you double click on the top part of the selected cell, it will navigate to its header. Left and right clicking take you to the sides, horizontally.
Hold down the shift key while you double click and it will make a selection of all the cells starting from the start to end of the range.