Rows and Columns View

[ZABU]

Currently in Excel 2000 when a cell is selected the Ros number and Column
letter are bolded to indicate location. Is there a way to have the entire
row and column shade to a light grey or other color to the point of
intersection?

ZABU

 

[David McRitchie]

Better than that assuming that you are not using colored borders
would be Chip Pearson's Row liner
http://www.cpearson.com/excel/topic.htm
http://www.cpearson.com/excel/RowLiner.htm
of course if you want the one closer to what you asked you could
use the old one and it would still work:
http://www.cpearson.com/excel/excelM.htm#HighlightActiveCell

 

[Kieran]

This has been solved by Chip Pearson.

Look at http://www.cpearson.com/excel/RowLiner.htm for the solution

 

[Wei-Dong Xu [MSFT]]

Hi ZABU,

Thank you for posting in MSDN managed newsgroup!

The suggestion from David and Kieran will help you a lot in this issue.

If you have any further questions, please feel free to let me know.

Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.