Re: open office software SPREADSHEETS

2019-10-24 Thread Alan B
Do you want to sort data in column A -or- sort entire rows using column A to order the rows? The two operations produce different results. I posted a video on YouTube ages ago showing these operations. The interface is changed a bit since but the ideas, select what you want to sort, then sort, ha

Re: open office software SPREADSHEETS

2019-10-24 Thread Steven Ahlers
In the Data drop down menu choose: 1) Define Range: give it a one word name, in the Range box specify the first and last cells 2) Select Range: choose a named range 3) Sort: Options tab—allows you to select options Sort Criteria—allows you to choose column(s) to sort on and ord

Re: open office software SPREADSHEETS

2019-10-24 Thread David Belina
Wiki.openoffice.org has this: The first step in sorting data is to select the data that you want to sort. To sort the data in Table 1, select the cells from A1 to G16—if you include the column headers, indicate this in the sort dialog. Use Data > Sort to open the Sort dialog. You can sort by up

open office software SPREADSHEETS

2019-10-24 Thread John Clipper
I will gladly pay for help. nearly 2 hours spent on - 1. How to sign on to a Forum in order to ask a question on Forum re spreadsheets. No success. 2. found some “answers”. without signing on. See #1 3. The question was about how to sort data in Col A 4. I have used other features with succ