How to use Keyboard Shortcuts to Highlight Column/Row Containing Active Cell (Excel 2010/2007/2003)
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.