Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
anand sharma
 
Posts: n/a
Default left click on a cell and more cells are highlighted

i was trying to click on a/any cell in a new worksheet in excel and more than
one cell became blue.i.e. highlighted automatically. can any one help as to
why this happens and how to get rid of this problem? thanx. anand.
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

anand

A common cause of this is that you are in "Extended" or "Add" mode.

If you see "EXT" or "ADD" down on the status bar try hitting F8 key a couple
of times.

F8 will will toggle you in and out of Extended mode. SHIFT + F8 will put you
in "ADD" mode.

With the "ADD" mode you need to re-click the mouse. This is used to select
non-contiguous cells and ranges without using the CTRL key.

With the "EXT" mode you just click once and drag. All cells will be selected.

If you are using a wheel-mouse tap the wheel a couple times.

Also see David McRitchie's "Ghosting" at

http://www.mvps.org/dmcritchie/excel/ghosting.txt


Gord Dibben Excel MVP

On Wed, 22 Jun 2005 14:32:01 -0700, anand sharma <anand
wrote:

i was trying to click on a/any cell in a new worksheet in excel and more than
one cell became blue.i.e. highlighted automatically. can any one help as to
why this happens and how to get rid of this problem? thanx. anand.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 11:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"