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.
Make sure to subscribe to the channel!
Смотрите видео How To Sort By A Specific Column In Google Sheets онлайн без регистрации, длительностью 01 минут 32 секунд в хорошем hd качестве. Это видео добавил пользователь Quick Tech 23 Февраль 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 75 тысяч раз и оно понравилось 60 людям.