Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Google Sheets: Sort a Range

sort range google sheets

Google Sheets: Sort a Range

sort range google sheets

Sort SOME of the Spreadsheet

I have a spreadsheet with a roster of names. I have another list which I wanted to match up who from the 2nd list was on my roster. I temporarily pasted the 2nd list onto my spreadsheet so I could try to match up the names. The problem is if I sort the spreadsheet it will mess up that 2nd list I pasted onto the sheet. Thus using “Sort sheet” will not be a good option.

Sort sheet but I do not want to sort all of the sheet

Sort Range

Sorting a particular range instead of the entire spreadsheet can be helpful. The first step is to select the range you want to sort. Highlight the cells you DO want to sort.

Right Click

Right click and choose “Sort range.” This will not work if you’ve selected an
Sort Range

This will bring up a window that asks you which column you want to sort by. If what you highlighted includes column headers like “First Name” that you want to stay at the top, check the checkbox for “Data has header row.” Choose which column you want to sort by. If I have first name in one column and last name in the next one but want to sort by last name I will need to change the default sort of sorting by the first column in the range.
sort by which column

Heads Up

The point of this is to NOT sort the entire sheet. However, if you have information that lines up in a row, be sure to include all the columns that need to be sorted together.
Highlight all data that goes together!


(adsbygoogle = window.adsbygoogle || []).push({});

Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d