![]() However, this can only be performed if you are doing this just after applying filtering. How to revert back to original sort (2 methods)ġ - You can simply use Undo button (or Ctrl + Z shortcut) to restore the data in to original state. See the following explanation.īefore filtering After filtering and clearing However, this method will not restore the data table to its original state/ initial sort order. This will remove all filters to sort state and get rid of sort arrows. Go to Home tab > Sort & Filter > Clear to clear the sorting/filtering. When you use filters and sorted data, an arrow will be shown on the table header as shown below. Once you add filters, it will show filter drop-down list on the headers and use the drop-down list to sort the data using the available options such as Sort A to Z, Sort A to Z etc. Which can be used to handle and retrieve data from large databases.ġ - Select data or headers > Home tab > Editing > Sort and FilterĢ - Select data or headers > Use shortcut ( Ctrl + Shift + L)ģ - Select data or headers > Data tab > Filter The sorting facility is an important and highly useful feature provided in Excel.
0 Comments
Leave a Reply. |