Is there a way to have Excel highlight the row and column in a "Cross-bar"
fashion, that is dependent on the current selected cell?

This would be very useful when one needs to read data in a few cells near a
selected cell barried in the middle of a dense dataset. Especially, when you
are taking your eyes on and off the screen and have to move the selected cell
at every step. For example, when I move the selection onto cell "G19", the
entire row 19 and column G would be highlighted such you get a big
highlighting cross "+" that extends to ±infinity in the respective row and
column of the selection, such that data a few cells above or below or a few
cell besides the selected cell position can easily be read.

Perhaps anyone has seen a utility or function that allows this? If anyone
has an idea how this could be implemented in VBA, let me know.

alain

Download Chip Pearson's free Rowliner Add-in.

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


Gord Dibben Excel MVP

On Mon, 28 Feb 2005 10:39:21 -0800, alainr
wrote:

Is there a way to have Excel highlight the row and column in a "Cross-bar"
fashion, that is dependent on the current selected cell?

This would be very useful when one needs to read data in a few cells near a
selected cell barried in the middle of a dense dataset. Especially, when you
are taking your eyes on and off the screen and have to move the selected cell
at every step. For example, when I move the selection onto cell "G19", the
entire row 19 and column G would be highlighted such you get a big
highlighting cross "+" that extends to ±infinity in the respective row and
column of the selection, such that data a few cells above or below or a few
cell besides the selected cell position can easily be read.

Perhaps anyone has seen a utility or function that allows this? If anyone
has an idea how this could be implemented in VBA, let me know.