Is it possible to select an entire row by clicking one cell?

E

Excel_VBA

New Member
Joined
Dec 19, 2009
Messages
42
For example, I would like row 26 to be highlighed after selecting cell H26. Is there a way to do this w/o a macro?
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Sort by date Sort by votes
Click in the margin next to cell A26, that's about the easiest you can get.
 
Upvote 0
Well I'll be damned! All these years and I didn't know that feature was there. :eeek:

I stand corrected.
Thanks crusader!
 
Upvote 0
You must log in or register to reply here.

Similar threads

zookeepertx
  • Question Question
Find location of a string to use in a For Loop
Replies
3
Views
82
Joe4
Joe4
K
  • Question Question
Create new Workbook from exist
Replies
5
Views
146
KreshBell
K
E
  • Question Question
How to Highlight Each Column-Heading of the Active Row When The Corresponding Cells Contain 'X'
Replies
4
Views
119
Peter_SSs
Peter_SSs
I
  • Solved
Move selected row in table to row 3
Replies
2
Views
238
ipbr21054
I
N
  • Question Question
Formula Auditing Watch Window - Clear All then Paste Selected
Replies
0
Views
54
norts55
N

Forum statistics

Threads
1,224,509
Messages
6,179,192
Members
452,893
Latest member
denay

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top