How to Sort Sheets in an MS Excel Workbook

Next Video:
How Do I Check the Spelling of the File Name & Verify That the File Location Is Correct in Excel?....5

Sorting sheets in an MS Excel workbook is something that you can do to make certain types of data easier to find. Sort sheets in an MS Excel workbook with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.

Part of the Video Series: Using Excel
Promoted By Zergnet


Video Transcript

Hi, I'm Ted. Today, I'm going to show you how to sort sheets in an Excel workbook. This is something that you often want to do when you have multiple sheets in a workbook, and maybe you want to move them, rearrange them on the bottom of your workbook relative to each other, or more interestingly, if you want to move sheets from one workbook to another, or various places within the workbook. So I have a completely blank workbook open on my screen here, and I've got seven different tabs at the bottom representing the seven different sheets, and obviously the easiest thing to do, let's say we wanted to move them around, you could just take the tabs, oops, careful not to click it so you're editing the name, but we can just drag them back and forth. Maybe you want to make them alphabetical, or for whatever reason you want to rearrange them. That's not very interesting, you probably knew that already, but let me just show you something else you can do. If we want to move them. Let's say we had a whole bunch of them, and it was very hard to manipulate them where I was showing, just showing you with the tabs at the bottom. Go to edit, and go to move or copy sheet. Oops, I missed it there. Go to move or copy sheet, and there we see the sheets, all seven of them listed, and let's say we, the one we have currently open right now is sneezy here, and we want to move sneezy before goofy here. So that's the one that selected, actually let's make a, let's move it before dopey, we'll say okay, and sure enough they're moved down there at the bottom. So I hope this has been helpful. I'm Ted, and today I showed you how to sort sheets in an Excel workbook. Thank you for watching.


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!