• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 234
  • Last Modified:

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?
0
BigWill5112
Asked:
BigWill5112
  • 4
  • 3
  • 2
  • +2
1 Solution
 
Paul JacksonCommented:
Hod down CTRL and click the row you want to deselect
0
 
Neal58Commented:
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
0
 
Kyle AbrahamsSenior .Net DeveloperCommented:
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Paul JacksonCommented:
hmm seems I was wrong
0
 
sysreq2000Commented:
Hold control and click on the row number in the left margin.
0
 
Paul JacksonCommented:
@sysreq2000 we've already established that doesn't work
0
 
Neal58Commented:
@ 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
0
 
BigWill5112Author Commented:
I thought was this would be easy.
0
 
Neal58Commented:
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!
0
 
Paul JacksonCommented:
Yes sorry must be faulty memory your best bet is some vba as linked in ged325's comment.
0
 
sysreq2000Commented:
Ha! lol OK that's it I'm going for coffee.  8-)
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now