Multiple Selections using Ctrl

[8daysaweek.co.uk]

I often select different cells in Excel by holding down the Ctrl key, then clicking on individual cells. This means that non-consecutive cells can be selected (as opposed to using Shift).
This is consistent with Windows Explorer behaviour.

This doesn't work in Calc - is there another way of doing it
_________________
James
www.8daysaweek.co.uk - A User-Focused OOo site

[8daysaweek.co.uk]

This is really useful when you have a list of values and want to quickly add together entry 1, 3 and 7 in the list (for instance) - click on each of them while holding down CTRL and you get a quick sum of the values in the status bar.
_________________
James
www.8daysaweek.co.uk - A User-Focused OOo site

[Sue]

If you click in a cell, it is not selected, but focused.
To select a cell: hold down the SHIFT key and then click on it.
After having done so, you'll be able to select multiple non-adjacent cells, holding down the CTRL key.
Have Fun

[8daysaweek.co.uk]

Thanks Sue,

That's really useful, I can move over more of my spreadsheets to OOo now
_________________
James
www.8daysaweek.co.uk - A User-Focused OOo site

[deko]

Thanx for this help! It helped me as well!

For the dutch users I added a few words so they will be able to find this topic faster...

Bovenstaande uitleg heeft betrekking op de functie "meervoudige selectie", die niet op dezelfde wijze functioneert als het selecteren van cellen, rijen en kolommen in Excel.

Het werkt dus als volgt:
- klik eerst met de muis op de `eerste´ cel, rij of kolom;
- druk daarna shift in + nogmaals een klik met de linkermuisknop;
- nu kun je erop los selecteren met de CTRL-toets + muis op de manier zoals je gewend was.

Succes!
_________________
just for the fun

[DannyB]

In general, a procedure seems to be....
1. Click first cell, then SHIFT-click something -- either the same cell, or another cell to expand the selection from the first cell to the new cell.
2. CTRL-click the first cell of another selection range.
3. Optionally, SHIFT-CLICK another cell to expand the second selection from the cell in step 2 to this cell.
4. Repeat steps 2 and optionally 3 until you have selected desired cells.

Here is a concrete example.
1A. Click A1.
1B. SHIFT-Click D2
2. CTRL-Click A4
3. SHIFT-Click D5
_________________
Want to make OOo Drawings like the colored flower design to the left?

[Agravayne]

I can select like this but cannot copy? It states that this action os not availabke on Multiple Objects? Any Ideas?