![]() Now we need to sort the data in Sales Records.ġ. The 'Date' area is marked as 'Field 1', while the other 'Total Sales' area is 'Field 2'. For example, we have divided the text content into two fields with separators. īefore starting, I'd like to explain what 'Field' is. This option allows us to set multiple sorting conditions. If we want to sort the context by headings, how can we realize it? In this example, text contents are given below the four headings.Īs we can see, the headings are sorted by alphabetical order. Finally, click the OK button to sort the paragraphs by numbers. Then, the content will not be sorted by headings.Ħ. Since the content we chose includes headings, don't forget to check the Header Row option in the My List category. Choose Ascending on the right-hand side.ĥ. We can also set the sorting types ( 'Number', 'Date', and 'Text' ) i n this example, we choose Number. Go to Sort by, where we can choose to sort by 'paragraph', 'headings', and 'fields' i n this example, we choose P aragraphs. If we want to sort the data in ascending order, how can we realize it?ģ. If the information in your list or table consists of numbers or dates instead of text, use the "Type" menu in the Sort dialog box to change the data type to "Number" or "Date" respectively.When editing documents with WPS Writer, here are three options to sort the data.If your list of names includes some with the same last name, use the "Then by" menu in the Sort dialog box to select "Word 1" as the secondary criteria for sorting your list of names.Click "OK" to return to the Sort dialog box and instead of selecting "Paragraphs" to sort on, choose "Word 2," which represents the last name field in your list. In the Options window, click the button next to "Other" and replace the contents of the box next to "Other" with a blank space to tell Word that your text is separated into two fields, first name and last name, by the spacebar character. To sort a list of names alphabetically where you have the list typed as "first name last name," click the "Options" button in the Sort dialog box.When sorting a table, you can designate secondary criteria by choosing a second column under the "Then by" menu in the Sort dialog box.Your column headings will appear in the "Sort by" menu instead of generic column numbers, which makes it easier to choose your sort column. If your table has a column headings row, click the button next to "Header row" in the bottom left corner of the "Sort" dialog box. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |