Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 193
Default organize cells alphabetically

I don't remember how to imput a name and organize them alphabetically??? Can
anyone help me please
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,805
Default organize cells alphabetically

Type the names in a column in any order
Select the Column and choose Data|Sort and pick your options

"Confused" wrote:

I don't remember how to imput a name and organize them alphabetically??? Can
anyone help me please

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,344
Default organize cells alphabetically

Hi,

General rules for setting up data for sorting:
1. A single row of titles - First Name for example.
2. Format the titles differently from the data below - bold the title First
Name
3. Keep the data separated from other stuff in the sheet by at least a blank
row and column. Don't put something directly adjacent to the data that you
don't want to sort.
4. No completely blank rows or columns within the data to be sorted.


After enteing the names in a column select them and click the Sort Ascending
toolbar button. This may not work if your data is not set up properly.

If you have first and last names keep them in separate columns. If last
name is in column A and first name is in column B and you want to sort by
last name/first name, like the phone book. Select the two columns of names
and choose Data, Sort, and pick the Last name column from the Sort by drop
down and choose Ascending, then pick the First name column from the Then by
drop down and choose Ascending. Click OK.



--
Thanks,
Shane Devenshire


"Confused" wrote:

I don't remember how to imput a name and organize them alphabetically??? Can
anyone help me please

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Possible to organize all this?? That70sHeidi Charts and Charting in Excel 8 August 23rd 07 02:04 PM
how do I organize events yuki Excel Discussion (Misc queries) 3 January 8th 07 01:58 PM
how do i identically size cells to organize contents alphabeticall entertainer New Users to Excel 2 December 21st 06 04:12 AM
Formula to rank cells alphabetically Dave Shaw Excel Worksheet Functions 2 August 10th 06 02:07 PM
How to organize Data? Dave Peterson Excel Discussion (Misc queries) 1 March 21st 06 06:41 PM


All times are GMT +1. The time now is 03:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"