We help IT Professionals succeed at work.

Not an easier quesion to answer

BigWill5112
BigWill5112 asked
on
If I have contiguous rows selected in Excel...lets say 1-4.  Is there a way I deselect one row?
Comment
Watch Question

Paul JacksonSoftware Engineer
CERTIFIED EXPERT
Top Expert 2011

Commented:
Hod down CTRL and click the row you want to deselect

Commented:
I think deselcting using ctrl will only deselect the first cell.

the easier thing to do would be to hold control and select the ones you do want
Senior .Net Developer
CERTIFIED EXPERT
Commented:
Paul JacksonSoftware Engineer
CERTIFIED EXPERT
Top Expert 2011

Commented:
hmm seems I was wrong
Hold control and click on the row number in the left margin.
Paul JacksonSoftware Engineer
CERTIFIED EXPERT
Top Expert 2011

Commented:
@sysreq2000 we've already established that doesn't work

Commented:
@ jacko - I can only test this in 2010, but holding control just allows you to select a cell in the selection without losing the rest of the selection

Author

Commented:
I thought was this would be easy.

Commented:
in ged325's comment he gives a link which has some VB script which should work. haven't tested it though . .!

such simple things can be very complicated!
Paul JacksonSoftware Engineer
CERTIFIED EXPERT
Top Expert 2011

Commented:
Yes sorry must be faulty memory your best bet is some vba as linked in ged325's comment.
Ha! lol OK that's it I'm going for coffee.  8-)

Explore More ContentExplore courses, solutions, and other research materials related to this topic.