Excel Tip: Fast navigation

When you press Ctrl and any arrow key (north, east, south, or west), you jump to the last populated cell in that direction. Think of using the Ctrl-arrow key shortcut as an alternative to pressing Page Down to find the bottom row of a data set or pressing Tab to find the last column. Bonus tip: Hold down the Shift key while you press any Ctrl-arrow key shortcut to select all the cells between where you are and where you jump with the Ctrl key.