How to sort data in Excel
How to sort data in Excel
Have you ever wanted to sort the data in anExcel table? In this tutorial, we’ll show you how! In this video, we’ll cover 2 easy to follow examples and take you step-by-step through the options in Microsoft Excel.
#excel #exceltutorial #sort
00:00 - Overview
00:08 - Sort by 1 Column
01:28 - Sort by 2 Columns
Excel Tutorials:
https://www.techonthenet.com/excel/in…
Don’t forget to subscribe to our channel for more great Excel tutorials!
Visit us at: https://www.techonthenet.com
or follow us on:
Facebook: https://www.facebook.com/techonthenetcom
Twitter: https://twitter.com/tech_on_the_net
Pinterest: https://www.pinterest.com/techonthene…
Content
0.599 -> have you ever wanted to sort the data in
2.94 -> an Excel table
4.38 -> today we will cover two examples so
7.02 -> let's get started
8.46 -> in our first example we'll show you how
10.74 -> to sort data in a table based on one
13.139 -> column
14.219 -> here we have a table of data that
16.199 -> contains order information
18.42 -> we want to sort the data by column B
20.58 -> which is the product column start by
23.58 -> highlighting the data that you wish to
25.38 -> sort in this example we will highlight
28.14 -> cells A1 to D6
31.439 -> next select the data tab from the
34.14 -> toolbar at the top of the screen and
36.48 -> click on the sort button in the sort and
38.579 -> filter group
40.079 -> when the sort window appears select the
42.48 -> column to sort by
44.82 -> in this example we want to sort by the
47.52 -> product column in alphabetical order so
50.399 -> we'll select product from the sort by
52.5 -> drop down
53.7 -> and under the order drop-down we will
56.16 -> Select A to Z since we want to sort our
58.739 -> product column in alphabetical order
61.62 -> when you are done selecting your sorting
63.84 -> options click on the OK button
67.02 -> now when you return to your spreadsheet
69 -> the data in your table will be sorted by
71.28 -> column B which is the product column
74.28 -> in Row 2 we see the order information
76.56 -> for apples in Row 3 the order
79.38 -> information for bananas and so on
82.979 -> now let's move to a more complicated
84.96 -> example where we want to sort by two
87.36 -> columns
89.939 -> let's move to sheet 2 where we again
92.34 -> have a table of data containing order
94.38 -> information
95.82 -> this time we have some orders with
97.74 -> duplicate products such as apples and
99.96 -> bananas
102.299 -> in this second example we want to First
104.46 -> sort by column B which is product and
107.1 -> then apply a second sort by quantity
109.079 -> which is column d
111.84 -> again highlight the data that you wish
113.759 -> to sort
114.96 -> in this example we will highlight cells
117.6 -> A1 to d8
120 -> next select the data tab from the
121.979 -> toolbar and click on the sort button in
124.439 -> the sort and filter group
126.899 -> when the sort window appears select the
129.959 -> first column that you wish to sort by
132.9 -> in this example we want to sort by the
135.3 -> product column in alphabetical order so
137.76 -> we will select product from the sort by
139.739 -> drop down
141.3 -> and under the order drop down we will
143.76 -> Select A to Z since we want to sort our
146.52 -> product column in alphabetical order
150.06 -> then click on the add level button
152.819 -> enter the second column that you wish to
155.28 -> sort by In This example we want to sort
158.459 -> next by quantity and since this is a
161.819 -> numerical column we will choose smallest
164.34 -> to largest in the order column
167.22 -> when you are done selecting your sorting
169.5 -> options click on the OK button
172.62 -> now when you return to the spreadsheet
174.599 -> the data in your table will be sorted
176.64 -> first by product in alphabetical order
179.28 -> and then by quantity from smallest to
181.98 -> largest
184.379 -> this covers our example of how to use
186.54 -> sorting in an Excel table
188.819 -> if you would like to see more examples
190.68 -> or would like to download the sample
192.659 -> data we use for this tutorial please
194.819 -> visit our website at techonthenet.com
198.72 -> if your founder tutorial helpful please
201.48 -> leave a like on this video and don't
203.459 -> forget to subscribe to our YouTube
204.84 -> channel for more great Excel tutorials
Source: https://www.youtube.com/watch?v=2L5DMoarEsM