multiple cells get selected

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

exporting auto texts in word - 19 Dec 2006 05:44 GMT

one of the cells in my worksheet appears to be locked and whenever i click
on a adjacent or far away cell, the range of cells between the locked cell
and cell whee I clicked get selected. I have 3 worksheets in the file and
when i click on 2nd or 3rd worksheet, the title bar shows the file name with
(group) along with it. How can I get rid of such automatic selection of
cells. Control+A also do not work for selecting all cells. Thanks

Reply to this Message

Roger Govier - 19 Dec 2006 08:08 GMT

Hi

At the bottom of your sheet it probably show the word EXT
Try pressing F8 and that should clear the problem.

Signature

Regards

Roger Govier

> one of the cells in my worksheet appears to be locked and whenever i
> click
[quoted text clipped - 7 lines]
> of
> cells. Control+A also do not work for selecting all cells. Thanks

Reply to this Message

Nick Hodge - 19 Dec 2006 09:06 GMT

Roger

I can't make extended mode select the sheet tabs as the OP suggests? In fact
selecting worksheet tabs switches this mode off

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
www.nickhodge.co.uk

> Hi
>
[quoted text clipped - 11 lines]
>> (group) along with it. How can I get rid of such automatic selection of
>> cells. Control+A also do not work for selecting all cells. Thanks

Reply to this Message

Roger Govier - 19 Dec 2006 11:44 GMT

Hi Nick

>one of the cells in my worksheet appears to be locked and whenever i
>click on a adjacent or far away cell, the range of cells between the
>locked cell and cell whee I clicked get selected

I was referring to the cells being selected, not the Sheets being
Grouped.
I didn't think the grouping of sheets was related to the problem -
anyway you have told him how to de-select the grouping.

> In fact selecting worksheet tabs switches this mode off

Quite right, I had never realised that this happens when you click a
sheet tab.

Neither of us dealt with his other question, about Ctrl+A

In XL2003, you need to press Ctrl+A twice, in order to invoke the
selection of all cells.

Signature

Regards

Roger Govier

> Roger
>
[quoted text clipped - 17 lines]
>>> selection of
>>> cells. Control+A also do not work for selecting all cells. Thanks

Reply to this Message

Nick Hodge - 19 Dec 2006 11:51 GMT

Back for the sherry eh! ;-)

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
www.nickhodge.co.uk

> Hi Nick
>
[quoted text clipped - 36 lines]
>>>> of
>>>> cells. Control+A also do not work for selecting all cells. Thanks

Reply to this Message

Nick Hodge - 19 Dec 2006 08:09 GMT

It's a faulting wheel mouse, (or it's drivers)

When it happens, try hitting the wheel a few times. That may clear it. If
not try un-installing the drivers and re-installing.

Much of your symptoms are coincidental, associated with the 'stuck' wheel.
The [Group] is a feature of Excel where if you click on sheet tabs while
holding shift (for contiguous selection) or ctrl (for non-contiguous
selection), anything you then do on any selected sheets will be mirrored on
the others. To deselect, click on a non-selected tab or right click on one
and select 'ungroup'

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
www.nickhodge.co.uk

> one of the cells in my worksheet appears to be locked and whenever i
> click
[quoted text clipped - 5 lines]
> (group) along with it. How can I get rid of such automatic selection of
> cells. Control+A also do not work for selecting all cells. Thanks

Reply to this Message

Rate this thread: