OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Multiple Selections using Ctrl

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
8daysaweek.co.uk
Super User
Super User


Joined: 29 Nov 2003
Posts: 2130
Location: UK

PostPosted: Sun Dec 28, 2003 7:07 am    Post subject: Multiple Selections using Ctrl Reply with quote

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 Question
_________________
James
www.8daysaweek.co.uk - A User-Focused OOo site
Back to top
View user's profile Send private message Visit poster's website AIM Address
8daysaweek.co.uk
Super User
Super User


Joined: 29 Nov 2003
Posts: 2130
Location: UK

PostPosted: Sun Dec 28, 2003 10:44 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Visit poster's website AIM Address
Sue
Power User
Power User


Joined: 22 Nov 2003
Posts: 74
Location: New Zealand

PostPosted: Sun Dec 28, 2003 1:25 pm    Post subject: selecting non-adjacent cells. Reply with quote

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
Back to top
View user's profile Send private message AIM Address
8daysaweek.co.uk
Super User
Super User


Joined: 29 Nov 2003
Posts: 2130
Location: UK

PostPosted: Sun Dec 28, 2003 1:47 pm    Post subject: Reply with quote

Thanks Sue,

That's really useful, I can move over more of my spreadsheets to OOo now Smile
_________________
James
www.8daysaweek.co.uk - A User-Focused OOo site
Back to top
View user's profile Send private message Visit poster's website AIM Address
deko
Newbie
Newbie


Joined: 11 Feb 2004
Posts: 4
Location: The Netherlands

PostPosted: Thu Apr 15, 2004 3:29 am    Post subject: meervoudige selectie van cellen, rijen en kolommen Reply with quote

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
Back to top
View user's profile Send private message Visit poster's website
DannyB
Moderator
Moderator


Joined: 02 Apr 2003
Posts: 3991
Location: Lawrence, Kansas, USA

PostPosted: Thu Apr 15, 2004 6:01 am    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
Agravayne
General User
General User


Joined: 18 May 2004
Posts: 15

PostPosted: Tue May 18, 2004 8:11 am    Post subject: Copying thse Cells Reply with quote

I can select like this but cannot copy? It states that this action os not availabke on Multiple Objects? Any Ideas?
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group