Sort, and Hide Fields

In this tutorial, we will learn how to arrange, sort, and hide fields in a worksheet. We will begin with sorting, followed by hiding columns, and finally, rearranging the columns. Each step is illustrated to ensure clarity and ease of understanding.

Step 1

Start by clicking on the "Sort" option. This will display the available fields such as car, manufacturing year, and kilometer.

Step 2

You will see all the fields like car, manufacturing year, and kilometer. If you want to sort by kilometer, proceed to the next step.

Step 3

To sort by kilometer, simply select the kilometer field. This will sort the data by kilometer. You can also add multiple sorting criteria.

Step 4

You can add new sorting criteria, such as sorting by car name. This will sort by both kilometer and car name.

Step 5

Once sorted, you can save the sort settings. This ensures that the next time you open the sheet, it will display the data in the sorted order.

Step 6

If you want to sort only one field, you can do so by clicking on the small sorting icon next to the field name.

Step 7

In addition to sorting, you can also hide fields. For instance, if you do not want to see the kilometer or manufacturing year fields, you can hide them. Click on "Hide" to hide the selected fields. We can hide multiple fields at a time.

Step 8

Lastly, you can rearrange the fields by dragging them to the desired position. The new arrangement will be saved and available the next time you open the sheet.