how to made new custom list for sort in excel mac

Made New Custom List For Sort In Excel Free By Whitelisting

Below are the steps on how you can create a custom sort in Microsoft Excel to sort the data in the order you want it represented.

For example, weve entered 2E, 2D, 2S, 3E, 3D, 3S, 4E, 4D, 4S as our sort order.

Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions.

Double-clicking the file on your computer will open it in Microsoft Excel.

For this example, well add two new values to a drop-down list in column A.

Its to the right of the Refers to box at the bottom of the Name Manager.

Its at the top of your sheet (the box you collapsed earlier).

Its the cell at the top of the list that contains a downward-pointing arrow button.

Its in the Data Tools group in the ribbon at the top of Excel.

Be sure to select the old values as well as the ones you just added.

Its in the Data Tools section of the ribbon bar at the top of Excel.

Amid the current public health and economic crises, when the world is shifting dramatically and we are all learning and adapting to changes in daily life, people need wikiHow more than ever.

By continuing to use our site, you agree to our cookie policy.

Made New Custom List For Sort In Excel Free By Whitelisting

Please help us continue to provide you with our trusted how-to guides and videos for free by whitelisting wikiHow on your ad blocker.

If you really cant stand to see another ad again, then please consider supporting our work with a contribution to wikiHow.

How To Made New Custom List For Sort In Excel Mac