+5 votes
100 views
How to sort texts and data in an Excel table

in Help by (551k points)
reopened | 100 views

1 Answer

+3 votes
Best answer

How to sort data and texts in an Excel table?

image image

The spreadsheets are one of the tools used in office automation. In addition, they can be obtained for free through programs such as LibreOffice, OpenOffice or Google itself..

In this article, we are going to show you how to sort text and data in Excel using the software included in the free LibreOffice suite . This office automation package also includes a complete word processor, among other tools, and can be safely downloaded from this link.

Once installed and opened, on the LibreOffice main screen we can see all the programs that we can use . We just have to click on 'Workbook' to open the free equivalent of Microsoft Excel..

 

image

How to sort data and texts in an Excel table?

A spreadsheet, or Excel, is a document in which we can create tables of data and values . It is used, generally, in accounting tasks. In this case, we are going to see how we can take advantage of it to organize, for example, our video library, bookstore, disco, etc.

We have the template that you see in the image below. In it, we have placed some of the films that populate our library. On one side, we see the title of the film and, to its right, the director of the film. If after entering our entire collection we do not want to go through the complete list in search of a specific tape, we can organize the columns in alphabetical order . The process couldn't be easier..

We select the column of data that we want to sort. We click on the heading letter .

image

Now, we go to the upper tab and click on 'Data' .

image

On the next screen, we can ask you to sort the data in ascending order (from A to Z) or descending (from Z to A). You just have to click on the chosen option and, automatically, all the data will be reordered. But beware! One thing must be taken into account: we have two columns with two different data and we want the data to be sorted by keeping the correspondence between the two columns. Thus, when on the next screen we are asked if we only want to sort the data of the selected column or also those of the neighboring one, we will say yes to the last option.

image

As you can see in the following screenshot, the data of the selected column has been reorganized alphabetically, respecting the coherence with the column next to it.

image

Therefore, remember, we will select the column that we want to sort and, if it has other columns with related data next to it, we will expand the selection so that the operation covers everything. Otherwise, we will choose 'Current selection' so that the change only affects the column that we have marked. This tutorial works in the same way with numbers: if we want to organize them from highest to lowest, we will choose 'Descending order' and vice versa.


by (3.5m points)
edited

Related questions

+3 votes
1 answer
asked Dec 17, 2023 in Tutorials Tutorials by backtothefuture (551k points) | 24 views
+3 votes
1 answer
asked May 24, 2020 in Help by backtothefuture (551k points) | 229 views
+4 votes
1 answer
asked Nov 18, 2021 in Guides by backtothefuture (551k points) | 100 views
+5 votes
1 answer
asked Sep 19, 2019 in Office by backtothefuture (551k points) | 256 views
+3 votes
1 answer
Sponsored articles cost $40 per post. You can contact us via Feedback
10,632 questions
10,764 answers
510 comments
3 users