Quick Navigation in Excel (Control Key)

If you want to go to the last data in a row or column, simply use this combination:

Ctrl-Arrow key.

Example, if you are at the top of the column and you want to go to the last data of that column (before any break), then use the Ctrl-Arrow Down. If you were at the bottom, then use Ctrl-Arrow up.


Same rules for Ctrl-Left Arrow and Ctrl-Right Arrow.

Now it's quicker to navigate highly populated sheets!

Happy Computing!

Tweet