Sorting data in a table

Sorting a table means to rearrange the data in one column so that it falls in alphabetical or numerical order. Sorting makes the information in a table easier to understand. For example, finding a name in a long list is easier when the list has been sorted alphabetically. In a table of sales figures, comparing the figures is easier when they are sorted from largest to smallest or smallest to largest.

You can sort table data in ascending or descending order:

  • Sort Ascending . Arranges text in alphabetical order from A to Z, and numbers from smallest to largest.

  • Sort Descending . Arranges text from Z to A, and numbers from largest to smallest.

Sort table data

  1. Click in the column that you want to use to sort the table (don’t select the column).

  2. On the ribbon, click the Table Tools | Layout contextual tab.

  3. Click the Sort button and choose Sort Ascending or Sort Descending.

    image with no caption

Tip

By default, OneNote does not include the header row in sort operations (the header row is the topmost row in the table that identifies what is in the columns below). If your table doesn’t have a header row, click the Sort button, and in the drop-down list, clear the Header Row item before choosing a Sort command.

Tip

You can sort some of the rows within a table by selecting the rows, clicking the Sort button, and choosing Sort Selected Rows. The Sort dialog box opens. Choose a column by which to sort, the Ascending or Descending option, and then click OK.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.128.226.255