+3 votes
245 views
Sort by date or alphabetically Google Sheets

in Internet by (552k points)
reopened | 245 views

1 Answer

+4 votes
Best answer

1. How to sort data in Google Sheets alphabetically
2. How to sort data in Google Sheets by date

One of the main functions for which most of us use computers is to carry out, manage and send documents of all kinds. For this we have different platforms at our service, either online or programs that we download on our computers. We can work with document editing platforms, data management, presentations, etc..

 

 

Google Sheets is the Google platform through which we can work with data from all kinds of functions such as:

  • Editing and working with the data
  • Offline editing
  • Google Sheets supports formats such as .xlsx, .xls, .xlsm, .xlt, .xltx, .xltxm, .ods.csv, .tsv
  • Integration with other Google applications

 

All this makes the work in Google Sheets integral, when we handle data we may want to apply some order parameters such as by date or alphabetical order, this will help to better control the data entered there.

 

TechnoWikis will clearly explain how to sort the data in Google Sheets either by date or by alphabetical order..

 

 

To stay up to date, remember to subscribe to our YouTube channel!   SUBSCRIBE

 

 

 


1. How to sort data in Google Sheets alphabetically

 

Step 1

We select the data range and go to the "data" menu and there we select "Sort range":

 

image

 

Step 2

The following window will be displayed:

 

image

 

Step 3

There we are going to activate the box "The data includes a header row" in order to work with the column titles:

 

image

 

Step 4

We can display the "Sort by" field and choose in which column the order will be applied, additionally we click on "Add another sort column" so that the filter is in different columns if necessary:

 

image

 

Step 5

On the right side we can define if the order is ascending (AZ) or descending (ZA):

 

image

 

Step 6

Once we define these criteria, we click on "Sort" and the data in the selected columns will be ordered in the alphabetical order that we have defined:

 

image

 


2. How to sort data in Google Sheets by date

 

Step 1

For the order by date we are going to select the column where the dates are and we go to the "Data" menu and there we select "Data validation":

 

image

 

Step 2

In the displayed window we do the following:
  • In the "Cell Interval" field we enter the cell, in this case B2, from where the first date is.
  • In the "Criteria" field we select "Date" and leave the default value "it is a valid date"

 

image

 

We click on "Save" to complete the process.

 

Step 3

Now we select the entire range of cells and go to the "Data" menu and choose "Sort range":

 

image

 

Step 4

We activate the box "The data includes a header row" and in the "Sort by" field we choose "Date":

 

image

 

Step 5

We activate the box if we need the ascending or descending order and click on "Order" to complete the process. In this case it has been descending.

 

image

 

In these two ways it is possible to sort the data in Google Sheets using either the dates or the alphabetical order, we must bear in mind which columns have to be selected for the filter in order to avoid clutter of the information presented if it is large amounts of data to work in Google spreadsheets..

 


by (3.5m points)

Related questions

+4 votes
1 answer
asked Apr 1, 2020 in Windows 10 by backtothefuture (552k points) | 255 views
+4 votes
1 answer
asked May 8, 2021 in Internet by backtothefuture (552k points) | 153 views
+4 votes
1 answer
asked Oct 3, 2023 in Guides by backtothefuture (552k points) | 48 views
+3 votes
1 answer
asked Nov 18, 2021 in Office by backtothefuture (552k points) | 91 views
+4 votes
1 answer
asked Jun 23, 2019 in Office by backtothefuture (552k points) | 432 views
Sponsored articles cost $40 per post. You can contact us via Feedback

Most popular questions within the last 30 days

10,659 questions
10,791 answers
510 comments
3 users