Tables in Word are often used to place texts exactly in rows and columns. A table can do more. With the sorting functions you get your data in the desired order. You just have to make sure that the headings are not included in the sorting. Blank lines also interfere with sorting.
Lesetipp
In our example, we will show you how to sort tables with just a few clicks. Create a sample table as follows: Download: Table
You now want to sort this table first by the departments and then within the departments by name. Make sure your cursor is within the table. Then the tab tools are displayed. Activate the Layout tab in these tools. Click the Sort icon in the Data group.
The dialog window of the same name is displayed. In this dialog box, click the Header option box at the bottom of My list. This will no longer display column 1 and so on in the upper selection fields for sorting, but the real field names from the first table row.
Select the department name for sorting in the first field. In the second selection field, select the Name entry. Both columns should be sorted in ascending order. Clicking the OK button sorts the table contents according to your selection.
If your spreadsheet is more extensive, the sorting functions in Word 2013 can be extended to three table fields (see figure above). As a data type (type of cell content) for sorting, you can choose text, number or date.
No comments:
Post a Comment