Home‎ > ‎Announcements‎ > ‎

Sorting a selected range of Data in Google Sheets

posted Mar 14, 2009, 6:21 PM by Barry Jahn   [ updated Mar 15, 2009, 12:22 PM ]
Remember how we concluded that almost anything we want to do is easy --- if we can just figure it out. Well, it applies to the little challenge we couldn't solve in class.
Challenge: how does one Sort a range of data without messing up the rest of the data?
Solution:
  1. Select and COPY the range of data cells you would like to include in the data sort
  2. At the bottom of your Sheet, select Add Sheet
  3. Paste your data into the new sheet
  4. Select the column you wish to Sort, and do so
  5. Copy the newly sorted data table
  6. Return to the main Sheet and Paste right over the original data
  7. Voila!

Comments