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.