Skip to main content
Workforce LibreTexts

19.3: Sort and Filter Group

  • Page ID
    13710
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)

    clipboard_e10565b2a9b20626c1a576de1ac75dde8.png

    The Sort & Filter group is responsible for assisting the user in organizing their data. Sort allows a table to be organized by one column. An example of the utility of the Sort commands is as follows- data is currently organized by State in the following table. In this example, let us imagine that the user would like to display the data below from largest to smallest.

    clipboard_e07e5b5f3497acd257d260318c3b90cc6.png

    Using the Sort command clipboard_eeba1f95bfcb8f8b62c0681bbf61d02e1.png, the Sort dialog box appears, and the user can choose to sort Column B Largest to Smallest.

    clipboard_e3e56626fa16764efd08d6110e8c7cc57.png

    After selecting OK, the data is now displayed accordingly. Note that each State previously associated with each value continues to move with that value. It is important to ensure that all cells that should be associated with a sort are selected to ensure one group of data does not move without the other.

    clipboard_e132f4e3c71e16d91e6440c0508ea6d6c.png

    Continuing with this data set, selecting the Filter icon clipboard_e5d4b69c15f990d4a6db376e35527eb43.png will create a small box with an arrow pointing downward in the lower right-hand corner of the screen of the first row of the dataset. Selecting the arrow in the first column and row launches a filter options window.

    clipboard_e281d774f2120ee4056ddc7ee1b6a4cce.png

    The Filter Options Window allows the user to sort the data in that column, and specify which information to include in the table. As an example, if only Minnesota was checked, only data with Minnesota in column one would be displayed. The user can visually see that other rows are being omitted because there is a gap in rows, and the filter icon (box with a downward arrow) now appears differently clipboard_ea804490797ecf6bcc2acd6b8d6ce3638.png. The user can un-apply the filter, by selecting the filter icon again clipboard_e161109ce2bcfaa3944572323402adac2.png, or select the clear icon clipboard_e35fa542f7e87b0cfdb91c1e6202b4940.png in the Sort & Filter group. Likewise, the filter can be Reapplied by selecting the Reapply icon clipboard_ed16fe933d337b8848f71bb3f89571a6e.png to add the filter back.

    clipboard_ef093e56b2de111d17f705b3d39d74e4f.png

    The Advanced icon clipboard_e8bc420ec5d2ad6078175e1b08fa0c4e2.png launches the Advanced Filter window which allows more customization of the cells that should be filtered and where the information should be displayed.

    clipboard_e9e9e4e4a61981d577038e7be3d5112dc.png


    19.3: Sort and Filter Group is shared under a CC BY license and was authored, remixed, and/or curated by Nick Heisserer.

    • Was this article helpful?