PC Review


Reply
Thread Tools Rate Thread

Deselect one of many non-adjacent rows selected

 
 
=?Utf-8?B?Tmljb2xsZSBLLg==?=
Guest
Posts: n/a
 
      11th Jan 2005
If you are going through a worksheet and selecting several rows to, for
example, delete them and you accidentally select a row you didn't mean to, is
there a way to deselect just that one row? I noticed that CTRL clicking on
the row again does not do the trick.

Thanks!!
 
Reply With Quote
 
 
 
 
Gord Dibben
Guest
Posts: n/a
 
      11th Jan 2005
Nicolle

Very annoying feature.

You can add a couple of Chip Pearson macros to your Personal.xls that will
allow the unchecking of a mistake.

Assign to a button or to the right-click menu. See this thread for the macros
and instructions for adding an item to the right-click menu.

http://snipurl.com/bxoj


Gord Dibben Excel MVP



On Tue, 11 Jan 2005 06:51:09 -0800, "Nicolle K."
<(E-Mail Removed)> wrote:

>If you are going through a worksheet and selecting several rows to, for
>example, delete them and you accidentally select a row you didn't mean to, is
>there a way to deselect just that one row? I noticed that CTRL clicking on
>the row again does not do the trick.
>
>Thanks!!


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add cells on two adjacent rows but non-adjacent columns Eve Microsoft Excel Worksheet Functions 14 20th Oct 2009 02:32 AM
Compare adjacent fields in adjacent rows Quimera Microsoft Excel New Users 6 30th May 2008 11:36 AM
how can I deselect one of the multiple selected rows? jopieb123 Microsoft Excel Misc 3 1st Dec 2005 03:50 PM
Re: Copying non-adjacent columns to adjacent rows (This time I have included the screen shots) BrianB Microsoft Excel Misc 0 13th Jan 2004 11:50 AM
Copying non-adjacent columns to adjacent rows Brian Smeenk Microsoft Excel Misc 2 10th Jan 2004 01:19 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:37 PM.