Highlight your Title column, and then choose DATA from the toolbar at top, and Sort. {“smallUrl”:“https://www. wikihow. com/images/thumb/f/fc/Organize-Your-Comic-Collection-with-Excel-Step-5Bullet1. jpg/v4-460px-Organize-Your-Comic-Collection-with-Excel-Step-5Bullet1. jpg”,“bigUrl”:"/images/thumb/f/fc/Organize-Your-Comic-Collection-with-Excel-Step-5Bullet1. jpg/aid153684-v4-728px-Organize-Your-Comic-Collection-with-Excel-Step-5Bullet1. jpg",“smallWidth”:460,“smallHeight”:269,“bigWidth”:728,“bigHeight”:425,“licensing”:"<div class="mw-parser-output">
License: <a target="_blank" rel="nofollow noreferrer noopener" class="external text" href="https://creativecommons.
org/licenses/by-nc-sa/3.
0/">Creative Commons</a>
\n</p>
<br />\n</p></div>"} Excel will tell you that there’s data next to the data you selected which will not be sorted, and asks What Do You Want To Do? Choose to expand the selection, then click Sort again. {“smallUrl”:“https://www. wikihow. com/images/thumb/b/b9/Organize-Your-Comic-Collection-with-Excel-Step-5Bullet2. jpg/v4-460px-Organize-Your-Comic-Collection-with-Excel-Step-5Bullet2. jpg”,“bigUrl”:"/images/thumb/b/b9/Organize-Your-Comic-Collection-with-Excel-Step-5Bullet2. jpg/aid153684-v4-728px-Organize-Your-Comic-Collection-with-Excel-Step-5Bullet2. jpg",“smallWidth”:460,“smallHeight”:213,“bigWidth”:728,“bigHeight”:337,“licensing”:"<div class="mw-parser-output">
License: <a target="_blank" rel="nofollow noreferrer noopener" class="external text" href="https://creativecommons.
org/licenses/by-nc-sa/3.
0/">Creative Commons</a>
\n</p>
<br />\n</p></div>"} It will ask you what to sort on next - there will be a window that says sort by, and has a field with a little drop-down menu that shows the names of your columns, so you’ll want to choose title as your first search criteria, then issue #, then box # from the other two drop-down menus, as shown. They should all be checked as ascending for sort order. If you created a header row in a previous step, then be sure the little check box for header row is checked, or if you did not do it, be sure it’s un-checked. {“smallUrl”:“https://www. wikihow. com/images/thumb/7/7b/Organize-Your-Comic-Collection-with-Excel-Step-5Bullet3. jpg/v4-460px-Organize-Your-Comic-Collection-with-Excel-Step-5Bullet3. jpg”,“bigUrl”:"/images/thumb/7/7b/Organize-Your-Comic-Collection-with-Excel-Step-5Bullet3. jpg/aid153684-v4-728px-Organize-Your-Comic-Collection-with-Excel-Step-5Bullet3. jpg",“smallWidth”:460,“smallHeight”:213,“bigWidth”:728,“bigHeight”:337,“licensing”:"<div class="mw-parser-output">
License: <a target="_blank" rel="nofollow noreferrer noopener" class="external text" href="https://creativecommons.
org/licenses/by-nc-sa/3.
0/">Creative Commons</a>
\n</p>
<br />\n</p></div>"} After the first time, it will always come up the same way. Now you can hit OK, and Bob’s your uncle - All your comics are now in alphabetical order on your spreadsheet, and the program tells you where you put them. It’s a very economical solution, both money-wise (because most people already have Excel) and time-wise, because who wants to start moving comics in Box #7 in order to make room in Box #2? {“smallUrl”:“https://www. wikihow. com/images/thumb/e/ed/Organize-Your-Comic-Collection-with-Excel-Step-5Bullet4. jpg/v4-460px-Organize-Your-Comic-Collection-with-Excel-Step-5Bullet4. jpg”,“bigUrl”:"/images/thumb/e/ed/Organize-Your-Comic-Collection-with-Excel-Step-5Bullet4. jpg/aid153684-v4-728px-Organize-Your-Comic-Collection-with-Excel-Step-5Bullet4. jpg",“smallWidth”:460,“smallHeight”:213,“bigWidth”:728,“bigHeight”:337,“licensing”:"<div class="mw-parser-output">
License: <a target="_blank" rel="nofollow noreferrer noopener" class="external text" href="https://creativecommons.
org/licenses/by-nc-sa/3.
0/">Creative Commons</a>
\n</p>
<br />\n</p></div>"}
