Change cursor into big big cross to work better reading data in rows

[Lince099]

Hi,

I'd like to be able to change my cursor into a big cross that takes all the screen, so that when I'm on excel it's easier to see the data at the same row at the far end of the screen.

I don't mind if this change affects only excel or all the computer.

Has anyone ever done this or knows how to do it?

Ismael

 

[Trevor G]

I don't believe that can be done through the windows system. You could look to highlight the row once you click a cell.

Code needs to be added behind the worksheet. Right mouse button on the sheet name and select View Code, change the first drop down on the left at the top of the screen and select Worksheet, then paste in this code and return to the sheet. Click a cell and see if that helps.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
Application.ScreenUpdating = False
' Clear the colour
Cells.Interior.ColorIndex = 0
With Target
' Highlight the entire row and add colour
.EntireRow.Interior.ColorIndex = 8 'Find a number that might help
'.EntireColumn.Interior.ColorIndex = 8 'Find a number that might help
End With
Application.ScreenUpdating = True
End Sub

 

[My Aswer Is This]

Try this:
This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

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

 

[Lince099]

Try this:
This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

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

Thank My answer is this. I appreciate it.

It works, but when I save the excel file after having worked with it, the red filling will stay, wont it? Is there a way to get rid of it before saving the file, other than deleting the code from the workbook and manually taking off the red filling?

 

[Lince099]

I don't believe that can be done through the windows system. You could look to highlight the row once you click a cell.

Code needs to be added behind the worksheet. Right mouse button on the sheet name and select View Code, change the first drop down on the left at the top of the screen and select Worksheet, then paste in this code and return to the sheet. Click a cell and see if that helps.

Thank you Trevor. Do you know if there is any way not to ovewrite the other formatting on the page or to keep the original formatting on after finishing working on the workbook?

Thanks for your help!

 

[My Aswer Is This]

I know of no way to set all the cell's interior color back to the original color.

Thank My answer is this. I appreciate it.

It works, but when I save the excel file after having worked with it, the red filling will stay, wont it? Is there a way to get rid of it before saving the file, other than deleting the code from the workbook and manually taking off the red filling?