How to arrange alphabetical order in Google Sheets
When working with data sheets on Excel or Google Sheets, the word order rearrangement in alphabetical order will often be required. Especially when you work with the data table that contains the Name column, it is necessary to rearrange the name according to the alphabet.
Google Sheets also has the ability to rearrange words in alphabetical order. This makes the data sheet more intuitive, scientific and easier to see. The following article of Network Administrator will guide you how to rearrange words in alphabetical order on Google Sheets.
For example, I will proceed to rearrange the words in the Product column in alphabetical order.
Step 1:
First you need to black out the column to reorder the words. If you just need to rearrange a column, just black out the column. In the case that the column is related to other columns, we need to highlight those columns, to ensure the correct value for each line.
Step 2:
Next, select the Data item and select Sort range . We can also choose Sort sheet by column or Sort range by column. However, Sort range will have some other customizations for the data table.
Step 3:
Show small table Sort range form . Here if the data table has a header at the top, click Data has header row. Next in Sort by selecting the data column you want to reorder words, or you can leave it as confirmed by Google Sheets.
Next, select the word order A> Z or order Z> A. Here, alphabetically, we will select A> Z. Finally click the Sort button .
So the above data sheet has been rearranged in the alphabetical order in the Product column. The data that follows each value line in the Product will also be preserved.
So we rearranged the words in the Google Sheets data sheet by alphabetical list. Depending on the content of the table that the user delineates the data to be sorted, to avoid the case of upsetting data to follow each row when conducting the reordering.
I wish you all success!
You should read it
- How to align spreadsheets before printing on Google Sheets
- How to create graphs, charts in Google Sheets
- How to set up the right to edit spreadsheets on Google Sheets
- How to insert checkboxes on Google Sheets
- How to enter 0 in Google Sheets
- How to create a phone number can be called on Google Sheets
- How to view editing history on Google Sheets
- 6 useful functions in Google Sheets you may not know yet
May be interested
- Tutorial for Word 2016 (Part 18): How to add Shape shapeswhen working in word, you can insert multiple shapes such as arrows, captions, squares, stars, etc. adding shapes (shapes) into word is not new but with instructions we provide below, you will get more beautiful and interesting documents.
- Guide to Word Word 2016 (Part 19): Inserting Text Boxthe text box text box in microsoft word is a feature that makes it easier for users to present text. besides, in word 2016, microsoft has added many new effects to help users use text box more flexibly. let us find out about the text box options in this article!
- How to use Microsoft account, OneDrive on Word 2013below is a guide to using microsoft and onedrive accounts on word 2013. please consult with us!
- Basic tasks in Word 2013word 2013 is a word processing application that allows you to create a variety of documents including letters, flyers, reports and many other document documents.
- Create a new Word file, open the file in Word 2013word files are called documents. whenever you start a new project in word, you will need to create a new document, which can be a new document or a sample text .
- Word 2013 Complete Guide (Part 3): How to store and share documentswhen creating a new document in word, you'll need to know how to save the document to be accessible and edited later. as with previous versions of word, you can easily save files on your computer