Cor Nouws <[EMAIL PROTECTED]> wrote: > Hi Zed, > > zed wrote (26-12-2007 9:09) > > I have recently started using Calc and am having difficulty in sorting > > columns. Let me explain. > > > > I have two columns. The first one has First Names listed and the second > > (to the right) has Family Names, for example > > > > Alec Mackintosh Cedric Humblebee David > > Whistleton Edward Aldeburgh > > > > I want to sort them so they appear as follows: > > > > Edward Aldeburgh Cedric Humblebee Alec Mackintosh > > David Whistleton > > > > I have been into Data/Sort and endeavoured to choose the family name (in > > alphabetical order) to sort by and tried to change the parameters but > > try as I might, I cannot achieve what I want. > > > > Any help would be appreciated. > > > > Regards from New Zealand on a very wet Wednesday evening. > > Greeting from a bit grey Wednesday morning in The Netherlands. > > What probably will help: just put the focus in one of the cells in the > area. When starting Data|Sort, OOo Calc will select the whole area > involved.
I tried this but it didn't select the whole area. Must have something set up incorrectly. However, Brian's explanation worked. > Most problems I've seen, are related to this, because people in Excel have > (or are used) to make some selection themelves. Yes, I'd previouisly used !Eureka, which is very similar to Excel, on an Acorn RiscPC. Zed -- zed --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
