Add to GuideAsk a Question
To Top

Alphabetizing in Excel

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

Questions

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.

Answers

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'.

Ad

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.

Ad

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...
Related Content
Categories
Computers SoftwareApril 4, 2017
More
🎃
Halloween Ideas!
Facebook
Pinterest
YouTube
Contests!
Newsletters
Ask a Question
Share a Post
Categories
Desktop Page | View Mobile

Disclaimer | Privacy Policy | Contact Us

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

Published by .

Generated 2017/10/12 14:42:54 in 1 secs. ⛅️️ ⚡️
Loading Something Awesome!