Sortable Spreadsheet – New Instructions

Last week we posted a sortable spreadsheet along with instructions on how to copy to your own account.

Today we will repost the sheet again with some new instructions.

Please NOTE that this will not work with EXCEL only Google Sheets.

  1. You need a Google Account to use this sheet correctly. Go here to set up an account if you do not have one. While an account gives you gmail and other apps it importantly gives you an account for accessing and using Google Sheets.
  2. After creating an account with Google make sure you are signed in.
  3. Go the the sortable spreadsheet which you can find here.
  4. Once you open the spreadsheet as long as you are logged into your Google account the spreadsheet will automatically be in you spreadsheet list.
  5. You will see that when you open the spreadsheet it will say ‘view only’.
  6. Make a copy of the sheet for yourself–go to File, Make a Copy then give it the name you want.
  7. You will now be able to use own copy to sort etc.

Note that there are 3 sheets to the spreadsheet–I have hidden 2 which are not needed by you unless you wish to make changes. The tab you need is labeled “Filter”.

Unless you are very well versed in Google Sheets I would suggest not modifying the other 2 pages–BUT if you are like me and just can’t help yourself you can always come back here if you ‘break’ the sheet.

10 thoughts on “Sortable Spreadsheet – New Instructions”

  1. Tim,

    You have two occurrences of GGT-E in your spreadsheet. You don’t have GGT-G in your spread sheet.

  2. Thanks for sharing the Google Sheet. Is there a reason you haven’t set this up to be “View” only with your share? This would prevent people from making changes to your sheet. People would then need to save their own copy before making changes.

    1. Thanks for the ‘goose’ on this FL_Guy. I just changed it to view only and folks will have a google account and make a copy. For some reason I was thinking I was making it easier for folks–but obviously not.

  3. Thanks for the updated spreadsheet. I have saved it to my docs.google.com/spreadsheets drive. Everything seems in order but
    my copy shows TWO tabs, Filter (as advertised) and Sheet14 which is blank. Just sharing in case others might have the same experience and have questions
    Thanks again
    Gary

    1. Gary–just click on sheet 14 and choose delete–someone else put that in–I keep deleting and folks keep not following instructions–or some folks simply are not familiar with Google sheets.

  4. Tim – Being the dinosaur I am, I’ve never used Google sheets and have hardly ever used Excel. The procedure gives me an option I believe to either save to OneDrive or to my computer….. Given I’m on satellite internet with limited bandwidth, I’ve also not found OneDrive to be of use to me and haven’t used it either…. So, if I save this to OneDrive does that mean anything in particular such as a possible ability to be dynamically updated or updateable?

    1. 2wr–No, once you make a copy it is standalone. I will do updates every few weeks with updates. In order to be dynamically updated we would all have to be using the same document and we can’t use the same document as each person is doing their own ‘sorting’.

      What I will have down the line is one which can be opened and each person will be able to do their sorts right here on this site without having the copying etc.

      1. Thanks, Tim – So I’ll just make a paper copy and continue to ignore OneDrive… Thanks… as it turns out I discover my OneDrive account is frozen anyway because it’s been untouched for 2 years….

Leave a Reply

Your email address will not be published. Required fields are marked *