automatic highlighting of row and column cell intersects

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Highlighting row of active cell question 4
Highlighting Entire Row without the Mouse 11
How do I get row and column of active cell to highlight? 2
Having an entire row highlighted as I move from cell to cell 8
Remoew row highlighting when workbook is closed 5
Conditional Formatting of Entire Row when the Active Cell is in ro 11
Auto highlight active row and column 2
Highlighting Active working area 3

Top