---
title: "Sort data"
slug: "sort-data"
description: "Sort columns in ascending or descending order, define a default view for a worksheet, and reset your personalized worksheet view to the default one."
updated: 2022-11-29T02:21:40Z
published: 2022-11-29T02:21:40Z
canonical: "docs.zilliant.com/sort-data"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.zilliant.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Sort data

You can sort data in a worksheet in several ways. You can:

- Reorder worksheet rows by column sort order
- Define a default view
- Reset your personalized view to the default view

Your sort selections are visible only to you. Your selections are saved and automatically applied each time you open a worksheet.

## Reorder worksheet rows by column sort order

To arrange a worksheet according to the ascending or descending values in a specific column, select the column header. Select the header multiple times to sort data in ascending order, descending order, or none.

You can also sort worksheets by multiple columns. To do this, select the column header to sort the first column, then **Shift+click** to select additional column headers. As you do this, each sorted column displays a number marker that indicates the sort order.

For example, if the first-sorted column has the value **Brake Parts** in its first 100 rows, then the second-sorted column will further sort these 100 rows, and so on. There is no limit to the number of columns you can sort in your worksheets.

## Define a default view for a worksheet

After dragging your worksheet columns into your preferred column order, applying desired column widths, setting column sort order, and setting column visibility, you can save the resulting view as the default view for that worksheet. This is what other users will see each time they reset their personalized views to the default view.

To save your current view as the default view:

1. Next to Properties, select the dropdown icon.
2. Select **Set worksheet settings as default**.
3. Select one or more settings to save as default.
4. Select **Save**.

## Reset your personalized view to the default view

It can sometimes be useful to reset your personalized changes by reverting your view back to the default view. To do this:

1. Next to Properties, select the dropdown icon.
2. Select **Reset worksheet settings to default**.
3. Select **Save**.

![](https://cdn.document360.io/24f960e8-3c1c-4c18-a2c6-83b6ae4aab84/Images/Glossary/settings_60.png?sv=2026-02-06&spr=https&st=2026-11-04T19%3A12%3A19Z&se=2026-11-04T20%3A12%3A19Z&sr=c&sp=r&sig=Zl0zqUYtcncKhhzhTdF5Tow62PunpsSXtpmhwt%2By9yc%3D)

Properties