Go to last line with data, Excel 2007

You can also try CTRL+Down Arrow key. This will take you to the last non-empty cell in the column. CTRL+Up arrow key will bring you back up to the top.