• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Row highlight

U

Ufoo

Member
Hi exce ninjas, is there a way of conditional formatting so that the whole row/column is highlighted when I click a cell? Just wondering. Thanks
 
The easiest way to do this in Excel is to press Shift+Space Bar. The entire row is highlighted, and the selected cell remains the same. If you want to move to another cell in the same row (without changing the highlight), you can use Tab to move to the right and Shift+Tab to move to the left.

If you want the row and column then you will need a small piece of VBA as @Khalid NGO has pointed out.
 
bobhc said:
The easiest way to do this in Excel is to press Shift+Space Bar. The entire row is highlighted, and the selected cell remains the same. If you want to move to another cell in the same row (without changing the highlight), you can use Tab to move to the right and Shift+Tab to move to the left.

If you want the row and column then you will need a small piece of VBA as @Khalid NGO has pointed out.
Click to expand...
Thanks
 
You must log in or register to reply here.
Back
Top