Excel should allow you to click and hold on a cell that is referenced (click
and hold within the cell that is active) that would create a highlight (in
gray for instance) up to the column letter and left to the row number, to
allow easy visual sighting of the current row and column position.

I will be happy to provide an print-screen attachement to illustrate this if
interested. Thanks for your consideration.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

Hi ih1234,

Perhaps you could use something like this:
http://www.mrexcel.com/hof001.php

Cheers


"ih1234" wrote in message
...
Excel should allow you to click and hold on a cell that is referenced
(click
and hold within the cell that is active) that would create a highlight (in
gray for instance) up to the column letter and left to the row number, to
allow easy visual sighting of the current row and column position.

I will be happy to provide an print-screen attachement to illustrate this
if
interested. Thanks for your consideration.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...et.f unctions

Hi,
I realise you are making a suggestion to MS, but in the mean time, try
the below as a workaround...
Unless of course you already have a macro - as is suggested by the fact
that you could provide a screen dump showing this?

John McGimpsey provides a good macro on the below page (includes a link
to an addin of Chip Pearson's, also below). I think this is better than
the macro in Macropod's link as it allows for the old formatting to be
renewed once the active cell has moved.

http://www.mcgimpsey.com/excel/highl...iteRetainColor
http://www.cpearson.com/excel/RowLiner.htm

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=533782