how do you sort in excel but keep rows together? This is a topic that many people are looking for. khurak.net is a channel providing useful information about learning, life, digital marketing and online courses …. it will help you have an overview and solid multi-faceted knowledge . Today, khurak.net would like to introduce to you Excel – Sorting Rows in a Table . Following along are instructions in the video below:
“H. Excel. 2010. Sorting rows and a table begin reading from excel.
Lets you analyze analyze a separate range and finish reading this paragraph when you finished begin with this for step 1 click cell. A5. Which is right here where it says sales rep then also make sure you re under the home tab. If you re not please click on the home tab.
In the styles group click on format as a table and then it asks us to select style table lite. 9. So we want to be on the light group here s a medium group we want to be on the light group and then we count. 9.
So. 1 2. 3. 4.
5. 6. 7..
8. 9. As you notice a little pop up show. Saying.
Table style light. 9. We click on it and it selects a 5 to g13 notice. We have this format as table dialog box pop up as well this is telling us you have the following cells selected is this true you can change this here.
Now if you want to but we re not going to also notice. There is a my table has headers if we uncheck this it ll create headers above the table currently but since we already have table headers we re going to leave it checked on so we click ok. Notice now that we have a table that is openly organized and each one can be seen i m going to space these out by clicking double clicking between e and f as well so i can see the words february return sales commission and f and g. So they re all readable.
You don t have to do this this is not required. This is just something extra. I m doing all right now that it s in a table. It wants us to click on the total row check box.
So that we can see the total row to do this make sure you re in the design tab in this new and make sure the table is selected anywhere on the table can be selected if you re outside the table the tab disappears click inside notice this yellow tab. It s called table tools for the design tab opens up now what it wants us to do under the table styles option select. So we can see or show total row..
Notice this row called total appears at the bottom so if we uncheck it it hides. If we check it it shows back up so now total row is there next click cell. G4 team currently we have a number in there. What this is doing is its summing up.
The commission position your mouse over the fill handle tool in the lower right corner of the g. 14. Until it changes to the of course. The black cross and then drag it to cell c 14.
So we want to drag backwards to cell c. 14. And now it adds the sums up for january february. The returns the total sale returns and keeps the commission 1 there as well in cell.
B5. Click on the cell notice when we click on the cells in the total ranges. A little arrow to the right pops up or shows. It happens on all of the total ranges so i ll click on cell.
B5. Then it wants us to click on the arrow and then click sort a to z sorry make sure you click on b5 i was clicking on b 14 so we click on b5 under the state and click a to z notice the table slightly changes what changed. If i undo that notice right..
Now. It. Says. Ca ca ca.
Waa. Waa. For washington. Oh.
R. For orlando id. For idaho and az for arizona. If we sort it a to z.
It ll put arizona at the top followed by california idaho oregon. Washington and then it moves them around it doesn t move any of this information around in weird places. All the rows stay together aren t attached together check figure h. 18.
To make sure yours matches next click. The home tab click the sort and filter button in the editing. Group..
So we find the editing group and then it wants us to get the sort and filter button click the custom sort now we get this new dialog box. Where we can add our own custom sorting or however we d like to sort something this allows us in case. We just don t want to sort one column. We d like to sort multiple columns out like so we want to sort state.
Then we want to sort up by maybe february and then total sales so in the example. We click on custom sort now we want to click add level click add level and then click the then buy list arrow and we click then buy and select click total sales less return next click the order list arrow. This is your order and click the order list arrow for it click largest. So it s smallest right now it s set at smallest to largest.
So we want largest to smallest compare your screen with h19 and click ok now it sorts to fields you can see this by the state. Where it s got an arrow. Saying sorting by and it defines that sort next it sorts total sales less returns. And it s got proof that s doing so it s not just a single arrow.
It s got a little extra arrow in here defining that its first sorting by this then by this and then it goes through the rest sorting once you see that your figure or once you see your table matches figure h19. Save your changes that ends this tutorial continue on to the next. ” ..
Thank you for watching all the articles on the topic Excel – Sorting Rows in a Table . All shares of khurak.net are very good. We hope you are satisfied with the article. For any questions, please leave a comment below. Hopefully you guys support our website even more.
“This tutorial is found on page 184 of Microsoft Office 2010 Fundamentals”,
grossmont, college, csis, 105, microsoft, office, 2010, fundamentals, excel, Microsoft Excel (Software), Microsoft Office (Software)