Note that each one has its own window and ribbon: Versions of Excel before the 2013 release used Multiple Document Interface (MDI), where all workbook windows were contained within a top-level “master” container window. In computing terminology, this is called Single Document Interface (SDI). This functionality can improve multitasking, visibility, and analysis across workbooks. That means that each workbook has its own ribbon and top-level window frame that you can move and resize independent from your other open workbooks. Good news: starting with Excel 2013, each of your workbooks opens in its own window, similar to Word and PowerPoint today. “How do I open my workbooks in separate windows?” This has been a common inquiry from many of our customers who want to look at their workbooks side by side, or spread them across more than one monitor. This post is brought to you by Chad Rothschiller, a Program Manager in the Excel Team.
We’re not just experts in Excel, there is content, free resources, and training courses available for Word, Outlook and more.This week we continue exploring new features in Excel 2013. Use Learn Excel Now to help with all your Excel questions and training needs. Now go out there and get your data sorted! After selecting your first sorting conditions, you can add a level to get event more accurate data:Īs you can see, Excel offers a variety of sorting and filtering tools to help you refine your data and keep it organized. What if you wanted to sort by date and by price? This where the Custom Sort option really comes in handy. In the following GIF, we can see how the Custom Sorting tool can be used to sort date ranges or price ranges.īut notice how this example is either/or. In addition to the right-click menu sorting option and the Filter tool on the Data ribbon, Excel has a Sort & Filter tool that allows for custom sorting. Select Dylan Rogers from the Salesperson dropdown menuīoom – you now have the exact number of sales Dylan Rogers made to Eastern Company.Select Eastern Company from the dropdown menu.Specifically, you want to find the number of sales Dylan Rogers made to Eastern Company. Using the above example, let’s say you wanted to filter your table by Company and Salesperson. The filter feature applies a drop down menu to each column heading, allowing you to select specific choices to narrow a table. This will ensure the data in that row carries over with sorted column data. Note: when the data in one column is related to the data in the remaining columns of the table, you want to select Expand the selection. The whole table has now adjusted for the sorted column. Go down to the Sort option – when hovering over Sort the sub-menu will appear.You can either highlight the whole column or even click on the first cell in the column to get started. Let’s say you had the spreadsheet above and wanted to sort by price. Let’s get started on running some sorting and filtering techniques. In the following example, we will explore the usage of sorting and filtering and show some advanced sorting techniques.įor today’s example, we will use the following spreadsheet:Īs you can see, the order dates, order numbers, prices, etc.
The sorting tool allows you to sort by date, number, alphabetic order and more. The filter tool gives you the ability to filter a column of data within a table to isolate the key components you need. There are many built-in Excel tools to help with data management and the sorting and filtering features are among the best.