novice excel 2007 user needs help
 

on previous versions of excel, when you hold down the left mouse button and
drag over multiple cells, the cells would have a shaded effect so that you
could tell what cells you had highlighted. excel 2007 (currently using trial
version) doesn't seem to do that. this is especially irritating when you use
control and choose cells in different areas of the worksheet and can't
remember which ones you have yet to click on. is there some option that i
can change to fix this?

thanks for any assistance on this.

novice excel 2007 user needs help
 

Jamie,

That is by design, and there is no setting that will change it.

HTH,
Bernie
MS Excel MVP


"Jamie" wrote in message
...
on previous versions of excel, when you hold down the left mouse button and
drag over multiple cells, the cells would have a shaded effect so that you
could tell what cells you had highlighted. excel 2007 (currently using trial
version) doesn't seem to do that. this is especially irritating when you use
control and choose cells in different areas of the worksheet and can't
remember which ones you have yet to click on. is there some option that i
can change to fix this?

thanks for any assistance on this.

novice excel 2007 user needs help
 

thank you for answering, but i don't understand why that was changed. Is
there any reason why someone would not want that characteristic? Is the new
way somehow better, and I'm just griping for no reason?

"Bernie Deitrick" wrote:

Jamie,

That is by design, and there is no setting that will change it.

HTH,
Bernie
MS Excel MVP


"Jamie" wrote in message
...
on previous versions of excel, when you hold down the left mouse button and
drag over multiple cells, the cells would have a shaded effect so that you
could tell what cells you had highlighted. excel 2007 (currently using trial
version) doesn't seem to do that. this is especially irritating when you use
control and choose cells in different areas of the worksheet and can't
remember which ones you have yet to click on. is there some option that i
can change to fix this?

thanks for any assistance on this.

novice excel 2007 user needs help
 

There is confusion somewhere as my Excel 2007 acts as you wish, graying
cells , and so did my 2003.
Please recheck your reply Bernie.
SG

"Jamie" wrote in message
...
thank you for answering, but i don't understand why that was changed. Is
there any reason why someone would not want that characteristic? Is the
new
way somehow better, and I'm just griping for no reason?

"Bernie Deitrick" wrote:

Jamie,

That is by design, and there is no setting that will change it.

HTH,
Bernie
MS Excel MVP


"Jamie" wrote in message
...
on previous versions of excel, when you hold down the left mouse button
and
drag over multiple cells, the cells would have a shaded effect so that
you
could tell what cells you had highlighted. excel 2007 (currently using
trial
version) doesn't seem to do that. this is especially irritating when
you use
control and choose cells in different areas of the worksheet and can't
remember which ones you have yet to click on. is there some option
that i
can change to fix this?

thanks for any assistance on this.

novice excel 2007 user needs help
 

Jamie,

It might be that the trial version does not do that, but Excel 2007, as well
as 2000, 2002 and 2003 all do exactly what you require.

--
Hth

Kassie Kasselman
Change xxx to hotmail


"Jamie" wrote:

on previous versions of excel, when you hold down the left mouse button and
drag over multiple cells, the cells would have a shaded effect so that you
could tell what cells you had highlighted. excel 2007 (currently using trial
version) doesn't seem to do that. this is especially irritating when you use
control and choose cells in different areas of the worksheet and can't
remember which ones you have yet to click on. is there some option that i
can change to fix this?

thanks for any assistance on this.