Deselect (Unselect) Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have used Excel for a very long time and was used to the way cell selection
was managed. For example, If I used CTRL to select 5 different cells and
then wanted to deselect one of them, I could just reclick it while holing
CTRL. However, now in Excel 2007 if I select a cell by mistake and want to
deselect it rather than restart my whole selection process, I cannot. Can
someone please tell me how to deselect a cell if it is selected. If this is
an impossible task then I, for one, am speachless.

Mike
 
Not too sure what you are talking about. To the best of my knowledge you
never could un-select a cell by re-clicking it...
 
I don't remember this ever being possible in Excel. What version were you
using before 2007? Here's a quote that can be found in both Excel 2003 and
2007 Help Files, relating to selecting non-adjacent cells:

"[Note] You cannot cancel the selection of a cell or range of cells in a
nonadjacent selection without canceling the entire selection."

HTH,
Elkar
 
I have always used 2000 until I upgraded to 2007. Why can I not deselect
non-adjacent cells? Was it to difficult for the fellows at Microsoft to
program or was it not a popular function?
 
I agree, that would be a handy feature. Not sure why it was removed.

If you're not aware of it, you can hit SHIFT-F8 to toggle "Add to Selection"
on/off. This allows you to select multiple cells without holding down any
keys. That doesn't solve the problem, but could help to avoid accidentally
clicking on a wrong cell and having to start over.

HTH,
Elkar

gtabmx said:
I have always used 2000 until I upgraded to 2007. Why can I not deselect
non-adjacent cells? Was it to difficult for the fellows at Microsoft to
program or was it not a popular function?

Elkar said:
I don't remember this ever being possible in Excel. What version were you
using before 2007? Here's a quote that can be found in both Excel 2003 and
2007 Help Files, relating to selecting non-adjacent cells:

"[Note] You cannot cancel the selection of a cell or range of cells in a
nonadjacent selection without canceling the entire selection."

HTH,
Elkar
 
I know of no version of Excel that allows you to de-select a cell by re-clicking
in the manner you describe.

Once selected with CTRL + Click, the cells are selected.

Chip Pearson has code to allow de-selecting cells or ranges.

Sub UnSelectActiveCell()
Dim Rng As Range
Dim FullRange As Range
'Chip Pearson
If Selection.Cells.Count > 1 Then
For Each Rng In Selection.Cells
If Rng.Address <> ActiveCell.Address Then
If FullRange Is Nothing Then
Set FullRange = Rng
Else
Set FullRange = Application.Union(FullRange, Rng)
End If
End If
Next Rng

If FullRange.Cells.Count > 0 Then
FullRange.Select
End If
End If

End Sub


Sub UnSelectActiveArea()
'Chip Pearson
Dim Rng As Range
Dim FullRange As Range
Dim Ndx As Integer
If Selection.Areas.Count > 1 Then
For Each Rng In Selection.Areas
If Application.Intersect(ActiveCell, Rng) Is Nothing Then
If FullRange Is Nothing Then
Set FullRange = Rng
Else
Set FullRange = Application.Union(FullRange, Rng)
End If
End If
Next Rng
FullRange.Select
End If

End Sub


Gord Dibben MS Excel MVP
 
I use 2000 and I have never been able to do that, although many
is the time that I have wished I could.

Reclicking on a cell just changes it to be the active cell. It turns
to white but is still part of the selection set.

Regards
Martin


gtabmx said:
I have always used 2000 until I upgraded to 2007. Why can I not deselect
non-adjacent cells? Was it to difficult for the fellows at Microsoft to
program or was it not a popular function?

Elkar said:
I don't remember this ever being possible in Excel. What version were
you
using before 2007? Here's a quote that can be found in both Excel 2003
and
2007 Help Files, relating to selecting non-adjacent cells:

"[Note] You cannot cancel the selection of a cell or range of cells in a
nonadjacent selection without canceling the entire selection."

HTH,
Elkar
 
It was not removed, since it was never part of Excel.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


Elkar said:
I agree, that would be a handy feature. Not sure why it was removed.

If you're not aware of it, you can hit SHIFT-F8 to toggle "Add to
Selection"
on/off. This allows you to select multiple cells without holding down any
keys. That doesn't solve the problem, but could help to avoid
accidentally
clicking on a wrong cell and having to start over.

HTH,
Elkar

gtabmx said:
I have always used 2000 until I upgraded to 2007. Why can I not deselect
non-adjacent cells? Was it to difficult for the fellows at Microsoft to
program or was it not a popular function?

Elkar said:
I don't remember this ever being possible in Excel. What version were
you
using before 2007? Here's a quote that can be found in both Excel 2003
and
2007 Help Files, relating to selecting non-adjacent cells:

"[Note] You cannot cancel the selection of a cell or range of cells in
a
nonadjacent selection without canceling the entire selection."

HTH,
Elkar
 
Like some of folks here, I could have sworn that I used to be able to select
and de-select in some earlier version of XL ... that is until just this
morning.

I was working in Windows explorer, *AND * THERE* is where it can be done! !
!

Just got those 2 mixed up in my memory.<bg>
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
I know of no version of Excel that allows you to de-select a cell by
re-clicking
in the manner you describe.

Once selected with CTRL + Click, the cells are selected.

Chip Pearson has code to allow de-selecting cells or ranges.

Sub UnSelectActiveCell()
Dim Rng As Range
Dim FullRange As Range
'Chip Pearson
If Selection.Cells.Count > 1 Then
For Each Rng In Selection.Cells
If Rng.Address <> ActiveCell.Address Then
If FullRange Is Nothing Then
Set FullRange = Rng
Else
Set FullRange = Application.Union(FullRange, Rng)
End If
End If
Next Rng

If FullRange.Cells.Count > 0 Then
FullRange.Select
End If
End If

End Sub


Sub UnSelectActiveArea()
'Chip Pearson
Dim Rng As Range
Dim FullRange As Range
Dim Ndx As Integer
If Selection.Areas.Count > 1 Then
For Each Rng In Selection.Areas
If Application.Intersect(ActiveCell, Rng) Is Nothing Then
If FullRange Is Nothing Then
Set FullRange = Rng
Else
Set FullRange = Application.Union(FullRange, Rng)
End If
End If
Next Rng
FullRange.Select
End If

End Sub


Gord Dibben MS Excel MVP
 
Maybe this will make sense in some way as our mind can play tricks on us:
After making the selection holding down control, if you click on one of the
cells that was already selected, that cell turns white again ( not light up
or not blue...) and make us think that was de-selected but it's not. However
this feature should be consider for later excel versions (2010?), I'm sure
we'll use it very often.
 
I don't know what everyone else is talking about, but you could DEFINITELY deselect cells within a selected entire row/column before in 2003 by holding down CTRL and clicking the cell. I just converted over to 2007 and noticed this is no longer an option. WTF Microsoft! Why would you take this lovely function away! Mike, or anyone else, have you found out how to do this yet???
 
I don't believe that any version of Excel, 2007, 2003 or anything
else, ever allowed you to unselect a cell, removing it from the
current selection. Holding down the CTRL key changes which cell within
the selected cells is the Active Cell, but it does not and never did
allow you to remove the cell from the Selection. I have code on my
web site at http://www.cpearson.com/excel/unselect.aspx that allows
you to unselect the active cell or the active area, removing it from
the current Selection.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
By the way, when you make multiple selection while holding ctrl on Word 2007 you can of course unselect by re-clicking...

So keep your lousy explication (like "I think you may be confusing the behavior in Windows Explorer with Excel") for yourself, thank you.



Bob I wrote:

I think you may be confusing the behavior in Windows Explorer with Excel.
17-Nov-08

I think you may be confusing the behavior in Windows Explorer with Excel

Ashley wrote:

Previous Posts In This Thread:

Deselect (Unselect) Cells
I have used Excel for a very long time and was used to the way cell selection
was managed. For example, If I used CTRL to select 5 different cells and
then wanted to deselect one of them, I could just reclick it while holing
CTRL. However, now in Excel 2007 if I select a cell by mistake and want to
deselect it rather than restart my whole selection process, I cannot. Can
someone please tell me how to deselect a cell if it is selected. If this is
an impossible task then I, for one, am speachless

Mike

Not too sure what you are talking about.
Not too sure what you are talking about. To the best of my knowledge yo
never could un-select a cell by re-clicking it..
-
HTH..

Jim Thomlinso

:

I don't remember this ever being possible in Excel.
I don't remember this ever being possible in Excel. What version were you
using before 2007? Here's a quote that can be found in both Excel 2003 and
2007 Help Files, relating to selecting non-adjacent cells:

"[Note] You cannot cancel the selection of a cell or range of cells in a
nonadjacent selection without canceling the entire selection.

HTH
Elka

:

I have always used 2000 until I upgraded to 2007.
I have always used 2000 until I upgraded to 2007. Why can I not deselect
non-adjacent cells? Was it to difficult for the fellows at Microsoft to
program or was it not a popular function

:

I agree, that would be a handy feature. Not sure why it was removed.
I agree, that would be a handy feature. Not sure why it was removed

If you're not aware of it, you can hit SHIFT-F8 to toggle "Add to Selection"
on/off. This allows you to select multiple cells without holding down any
keys. That doesn't solve the problem, but could help to avoid accidentally
clicking on a wrong cell and having to start over

HTH
Elka

:

I know of no version of Excel that allows you to de-select a cell by
I know of no version of Excel that allows you to de-select a cell by re-clickin
in the manner you describe

Once selected with CTRL + Click, the cells are selected

Chip Pearson has code to allow de-selecting cells or ranges

Sub UnSelectActiveCell(
Dim Rng As Rang
Dim FullRange As Rang
'Chip Pearso
If Selection.Cells.Count > 1 The
For Each Rng In Selection.Cell
If Rng.Address <> ActiveCell.Address The
If FullRange Is Nothing The
Set FullRange = Rn
Els
Set FullRange = Application.Union(FullRange, Rng
End I
End I
Next Rn

If FullRange.Cells.Count > 0 The
FullRange.Selec
End I
End I

End Su

Sub UnSelectActiveArea(
'Chip Pearso
Dim Rng As Rang
Dim FullRange As Rang
Dim Ndx As Intege
If Selection.Areas.Count > 1 The
For Each Rng In Selection.Area
If Application.Intersect(ActiveCell, Rng) Is Nothing The
If FullRange Is Nothing The
Set FullRange = Rn
Els
Set FullRange = Application.Union(FullRange, Rng
End I
End I
Next Rn
FullRange.Selec
End I

End Su

Gord Dibben MS Excel MV

I use 2000 and I have never been able to do that, although manyis the time
I use 2000 and I have never been able to do that, although many
is the time that I have wished I could.

Reclicking on a cell just changes it to be the active cell. It turns
to white but is still part of the selection set.

Regards
Martin



It was not removed, since it was never part of Excel.
It was not removed, since it was never part of Excel.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

Like some of folks here, I could have sworn that I used to be able to select
Like some of folks here, I could have sworn that I used to be able to select
and de-select in some earlier version of XL ... that is until just this
morning.

I was working in Windows explorer, *AND * THERE* is where it can be done! !
!

Just got those 2 mixed up in my memory.<bg>
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
I know of no version of Excel that allows you to de-select a cell by
re-clicking
in the manner you describe.

Once selected with CTRL + Click, the cells are selected.

Chip Pearson has code to allow de-selecting cells or ranges.

Sub UnSelectActiveCell()
Dim Rng As Range
Dim FullRange As Range
'Chip Pearson
If Selection.Cells.Count > 1 Then
For Each Rng In Selection.Cells
If Rng.Address <> ActiveCell.Address Then
If FullRange Is Nothing Then
Set FullRange = Rng
Else
Set FullRange = Application.Union(FullRange, Rng)
End If
End If
Next Rng

If FullRange.Cells.Count > 0 Then
FullRange.Select
End If
End If

End Sub


Sub UnSelectActiveArea()
'Chip Pearson
Dim Rng As Range
Dim FullRange As Range
Dim Ndx As Integer
If Selection.Areas.Count > 1 Then
For Each Rng In Selection.Areas
If Application.Intersect(ActiveCell, Rng) Is Nothing Then
If FullRange Is Nothing Then
Set FullRange = Rng
Else
Set FullRange = Application.Union(FullRange, Rng)
End If
End If
Next Rng
FullRange.Select
End If

End Sub


Gord Dibben MS Excel MVP

On Fri, 10 Aug 2007 14:56:01 -0700, gtabmx
<[email protected]>
wrote:

Look like gtabmx got spastic over nothing-- Regards,Peo Sjoblom"RagDyeR"
Look like gtabmx got spastic over nothing


--

Regards,

Peo Sjoblom

Re: Deselect (Unselect) Cells
Maybe this will make sense in some way as our mind can play tricks on us:
After making the selection holding down control, if you click on one of the
cells that was already selected, that cell turns white again ( not light up
or not blue...) and make us think that was de-selected but it's not. However
this feature should be consider for later excel versions (2010?), I'm sure
we'll use it very often.

:

I agree with Mike
I don't know what everyone else is talking about, but you could DEFINITELY deselect cells within a selected entire row/column before in 2003 by holding down CTRL and clicking the cell. I just converted over to 2007 and noticed this is no longer an option. WTF Microsoft! Why would you take this lovely function away! Mike, or anyone else, have you found out how to do this yet???

Ctrl+click in a selection in Excel 2003 doesn't remove the cell from
Ctrl+click in a selection in Excel 2003 doesn't remove the cell from the
selection; it changes the active cell.


--
shg
------------------------------------------------------------------------
shg's Profile: http://www.thecodecage.com/forumz/member.php?userid=13
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=30487

I don't believe that any version of Excel, 2007, 2003 or anythingelse, ever
I don't believe that any version of Excel, 2007, 2003 or anything
else, ever allowed you to unselect a cell, removing it from the
current selection. Holding down the CTRL key changes which cell within
the selected cells is the Active Cell, but it does not and never did
allow you to remove the cell from the Selection. I have code on my
web site at http://www.cpearson.com/excel/unselect.aspx that allows
you to unselect the active cell or the active area, removing it from
the current Selection.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Mon, 17 Nov 2008 07:03:36 -0800, Ashley Mattes wrote:

I think you may be confusing the behavior in Windows Explorer with Excel.
I think you may be confusing the behavior in Windows Explorer with Excel.

Ashley wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
EIS Pcode Training Samples
http://www.eggheadcafe.com/tutorial...e-00c77035998b/eis-pcode-training-sample.aspx
 
This was never possible in Excel -- not be re-clicking it.

By the way, when you make multiple selection while holding ctrl on Word
2007 you can of course unselect by re-clicking...

So keep your lousy explication (like "I think you may be confusing the
behavior in Windows Explorer with Excel") for yourself, thank you.



Bob I wrote:

I think you may be confusing the behavior in Windows Explorer with Excel.
17-Nov-08

I think you may be confusing the behavior in Windows Explorer with Excel.

Ashley wrote:

Previous Posts In This Thread:

Deselect (Unselect) Cells
I have used Excel for a very long time and was used to the way cell
selection
was managed. For example, If I used CTRL to select 5 different cells and
then wanted to deselect one of them, I could just reclick it while holing
CTRL. However, now in Excel 2007 if I select a cell by mistake and want
to
deselect it rather than restart my whole selection process, I cannot. Can
someone please tell me how to deselect a cell if it is selected. If this
is
an impossible task then I, for one, am speachless.

Mike

Not too sure what you are talking about.
Not too sure what you are talking about. To the best of my knowledge you
never could un-select a cell by re-clicking it...
--
HTH...

Jim Thomlinson


:

I don't remember this ever being possible in Excel.
I don't remember this ever being possible in Excel. What version were you
using before 2007? Here's a quote that can be found in both Excel 2003
and
2007 Help Files, relating to selecting non-adjacent cells:

"[Note] You cannot cancel the selection of a cell or range of cells in a
nonadjacent selection without canceling the entire selection."

HTH,
Elkar


:

I have always used 2000 until I upgraded to 2007.
I have always used 2000 until I upgraded to 2007. Why can I not deselect
non-adjacent cells? Was it to difficult for the fellows at Microsoft to
program or was it not a popular function?

:

I agree, that would be a handy feature. Not sure why it was removed.
I agree, that would be a handy feature. Not sure why it was removed.

If you're not aware of it, you can hit SHIFT-F8 to toggle "Add to
Selection"
on/off. This allows you to select multiple cells without holding down any
keys. That doesn't solve the problem, but could help to avoid
accidentally
clicking on a wrong cell and having to start over.

HTH,
Elkar

:

I know of no version of Excel that allows you to de-select a cell by
I know of no version of Excel that allows you to de-select a cell by
re-clicking
in the manner you describe.

Once selected with CTRL + Click, the cells are selected.

Chip Pearson has code to allow de-selecting cells or ranges.

Sub UnSelectActiveCell()
Dim Rng As Range
Dim FullRange As Range
'Chip Pearson
If Selection.Cells.Count > 1 Then
For Each Rng In Selection.Cells
If Rng.Address <> ActiveCell.Address Then
If FullRange Is Nothing Then
Set FullRange = Rng
Else
Set FullRange = Application.Union(FullRange, Rng)
End If
End If
Next Rng

If FullRange.Cells.Count > 0 Then
FullRange.Select
End If
End If

End Sub


Sub UnSelectActiveArea()
'Chip Pearson
Dim Rng As Range
Dim FullRange As Range
Dim Ndx As Integer
If Selection.Areas.Count > 1 Then
For Each Rng In Selection.Areas
If Application.Intersect(ActiveCell, Rng) Is Nothing Then
If FullRange Is Nothing Then
Set FullRange = Rng
Else
Set FullRange = Application.Union(FullRange, Rng)
End If
End If
Next Rng
FullRange.Select
End If

End Sub


Gord Dibben MS Excel MVP

On Fri, 10 Aug 2007 14:56:01 -0700, gtabmx
<[email protected]>
wrote:

I use 2000 and I have never been able to do that, although manyis the time
I use 2000 and I have never been able to do that, although many
is the time that I have wished I could.

Reclicking on a cell just changes it to be the active cell. It turns
to white but is still part of the selection set.

Regards
Martin



It was not removed, since it was never part of Excel.
It was not removed, since it was never part of Excel.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

Like some of folks here, I could have sworn that I used to be able to
select
Like some of folks here, I could have sworn that I used to be able to
select
and de-select in some earlier version of XL ... that is until just this
morning.

I was working in Windows explorer, *AND * THERE* is where it can be done!
!
!

Just got those 2 mixed up in my memory.<bg>
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
I know of no version of Excel that allows you to de-select a cell by
re-clicking
in the manner you describe.

Once selected with CTRL + Click, the cells are selected.

Chip Pearson has code to allow de-selecting cells or ranges.

Sub UnSelectActiveCell()
Dim Rng As Range
Dim FullRange As Range
'Chip Pearson
If Selection.Cells.Count > 1 Then
For Each Rng In Selection.Cells
If Rng.Address <> ActiveCell.Address Then
If FullRange Is Nothing Then
Set FullRange = Rng
Else
Set FullRange = Application.Union(FullRange, Rng)
End If
End If
Next Rng

If FullRange.Cells.Count > 0 Then
FullRange.Select
End If
End If

End Sub


Sub UnSelectActiveArea()
'Chip Pearson
Dim Rng As Range
Dim FullRange As Range
Dim Ndx As Integer
If Selection.Areas.Count > 1 Then
For Each Rng In Selection.Areas
If Application.Intersect(ActiveCell, Rng) Is Nothing Then
If FullRange Is Nothing Then
Set FullRange = Rng
Else
Set FullRange = Application.Union(FullRange, Rng)
End If
End If
Next Rng
FullRange.Select
End If

End Sub


Gord Dibben MS Excel MVP

On Fri, 10 Aug 2007 14:56:01 -0700, gtabmx
<[email protected]>
wrote:

Look like gtabmx got spastic over nothing-- Regards,Peo Sjoblom"RagDyeR"
Look like gtabmx got spastic over nothing


--

Regards,

Peo Sjoblom

Re: Deselect (Unselect) Cells
Maybe this will make sense in some way as our mind can play tricks on us:
After making the selection holding down control, if you click on one of
the
cells that was already selected, that cell turns white again ( not light
up
or not blue...) and make us think that was de-selected but it's not.
However
this feature should be consider for later excel versions (2010?), I'm sure
we'll use it very often.

:

I agree with Mike
I don't know what everyone else is talking about, but you could DEFINITELY
deselect cells within a selected entire row/column before in 2003 by
holding down CTRL and clicking the cell. I just converted over to 2007
and noticed this is no longer an option. WTF Microsoft! Why would you
take this lovely function away! Mike, or anyone else, have you found out
how to do this yet???

Ctrl+click in a selection in Excel 2003 doesn't remove the cell from
Ctrl+click in a selection in Excel 2003 doesn't remove the cell from the
selection; it changes the active cell.


--
shg
------------------------------------------------------------------------
shg's Profile: http://www.thecodecage.com/forumz/member.php?userid=13
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=30487

I don't believe that any version of Excel, 2007, 2003 or anythingelse,
ever
I don't believe that any version of Excel, 2007, 2003 or anything
else, ever allowed you to unselect a cell, removing it from the
current selection. Holding down the CTRL key changes which cell within
the selected cells is the Active Cell, but it does not and never did
allow you to remove the cell from the Selection. I have code on my
web site at http://www.cpearson.com/excel/unselect.aspx that allows
you to unselect the active cell or the active area, removing it from
the current Selection.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Mon, 17 Nov 2008 07:03:36 -0800, Ashley Mattes wrote:

I think you may be confusing the behavior in Windows Explorer with Excel.
I think you may be confusing the behavior in Windows Explorer with Excel.

Ashley wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
EIS Pcode Training Samples
http://www.eggheadcafe.com/tutorial...e-00c77035998b/eis-pcode-training-sample.aspx
 
That's why I posted Chip's code but someone has chosen to ignore all the
responses stating "no version of Excel would ever allow unclicking a
selection"

Then Adrien pops in with a reference to Word which has no bearing on Excel.


Gord

This was never possible in Excel -- not be re-clicking it.

By the way, when you make multiple selection while holding ctrl on Word
2007 you can of course unselect by re-clicking...

So keep your lousy explication (like "I think you may be confusing the
behavior in Windows Explorer with Excel") for yourself, thank you.



Bob I wrote:

I think you may be confusing the behavior in Windows Explorer with Excel.
17-Nov-08

I think you may be confusing the behavior in Windows Explorer with Excel.

Ashley wrote:

Previous Posts In This Thread:

Deselect (Unselect) Cells
I have used Excel for a very long time and was used to the way cell
selection
was managed. For example, If I used CTRL to select 5 different cells and
then wanted to deselect one of them, I could just reclick it while holing
CTRL. However, now in Excel 2007 if I select a cell by mistake and want
to
deselect it rather than restart my whole selection process, I cannot. Can
someone please tell me how to deselect a cell if it is selected. If this
is
an impossible task then I, for one, am speachless.

Mike

Not too sure what you are talking about.
Not too sure what you are talking about. To the best of my knowledge you
never could un-select a cell by re-clicking it...
--
HTH...

Jim Thomlinson


:

I don't remember this ever being possible in Excel.
I don't remember this ever being possible in Excel. What version were you
using before 2007? Here's a quote that can be found in both Excel 2003
and
2007 Help Files, relating to selecting non-adjacent cells:

"[Note] You cannot cancel the selection of a cell or range of cells in a
nonadjacent selection without canceling the entire selection."

HTH,
Elkar


:

I have always used 2000 until I upgraded to 2007.
I have always used 2000 until I upgraded to 2007. Why can I not deselect
non-adjacent cells? Was it to difficult for the fellows at Microsoft to
program or was it not a popular function?

:

I agree, that would be a handy feature. Not sure why it was removed.
I agree, that would be a handy feature. Not sure why it was removed.

If you're not aware of it, you can hit SHIFT-F8 to toggle "Add to
Selection"
on/off. This allows you to select multiple cells without holding down any
keys. That doesn't solve the problem, but could help to avoid
accidentally
clicking on a wrong cell and having to start over.

HTH,
Elkar

:

I know of no version of Excel that allows you to de-select a cell by
I know of no version of Excel that allows you to de-select a cell by
re-clicking
in the manner you describe.

Once selected with CTRL + Click, the cells are selected.

Chip Pearson has code to allow de-selecting cells or ranges.

Sub UnSelectActiveCell()
Dim Rng As Range
Dim FullRange As Range
'Chip Pearson
If Selection.Cells.Count > 1 Then
For Each Rng In Selection.Cells
If Rng.Address <> ActiveCell.Address Then
If FullRange Is Nothing Then
Set FullRange = Rng
Else
Set FullRange = Application.Union(FullRange, Rng)
End If
End If
Next Rng

If FullRange.Cells.Count > 0 Then
FullRange.Select
End If
End If

End Sub


Sub UnSelectActiveArea()
'Chip Pearson
Dim Rng As Range
Dim FullRange As Range
Dim Ndx As Integer
If Selection.Areas.Count > 1 Then
For Each Rng In Selection.Areas
If Application.Intersect(ActiveCell, Rng) Is Nothing Then
If FullRange Is Nothing Then
Set FullRange = Rng
Else
Set FullRange = Application.Union(FullRange, Rng)
End If
End If
Next Rng
FullRange.Select
End If

End Sub


Gord Dibben MS Excel MVP

On Fri, 10 Aug 2007 14:56:01 -0700, gtabmx
<[email protected]>
wrote:

I use 2000 and I have never been able to do that, although manyis the time
I use 2000 and I have never been able to do that, although many
is the time that I have wished I could.

Reclicking on a cell just changes it to be the active cell. It turns
to white but is still part of the selection set.

Regards
Martin



It was not removed, since it was never part of Excel.
It was not removed, since it was never part of Excel.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

Like some of folks here, I could have sworn that I used to be able to
select
Like some of folks here, I could have sworn that I used to be able to
select
and de-select in some earlier version of XL ... that is until just this
morning.

I was working in Windows explorer, *AND * THERE* is where it can be done!
!
!

Just got those 2 mixed up in my memory.<bg>
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
I know of no version of Excel that allows you to de-select a cell by
re-clicking
in the manner you describe.

Once selected with CTRL + Click, the cells are selected.

Chip Pearson has code to allow de-selecting cells or ranges.

Sub UnSelectActiveCell()
Dim Rng As Range
Dim FullRange As Range
'Chip Pearson
If Selection.Cells.Count > 1 Then
For Each Rng In Selection.Cells
If Rng.Address <> ActiveCell.Address Then
If FullRange Is Nothing Then
Set FullRange = Rng
Else
Set FullRange = Application.Union(FullRange, Rng)
End If
End If
Next Rng

If FullRange.Cells.Count > 0 Then
FullRange.Select
End If
End If

End Sub


Sub UnSelectActiveArea()
'Chip Pearson
Dim Rng As Range
Dim FullRange As Range
Dim Ndx As Integer
If Selection.Areas.Count > 1 Then
For Each Rng In Selection.Areas
If Application.Intersect(ActiveCell, Rng) Is Nothing Then
If FullRange Is Nothing Then
Set FullRange = Rng
Else
Set FullRange = Application.Union(FullRange, Rng)
End If
End If
Next Rng
FullRange.Select
End If

End Sub


Gord Dibben MS Excel MVP

On Fri, 10 Aug 2007 14:56:01 -0700, gtabmx
<[email protected]>
wrote:

Look like gtabmx got spastic over nothing-- Regards,Peo Sjoblom"RagDyeR"
Look like gtabmx got spastic over nothing


--

Regards,

Peo Sjoblom

Re: Deselect (Unselect) Cells
Maybe this will make sense in some way as our mind can play tricks on us:
After making the selection holding down control, if you click on one of
the
cells that was already selected, that cell turns white again ( not light
up
or not blue...) and make us think that was de-selected but it's not.
However
this feature should be consider for later excel versions (2010?), I'm sure
we'll use it very often.

:

I agree with Mike
I don't know what everyone else is talking about, but you could DEFINITELY
deselect cells within a selected entire row/column before in 2003 by
holding down CTRL and clicking the cell. I just converted over to 2007
and noticed this is no longer an option. WTF Microsoft! Why would you
take this lovely function away! Mike, or anyone else, have you found out
how to do this yet???

Ctrl+click in a selection in Excel 2003 doesn't remove the cell from
Ctrl+click in a selection in Excel 2003 doesn't remove the cell from the
selection; it changes the active cell.


--
shg
------------------------------------------------------------------------
shg's Profile: http://www.thecodecage.com/forumz/member.php?userid=13
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=30487

I don't believe that any version of Excel, 2007, 2003 or anythingelse,
ever
I don't believe that any version of Excel, 2007, 2003 or anything
else, ever allowed you to unselect a cell, removing it from the
current selection. Holding down the CTRL key changes which cell within
the selected cells is the Active Cell, but it does not and never did
allow you to remove the cell from the Selection. I have code on my
web site at http://www.cpearson.com/excel/unselect.aspx that allows
you to unselect the active cell or the active area, removing it from
the current Selection.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Mon, 17 Nov 2008 07:03:36 -0800, Ashley Mattes wrote:

I think you may be confusing the behavior in Windows Explorer with Excel.
I think you may be confusing the behavior in Windows Explorer with Excel.

Ashley wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
EIS Pcode Training Samples
http://www.eggheadcafe.com/tutorial...e-00c77035998b/eis-pcode-training-sample.aspx
 
Just what part of "This can't be done in Excel" escapes you?
By the way, when you make multiple selection while holding ctrl on Word 2007 you can of course unselect by re-clicking...

So keep your lousy explication (like "I think you may be confusing the behavior in Windows Explorer with Excel") for yourself, thank you.



Bob I wrote:

I think you may be confusing the behavior in Windows Explorer with Excel.
17-Nov-08

I think you may be confusing the behavior in Windows Explorer with Excel.

Ashley wrote:

Previous Posts In This Thread:

Deselect (Unselect) Cells
I have used Excel for a very long time and was used to the way cell selection
was managed. For example, If I used CTRL to select 5 different cells and
then wanted to deselect one of them, I could just reclick it while holing
CTRL. However, now in Excel 2007 if I select a cell by mistake and want to
deselect it rather than restart my whole selection process, I cannot. Can
someone please tell me how to deselect a cell if it is selected. If this is
an impossible task then I, for one, am speachless.

Mike

Not too sure what you are talking about.
Not too sure what you are talking about. To the best of my knowledge you
never could un-select a cell by re-clicking it...
--
HTH...

Jim Thomlinson


:

I don't remember this ever being possible in Excel.
I don't remember this ever being possible in Excel. What version were you
using before 2007? Here's a quote that can be found in both Excel 2003 and
2007 Help Files, relating to selecting non-adjacent cells:

"[Note] You cannot cancel the selection of a cell or range of cells in a
nonadjacent selection without canceling the entire selection."

HTH,
Elkar


:

I have always used 2000 until I upgraded to 2007.
I have always used 2000 until I upgraded to 2007. Why can I not deselect
non-adjacent cells? Was it to difficult for the fellows at Microsoft to
program or was it not a popular function?

:

I agree, that would be a handy feature. Not sure why it was removed.
I agree, that would be a handy feature. Not sure why it was removed.

If you're not aware of it, you can hit SHIFT-F8 to toggle "Add to Selection"
on/off. This allows you to select multiple cells without holding down any
keys. That doesn't solve the problem, but could help to avoid accidentally
clicking on a wrong cell and having to start over.

HTH,
Elkar

:

I know of no version of Excel that allows you to de-select a cell by
I know of no version of Excel that allows you to de-select a cell by re-clicking
in the manner you describe.

Once selected with CTRL + Click, the cells are selected.

Chip Pearson has code to allow de-selecting cells or ranges.

Sub UnSelectActiveCell()
Dim Rng As Range
Dim FullRange As Range
'Chip Pearson
If Selection.Cells.Count > 1 Then
For Each Rng In Selection.Cells
If Rng.Address <> ActiveCell.Address Then
If FullRange Is Nothing Then
Set FullRange = Rng
Else
Set FullRange = Application.Union(FullRange, Rng)
End If
End If
Next Rng

If FullRange.Cells.Count > 0 Then
FullRange.Select
End If
End If

End Sub


Sub UnSelectActiveArea()
'Chip Pearson
Dim Rng As Range
Dim FullRange As Range
Dim Ndx As Integer
If Selection.Areas.Count > 1 Then
For Each Rng In Selection.Areas
If Application.Intersect(ActiveCell, Rng) Is Nothing Then
If FullRange Is Nothing Then
Set FullRange = Rng
Else
Set FullRange = Application.Union(FullRange, Rng)
End If
End If
Next Rng
FullRange.Select
End If

End Sub


Gord Dibben MS Excel MVP

I use 2000 and I have never been able to do that, although manyis the time
I use 2000 and I have never been able to do that, although many
is the time that I have wished I could.

Reclicking on a cell just changes it to be the active cell. It turns
to white but is still part of the selection set.

Regards
Martin



It was not removed, since it was never part of Excel.
It was not removed, since it was never part of Excel.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

Like some of folks here, I could have sworn that I used to be able to select
Like some of folks here, I could have sworn that I used to be able to select
and de-select in some earlier version of XL ... that is until just this
morning.

I was working in Windows explorer, *AND * THERE* is where it can be done! !
!

Just got those 2 mixed up in my memory.<bg>
 
Double click. Works in every version of Excel up to 2003. I haven't tried it in 2007, but can later today. (I don't like office 2007 for various reasons, so wouldn't be surprised if they removed the easy deselect function).

cheers,
chris



Adrien Mel wrote:

I'm pretty sure it was possible
05-Jan-10

By the way, when you make multiple selection while holding ctrl on Word 2007 you can of course unselect by re-clicking...

So keep your lousy explication (like "I think you may be confusing the behavior in Windows Explorer with Excel") for yourself, thank you.

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Run an ASP Page with parameters from SQL Server
http://www.eggheadcafe.com/tutorial...5-687cb5e039d6/run-an-asp-page-with-para.aspx
 
Would be a great trick if it actually worked in any version of Excel.

Unfortunately, it does not.


Gord Dibben MS Excel MVP
 
Back
Top