social

Alphabetizing in Excel?

July 14, 2014

A man working on a laptop computer.How do I alphabetize files in Excel?

By Helena G.

Advertisement

Answers


Silver Feedback Medal for All Time! 282 Feedbacks
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.

Advertisement

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.

 
Answer this Question
Categories
Computers SoftwareApril 4, 2017
Pages
More
🍀
St. Patrick's Ideas!
🎂
Birthday Ideas!
💘
Valentine's Ideas!
Facebook
Pinterest
YouTube
Instagram
Categories
Better LivingBudget & FinanceBusiness and LegalComputersConsumer AdviceCoronavirusCraftsEducationEntertainmentFood and RecipesHealth & BeautyHolidays and PartiesHome and GardenMake Your OwnOrganizingParentingPetsPhotosTravel and RecreationWeddings
Published by ThriftyFun.
Desktop Page | View Mobile
Disclaimer | Privacy Policy | Contact Us
Generated 2024-01-16 18:04:43 in 10 secs. ⛅️️
© 1997-2024 by Cumuli, Inc. All Rights Reserved.
https://www.thriftyfun.com/Alphabetizing-in-Excel-1.html