Re: [libreoffice-users] Sorting Calc Sheet in Alphabet orde on names in one Column

2015-10-26 Thread ajebay 

On 26/10/2015 05:11, Alan B wrote:

On Sun, Oct 25, 2015 at 4:48 PM, ajebay  wrote:


I have a calc spreadsheet with many lines of data which include one column
with names for the line.
I want to sort the names from A to Z, top to bottom, and have all the
corresponding data in each line move with the corresponding name.  Hope
this is clear.
Is this possible?


I see you've already gotten several helpful replies. Couldn't resist adding
my 2¢. It gives me a chance to share a video I did several years ago to
answer the very same question for my Uncle.

https://youtu.be/RjTgDyNqqQY?list=PLGCG5NYY1-dqMgUQ5E1kAITPfqlHmPJP1

Apologies for the monotone. Riveting narration is not my forte.

-Alan


Hi to all who have answered and many thanks, I have it now. Brilliant.
Sorry to have been dense.
Thanks again,
Budge

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Sorting Calc Sheet in Alphabet orde on names in one Column

2015-10-25 Thread Joe Conner 
Yes. You must first select all the cells you want to sort. You can 
easily do this by clicking the little square above the row numbers and 
left of the column letters. This will select the entire sheet. Next from 
the top heading bar at the very top select DATA then from the drop-down 
context menu select SORT. Then select the sort critera (in your case the 
columns that have the names in it. Also mark if you want the sort 
ascending or descending (you want ascending). If you want a secondary 
sort you can input the criteria also. Finally click the OK button at the 
bottom.


Blessings, Joe Conner, Poulsbo, WA USA

On 10/25/2015 01:48 PM, ajebay wrote:
I have a calc spreadsheet with many lines of data which include one 
column with names for the line.
I want to sort the names from A to Z, top to bottom, and have all the 
corresponding data in each line move with the corresponding name.  
Hope this is clear.

Is this possible?



--
Blessings, Joe
Joshua 24:15  "as for me and my house, we will serve the Lord."


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Sorting Calc Sheet in Alphabet orde on names in one Column

2015-10-25 Thread Piet van Oostrum 
ajebay wrote:

 > I have a calc spreadsheet with many lines of data which include one 
 > column with names for the line.
 > I want to sort the names from A to Z, top to bottom, and have all the 
 > corresponding data in each line move with the corresponding name.  Hope 
 > this is clear.
 > Is this possible?

Yes.

Select all the data, i.e. all rows and all columns.
Then use Data > Sort, and select the column of the names as the sort column. 
Now all the SELECTED data will be sorted with the names.
If you would exclude certain columns or rows from the selection they would not 
move with the sorting but stay where they are.
-- 
Piet van Oostrum 
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Sorting Calc Sheet in Alphabet orde on names in one Column

2015-10-25 Thread Alan B 
On Sun, Oct 25, 2015 at 4:48 PM, ajebay  wrote:

> I have a calc spreadsheet with many lines of data which include one column
> with names for the line.
> I want to sort the names from A to Z, top to bottom, and have all the
> corresponding data in each line move with the corresponding name.  Hope
> this is clear.
> Is this possible?


I see you've already gotten several helpful replies. Couldn't resist adding
my 2¢. It gives me a chance to share a video I did several years ago to
answer the very same question for my Uncle.

https://youtu.be/RjTgDyNqqQY?list=PLGCG5NYY1-dqMgUQ5E1kAITPfqlHmPJP1

Apologies for the monotone. Riveting narration is not my forte.

-Alan

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Sorting Calc Sheet in Alphabet orde on names in one Column

2015-10-25 Thread ajebay 
I have a calc spreadsheet with many lines of data which include one 
column with names for the line.
I want to sort the names from A to Z, top to bottom, and have all the 
corresponding data in each line move with the corresponding name.  Hope 
this is clear.

Is this possible?

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted