A slightly simpler solution, IF the dataset is contiguous (no blank columns or rows within it): Just select a single cell somewhere in the data that you want to sort. When you select Data > Sort, Calc will automatically select the entire range of data.

Again, this only works if your data set has no blank rows or columns.

Jim Hartley wrote:
Select ALL the columns you want sorted (maybe select everything), THEN do the sort. I routinely sort everything is a spreadsheet I use as a sort of cheap-and-dirty database.

Jim Hartley

Joe Marks wrote:
In calc when a column is sorted alphabetically only the column selected is changed. How can I sort a column alphabetically and have all the columns stay attached. For example in an "address book" I want to sort by the "Last Name" column and have all the other columns sorted at the same time so each row has the correct name and addresses.


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to