In this quick technical video, I'll show you how to sort by a specific column in Google Sheets, while keeping your data attached correctly across rows.
Sorting is done a little differently in Sheets than what we're used to in Excel. Instead of expanding the selection like we would in Excel, which will sort all of our other columns or rows, we have to select everything and manually choose the column we want to sort by.
We'll look at an example that I have here. Columns A, B and D are in order, but we need to sort by the numbers inside column C.
First, select all the data but by clicking on the first cell and dragging to the last one.
Next, choose Data from the toolbar. Now if we hover over the sort sheet and choose AZ or ZA, you'll see that it sorts our column A. If we choose Sort Range and just choose AZ, it will do the same thing again.
Instead, hover over Sort Range, then choose Advanced Range Sort Options.
In this pop-up, choose the drop-down menu next to Sort by and choose the column you want to sort by, in this example, C. Then choose whether you want to sort AZ or ZA, and when you're ready. , tap Sort.
It will then sort by that column and keep all attached data in its place.
This can be used to sort by anything, like names, numbers, or even date ranges.
And this is how you sort by a specific column in Google Sheets.
Thank you for watching! Please like, subscribe and stay tuned for more quick how-to videos on technology.
Make sure to subscribe to the channel! http://www.youtube.com/c/quicktechvideos?sub_confirmation1
#googlesheets #sheets #sheetstutorial #quicktechvideo #howto #tutorial
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
No Comments