Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2008

Tip: Looking for answers? Try searching our database.

novice excel 2007 user needs help

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jamie - 29 Feb 2008 13:19 GMT
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.
Bernie Deitrick - 29 Feb 2008 19:08 GMT
Jamie,

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

HTH,
Bernie
MS Excel MVP

> 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
[quoted text clipped - 5 lines]
>
> thanks for any assistance on this.
Jamie - 29 Feb 2008 23:30 GMT
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?

> Jamie,
>
[quoted text clipped - 13 lines]
> >
> > thanks for any assistance on this.
shakey - 01 Mar 2008 03:34 GMT
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

> 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
[quoted text clipped - 23 lines]
>> >
>> > thanks for any assistance on this.
Kassie - 01 Mar 2008 10:13 GMT
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.

Signature

Hth

Kassie Kasselman
Change xxx to hotmail

> 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
[quoted text clipped - 5 lines]
>
> thanks for any assistance on this.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.