asked on
Not an easier quesion to answer
If I have contiguous rows selected in Excel...lets say 1-4. Is there a way I deselect one row?
Microsoft Excel
Last Comment
sysreq2000
Hod down CTRL and click the row you want to deselect
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
the easier thing to do would be to hold control and select the ones you do want
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
hmm seems I was wrong
Hold control and click on the row number in the left margin.
@sysreq2000 we've already established that doesn't work
@ 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
ASKER
I thought was this would be easy.
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!
such simple things can be very complicated!
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-)