Select Entire Row as Default

[burniksapwet]

Noob question guys. Is there a way to change the select cell default to select the entire row and make it default to do that? Would like to see the row I am currently working on which is why I am asking. I use CAD a lot and it has a crosshair that you can extend to both end so you can see which line you're in. I was hoping there is a similar feature in excel that can do this. Thank you in advance guys.

 

[dreid1011]

You could do this very easily with some VBA, but it would have to be added to any sheet you wanted it to work on. However, by selecting the entire row in this manner, you would not be able to edit any cells.

There is a conditional formatting method you could use to highlight the row instead. This way you can still manipulate individual cells.

 

[DanteAmor]

Use conditional formatting.
Create a new rule.

On the Home tab, in the Styles group, click Conditional formatting > New Rule… In the New Formatting Rule window, select Use a formula to determine which cells to format. Enter the formula in the corresponding box.

Excel Formula:
=OR(ROW()=CELL("ROW"),COLUMN()=CELL("COL"))

Click the Format… button to choose your custom format.

Put the following code in the events of your sheet.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  Application.ScreenUpdating = True
End Sub

SHEET EVENT
Right click the tab of the sheet you want this to work, select view code and paste the code into the window that opens up.

Regards
Dante Amor

 

[duggie33]

You could try something like what is demonstrated in the following link...

Highlight Active Row and Column in Excel (Easy Steps)

Sometimes you may have the need to highlight the active row and column in a data set. Learn how to do this easily in Excel.

trumpexcel.com

Doug

 

[duggie33]

Yep, same as what they said, I didn't see the replies before posting...

Doug