Add to PageAsk a Question

Alphabetizing in Excel

Category Software
Excel software includes a sort tool that can help you organize your files alphabetically. This is a page about alphabetizing in Excel.


Ask a QuestionHere are the questions asked by community members. Read on to see the answers provided by the ThriftyFun community or ask a new question.

July 14, 20140 found this helpful

How do I alphabetize files in Excel?

By Helena G.


July 16, 20140 found this helpful
Best Answer

While it may depend on your version of Excel, most versions have a 'sort' feature on the tool bar at the top of the workbook - you're looking for the icon and words that say 'Sort A-Z' and 'Sort Z-A'.

Once you've located that bit, decide which direction you want to use making a note of where you need to click to accomplish your task - don't click there yet!

The next thing is to highlight the column you need alphabetized, THEN click the sort icon. Your column will then be sorted.

It's a little tricky, though because often you want all of the data spread across several columns to sort with the one you've highlighted, but if you highlight all the data you want sorted, each column will sort according to the first letter in each column - meaning your data will not correspond to the original column you wanted sorted.

A nice and easy get-around is to write your first column as the one you need sorted - before adding other data across adjoining columns. For example, let's say I want to organise my bead inventory by colour. Column A would be entered first, going down the list of colours as I pull them out of the storage box - red (click to next cell below), blue (click to next cell below), green, etc.


Then I'd highlight the column, sort it alphabetically, and then enter the rest of the data (type, quantity, etc) in the corresponding adjoining columns across.

This also works for numbers.

Hope this helps. You can also access limited free training at MicroSoft's website pages on Excel.

Reply Was this helpful? Yes
Answer this Question...
Computers SoftwareApril 4, 2017
Pest Control
Back to School Ideas!
Ask a Question
Share a Post
Better LivingBudget & FinanceBusiness and LegalComputersConsumer AdviceCraftsEducationEntertainmentFood and RecipesHealth & BeautyHolidays and PartiesHome and GardenMake Your OwnOrganizingParentingPetsPhotosTravel and RecreationWeddings
Published by ThriftyFun.

Desktop Page | View Mobile

Disclaimer | Privacy Policy | Contact Us

© 1997-2019 by Cumuli, Inc. All Rights Reserved.

Generated 2019/08/19 19:28:40 in 817 msecs. ⛅️️ ⚡️
Loading Something Awesome!