View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
muddan madhu muddan madhu is offline
external usenet poster
 
Posts: 747
Default why do multiple cells get selected when i click only one cell?

may be?

cell has some formula which is referenced to different cells, so if
click on that it will select the referenced cells.

only if edit directly in cell is unchecked. ( tools | option | edit
tab )




On Oct 13, 8:26*pm, Colie wrote:
In certain areas of the Excel file, if you click on one cell multiple cells
below get selected too; with out holding Shift down.