show intersection of data
 

Is it possible to setup excel to show data intersection points.

For example if I select cell AB28 excel will highlight up to cell AB1 and
left to Cell A28. I know it highlights the row numbers and the column headers
but I would like it to highlighht the actual rows and columns to that point

Thanks

show intersection of data
 

I found this on Chip Pearson's site a while ago. If it doesn't solve your
problem directly, at least it may give you some ideas:

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

Eric


"Nigel" wrote:

Is it possible to setup excel to show data intersection points.

For example if I select cell AB28 excel will highlight up to cell AB1 and
left to Cell A28. I know it highlights the row numbers and the column headers
but I would like it to highlighht the actual rows and columns to that point

Thanks