Sort Data In Excel 2008 Full Catalog For

I need to sort this data by 2 columns - first by column B (ie: Product column) in alphabetical order and then by column D (ie: Quantity) smallest to largest.

Then select the Data tab from the toolbar at the top of the screen.

Then click on the Sort button and select Custom Sort from the popup menu.

In this example, we want to sort next by the Quantity column (column D) in Smallest to Largest.

INDEX, MATCH, and INDEX MATCH MATCH Functions, Combining CELL, COUNTA, MID and OFFSET in a Formula.

Sort Data In Excel 2008 Full Catalog For

Enroll today Corporate Finance Institute Courses Programs Certification Programs Financial Modeling Valuation (FMVA) Certified Banking Credit Analyst (CBCA) Capital Markets Securities Analyst (CMSA) Course Bundles Machine Learning Python Course Catalog Full Catalog For Business Account Settings Log Out My Dashboard Log In Get Started Menu Courses Programs Certification Programs Financial Modeling Valuation (FMVA) Certified Banking Credit Analyst (CBCA) Capital Markets Securities Analyst (CMSA) Course Bundles Machine Learning Python Course Catalog Full Catalog For Business Account Settings Log Out Log In Get Started Alphabetize in Excel Organizing data in Excel from A to Z Home Resources Excel Resources Study Alphabetize in Excel How to Alphabetize in Excel This guide will show you how to alphabetize in Excel using the Sort and Filter functions Functions List of the most important Excel functions for financial analysts.

This cheat sheet covers 100s of functions that are critical to know as an Excel analyst to organize your data from A to Z.

Steps on How to Alphabetize in Excel Follow the steps below to sort your data from A to Z (or in reverse, from Z to A).

Its important to point out that the Sort function can also be used or organize data from the largest to smallest and smallest to largest.

We will outline the steps using two different methods: Sort and Filter.

Method 1 Sort To alphabetize in Excel using Sort, select the data, go to the Data Ribbon, click Sort, then select the column you want to alphabetize by.

Step 1 Select the data you want to alphabetize with your cursor.

You can select just one column, or multiple columns if you want to include other information.

In the screenshot below, you can see how two columns are selected.

This means Excel will match the data in the second column to the alphabetical order of data in the first column.

Step 2 Once the information is highlighted, access the Data Ribbon and select the Sort function.

Then decide if you want to alphabetize from A to Z or reverse-alphabetize from Z to A.

If you wish to undo the sorting, you can Undo the action by pressing Ctrl Z.

Method 2 Filter Now we will show you how to alphabetize in Excel using the Filter function.

This method should be used if you plan on repeating the action multiple times, as you will have a lasting option to keep resorting or unsorting the information.

Step 1 Select the data you want to be in alphabetical order, including any additional columns that you want to be included.

Step 2 After the information is selected, access the Data Ribbon and then click Filter.

This will automatically add a small drop-down arrow to the top of each column you selected.

Click on the arrow at the top of the column you want to alphabetize, then select either A to Z or Z to A.

Step 3 You can now sort any column in the table by clicking the down arrow and alphabetizing it.

Additional Resources Thank you for reading CFIs guide to how to alphabetize in Excel.

To learn more about how to become a world-class financial analyst, check out the additional CFI resources below: Dynamic Financial Analysis Dynamic Financial Analysis This guide will teach you how to perform dynamic financial analysis in Excel using advanced formulas and functions.

How To Sort Data In Excel 2008 For Mac