If you have a worksheet that contains a lot of data and you are not sure where your selection is in the worksheet, you can use a keyboard shortcut to highlight the row or column containing the selected cell.  This will work the same in Excel 2010, Excel 2007 and Excel 2003.