Highlite row and colum cursor is in

B

Bentley26

Is there a way for excel to highlite the entire row and colum that the cursor
is in? I know that for example when my cursor is in box T 12 (coulm T and
Row 12) that the T is highlited and the 12 is higlited, but sometimes it is
still hard to see across the entire row. I was wondering if there is a way
excel can highlite the entire row and colum so that i can see easily what is
in the row and colum?
 
G

Gary''s Student

Put the following macro in Worksheet code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlNone
Target.EntireRow.Interior.ColorIndex = 6
Target.EntireColumn.Interior.ColorIndex = 6
End Sub
 
B

Bentley26

Thanks for the add in. It is a cool tool, however it does not allow the undu
button to work. unfortunaly i need the undue button to work so this doesnt
seem to be an option for me. but thank you anyway.
 
G

Gord Dibben

Right-click on the sheet tab and "View Code"

Copy/paste to that sheet module.

NOTE: this code will wipe out any background colors you may have currently in
use.

Will also make the UNDO stack unavailable.


Gord
 

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

MS Word normal.dot cannot be fixed 'text box' appears each time 4
Highlite from A2 to Last Fred then to Column G 6
How to highlite the row and colum of the active cell? 2
How to modify and updte specific styles for specific paragraphs across the document 0
Cursor, row, colum, beam 3
How can I highlite an entire row using conditional formatting? 4
HOW DO I GET THE CURSOR TO SHOW UP 1
VBA macro delete row - Help needed 7

Top