The world of model and hobby engineering

Subscribe

The Modelling Hub Logo

The world of model and hobby engineering

Subscribe
Buy Latest Issue

Forums

Help

Register

Log in

Organising M.E. index spreadsheet

Advert
New Replies
Report Bug
Help/FAQs

Organising M.E. index spreadsheet

Home › Forums › Model Engineer. › Organising M.E. index spreadsheet

Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • 30 June 2021 at 12:34 #551953
    steamdave
    Participant
      @steamdave

      Is it possible to organise Excel into ascending or descending order across all columns?

      I particularly would like to reorganise the Model Engineer index Excel spreadsheet to show contributors in alphabetical order with their contributions. This would make it easier to search for particular articles.

      I can sort and filter Authors in alphabetical order but the remaining columns are not sorted using the Sort & Filter button.

      Dave
      The Emerald Isle

      Advert
      30 June 2021 at 12:34 #37870
      steamdave
      Participant
        @steamdave
        30 June 2021 at 12:57 #551958
        DC31k
        Participant
          @dc31k

          https://support.microsoft.com/en-us/office/sort-data-in-a-table-77b781bf-5074-41b0-897a-dc37d4515f27

          Your question starts at sub-section number 3.

          30 June 2021 at 12:57 #551959
          Bizibilder
          Participant
            @bizibilder

            Highlight the entire sheet and then use custom sort to sort on the column you require – the whole sheet will be sorted.

            30 June 2021 at 13:07 #551963
            Calum
            Participant
              @calumgalleitch87969

              Dave, if you highlight the entire table before turning on the sort/filter tool (or off and on again), it should keep all the rows in order. Let me know if you're struggling and I'll see if I can sort it out for you.

              30 June 2021 at 13:12 #551966
              Paul Lousick
              Participant
                @paullousick59116

                Make a copy and use it for sorting columns. Unlike a database (MS Access, etc) the data in the columns for each record is not linked together and easy to mix them up and ruin the file.

                Edited By Paul Lousick on 30/06/2021 13:13:18

                30 June 2021 at 16:32 #551992
                steamdave
                Participant
                  @steamdave

                  Thanks gents for your help. All sorted now.

                  Dave
                  The Emerald Isle

                  30 June 2021 at 16:58 #551995
                  John Haine
                  Participant
                    @johnhaine32865

                    You have probably seen this now, but if, having sorted, you click on the little down arrow next to the column head it gives you a list of all the contents in that column with a tick box. If you untick them all by clicking on the "select all" box then click the (say author) you want it will show you just the relevant entries.

                  • Author
                    Posts
                  Viewing 8 posts - 1 through 8 (of 8 total)
                  • Please log in to reply to this topic. Registering is free and easy using the links on the menu at the top of this page.

                  Latest Replies
                  Report Bug
                  Code of Conduct
                  Help & FAQs
                  Advert

                  Latest Replies

                  Home › Forums › Model Engineer. › Topics

                  Viewing 25 topics - 1 through 25 (of 25 total)
                  Viewing 25 topics - 1 through 25 (of 25 total)

                  View full reply list.

                  Advert

                  Latest Issues

                  Subscribe
                  Buy Latest/Back Issues

                  Newsletter Sign-up

                  Latest Replies