If you have pressed F8 to Extend Selection, the result will be what you're
describing. I have no problem with using Ctrl to make multiple selections in
Excel 2007, SP1.

Tyro
..
"ripley" wrote in message
...
I was trying to select two non-adjacent columns for a chart and I can
select
one and when I try to select the second range, holding the CTRL key before
selecting, the first selection turns off. I have used this feature for
years
and this is the first time I have come across this problem.

Is there an option to turn the Ctrl+select feature off in Excel 2007?