How to perform sorting on ms excel and its purpose

Actuary Forums › Forums › Learnings › Daily Dose › How to perform sorting on ms excel and its purpose

  • This topic is empty.
Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • January 28, 2019 at 4:47 pm #23189
    shreyanshh
    Participant

      Sorting is done for rearranging the data in a particular order in which we want.

      Step 1 – select the full data set along with the header

      Step 2- press together the keys : alt +A

      Step 3- press together the keys : alt +S

      Step 4- a dialog box will appear with options of which column you want to sort and on what criteria and order.

      Select them as per your requirements of how you want to sort the data and press Enter key.

      The data will be sorted.

      January 28, 2019 at 6:03 pm #24441
      Mayank Goyal
      Keymaster

        This looks nice.. Will try it tomorrow!

        I usually work on alt + A + T for sorting and the filter and then sort it on some basis.

        Moreover Alt >D>f>f looks good as well for any such filtering or sorting!

        Sent from my LLD-AL10 using Actuarial Info mobile app

        January 29, 2019 at 2:34 am #24442
        shreyanshh
        Participant

          Thank you.

          alt +A+T is shortest way for filtering i know.

          I will surely try your short cut of sorting too.

          Thank you for sharing it.

          Sent from my S6s using Actuarial Info mobile app

          January 31, 2019 at 8:12 pm #24443
          Mayank Goyal
          Keymaster

            Select two cells and use Ctrl+SHift+L and see wonders! 

          • Author
            Posts
          Viewing 4 posts - 1 through 4 (of 4 total)
          • You must be logged in to reply to this topic.

          Actuary Forums › Forums › Learnings › Daily Dose › How to perform sorting on ms excel and its purpose