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
wrote:

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

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

wrote:

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

Look like gtabmx got spastic over nothing


--

Regards,

Peo Sjoblom

"RagDyeR" wrote in message
...
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

wrote:

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

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.

"Peo Sjoblom" wrote:

Look like gtabmx got spastic over nothing


--

Regards,

Peo Sjoblom

"RagDyeR" wrote in message
...
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

wrote:

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