Sometimes it is hard to see which cells are in the row/column of the selected cell in excel. Is there an option which would enable "crosshair", which would bold not only selected cells, but also cells in the same row/column as the selected one?

1 Answer

Include the following event macro in the worksheet code area:

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

Because it is worksheet code, it is very easy to install and automatic to use:

1. right-click the tab name near the bottom of the Excel window
2. select View Code - this brings up a VBE window
3. paste the stuff in and close the VBE window

If you have any concerns, first try it on a trial worksheet.

If you save the workbook, the macro will be saved with it. If you are using a version of Excel later then 2003, you must save the file as .xlsm rather than .xlsx

To remove the macro:

1. bring up the VBE windows as above
2. clear the code out
3. close the VBE window

To learn more about macros in general, see:

and

(v=office.14).aspx

To learn more about Event Macros (worksheet code), see:

Macros must be enabled for this to work!

3

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy