How To Sort By A Specific Column In Google Sheets

How To Sort By A Specific Column In Google Sheets

In this quick tech how to video, I’m going to show you how to sort by a specific column inside of Google Sheets, while keeping your data correctly attached across rows.

Sorting is done a little different inside of Sheets, compared to what we’re used to in Excel. Instead of expanding the selection like we’d do in Excel, which will sort all our other columns or rows, instead we need to select everything and manually choose the column we want to sort by.

We’ll look at an example I have here. Columns A, B, and D are in order, but we need to sort by the numbers inside of column C.

First, select all of the data but clicking on the first cell and dragging to the last.

Next, choose Data from the toolbar. Now if we hover over Sort Sheet and choose either A-Z or Z-A, you’ll see that it sorts our A column. If we choose Sort Range, and just choose A-Z, it’ll do the same thing again.

Instead, hover over Sort Range, and then choose Advanced range sorting options.

Inside of this pop-up window, choose the drop down next to Sort by, and choose the column you want to sort by, in this example, C. Next choose if you want to sort A-Z or Z-A, and when you’re ready, hit Sort.

It will then sort by that column and keep all the data across attached to where it belongs.

This can be used to sort by anything, like names, numbers, or even date ranges.

And that’s how you sort by a specific column inside of Google Sheets.

Thanks for watching! Please like and subscribe and stay tuned for more quick tech how-to videos.

#googlesheets #sheets #sheetstutorial #quicktechvideo #howto #tutorial

[QuickTechVideos]

Thanks for watching! Don't forget to give it a thumbs up if you find this video useful. Let us know if you have any questions, and subscribe to be notified of the latest Quick Tech tutorials.

[feefluffy]

Alhamdulillah, MasyaAllah, brother. Your tips are incredibly beneficial, may Allah always bless you with His kindness. Today, I gained new knowledge from your YouTube video. Sharing knowledge is indeed a form of Sadaqah Jariyah in Islam. I pray that Allah grants you good health and the strength to continue posting such valuable content. May your efforts be rewarded abundantly, and may you inspire many more through your work. JazakAllah Khair for your contributions!

[charlesurdy-barnes]

Thanks for your quick and fast explanation. Not sure how I missed that when I was browsing.

[nascknationalassociationof]

This was very helpful! I appreciate that the video was short and right to the point. Thank you!

[aidan]

Ur now legally my father congratulations

[messengerofgoodnews]

GRACIAS super swift, helpful, and accurate!

[JennTurner-asl]

Is there a way to sort based on your dropdown button selection - and not necessarily a->z?

[drgonrasa]

But what if I want to sort neither Alphabetically or Numerically? Let's say I have a bunch of ranks and I want it to be sorted by those ranks. How would I go about doing that?

[alexnguyen]

Hi, so how can I do this sort on sheets for ipad?

[stackattackwildcat]

Does the sorting automatically update as the values change? Or do we need to manually sort it every time the values change?

[aguiremedia]

Nice and quick but how can i do that buy just clicking the top column header?

[dzbntkf]

Hey! What if you want to sort by a set of specific values, like status labels (Done, In Progress, Needs Review), and you want to set which order should be followed, regardless of the first letter in the word?

[method]

Is it possible to sort column C without affecting column A B and D. Say you have 4 different lists that are not correlated and you want to view and sort them all individually.

[GretSeat]

Doesn't seem to sort formulas though.