# Sort multiple columns - based on one column
**URL:** https://forum.collaboraonline.com/t/sort-multiple-columns-based-on-one-column/2896
**Category:** User Support
**Created:** [August 26, 2024, 9:11pm UTC](https://forum.collaboraonline.com/t/sort-multiple-columns-based-on-one-column/2896 "2024-08-26T21:11:08Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@smokinjo](https://forum.collaboraonline.com/u/smokinjo)
#### Post date: [August 26, 2024, 9:11pm UTC](https://forum.collaboraonline.com/t/sort-multiple-columns-based-on-one-column/2896/1 "2024-08-26T21:11:08Z")
I am using Next Cloud Office, which is based on Collabora online.
I am trying to be able to sort my data in one column. But, I want the other columns to be sorted based on the sort in the chosen column.
In Libre office, or even google sheets, you can choose a column, then it automaticaly asks if you want to extend that soft to all the columns.
I have not fund a way to do this in Next Office/Collabora.
Can any one point the way?
Thanks
---
### Author:  [@darshan](https://forum.collaboraonline.com/u/darshan)
#### Post date: [August 27, 2024, 7:01am UTC](https://forum.collaboraonline.com/t/sort-multiple-columns-based-on-one-column/2896/2 "2024-08-27T07:01:04Z")
hii @smokinjo welcome to collabora online
> [@smokinjo](#):
>
> I have not fund a way to do this in Next Office/Collabora.
> Can any one point the way?
Oh sure let me paste some steps here so you will be easily do this task.
In Nextcloud Office, which is based on Collabora Online, the functionality to sort a single column while automatically extending the sort to the other columns isn’t as straightforward as in LibreOffice or Google Sheets. However, you can achieve this by manually selecting the entire range of data you want to sort.
Here’s how you can do it:
1. **Select the Entire Data Range** : Before sorting, make sure to select the entire range of data that you want to include in the sort. This includes all the columns that you want to be sorted together.
2. **Access the Sort Function** :
3. **Specify the Sort Column** :
4. **Apply the Sort** : After specifying the sort column and ensuring the entire range is selected, apply the sort. This should rearrange the data in all columns based on the sort order of the chosen column.
If you don’t see the “Extend selection” option directly, manually selecting the entire data range before sorting is crucial, as this will ensure that all columns are sorted together.
This method should help you sort your data in Collabora Online while keeping all your columns aligned with the sort order of your chosen column.
---
### Author:  [@darshan](https://forum.collaboraonline.com/u/darshan)
#### Post date: [August 27, 2024, 1:47pm UTC](https://forum.collaboraonline.com/t/sort-multiple-columns-based-on-one-column/2896/3 "2024-08-27T13:47:16Z")