automatic highlighting of row and column cell intersects

  • Thread starter Thread starter James
  • Start date Start date
J

James

I am trying to find out if it is possible to have Excel
automatically highlight(lightly shade) the row and column
of the active cell I am in. That is if I am in cell H13,
then the whole row of 13 is highlighted and the complete
column of H is highlighted . That way I can quickly see
all the information in row 13 quickly at a glance (i.e.
information in cell B13).

The highlighting would move accordingly to which ever
active cell I am in. So as I move down then the subsequent
row would highlight.
 
Back
Top