JCF

Not any native Excel setting. This would require event code in VBA.

Chip Pearson's ROWLINER add-in does what you want.

http://www.cpearson.com/excel/RowLiner.htm

Gord Dibben Excel MVP


On Tue, 11 Jan 2005 11:37:02 -0800, JCF wrote:

Is there a way to set up Excel to automatically hight light the whole column
and row when selecting a cell? For example I select cell C10, both the column
and the row will hight light automatically. It would look as if I clicked on
the column, held Crtl, and clicked on the row. This would be helpeful for
someone who is working in an extremely large workbook.