How do you alphabetize items on a list when you are working on an XCEL spreadsheet? Can you add symbols too?
341996
For the alphabetizing, use "filters".\n\n1) Add a row to the top of your spreadsheet (it will be row one)\n2) Label each column (i.e. Title, Author, Publisher)\n3) Select that top row.\n4) Go to the Bar menu and select "Data", then "Filter", then "AutoFilter".\nWhat this will do is add a pull down select box for each column.\n5) The pull down select box will allow you to alphabetize each item in the column.  You could do all sorts of data sorting.\n\nAs for symbols, I may be doing it the hard way, but I copy/paste from word into the cells.\n\nGood luck. :)
626042
The best way to do this is to first save the Works spreadsheet to a .csv file.  Saving the file in this format will keep all the data and allow Dreamweaver to import it, where it should keep the columns and rows aligned.\n\nAfter you've saved the file in csv format, open Dreamweaver and go to File > Import > Import Tabular Data.  When the options box appears, browse for the csv file, and then change the delimiter to comma.  Then hit Ok.
1005206
the same way you do it with excel...
18305
They are in alphabetical order.\n\nE,f,f,o,s,s,t,t,z
708608
Here's a macro for what you want (you can replace the periods with spaces, I only put them there for appearance)\n\nSub Swap2Cells() \nIf Selection.Count <> 2 Then \n.....MsgBox "Select 2 cells only." \n.....Exit Sub \nEnd If \nSet trange = Selection \nIf trange.Areas.Count = 2 Then \n.....temp = trange.Areas(2) \n.....trange.Areas(2) = trange.Areas(1) \n.....trange.Areas(1) = temp \nElse \n.....temp = trange(1) \n.....trange(1) = trange(2) \n.....trange(2) = temp \nEnd If \nEnd Sub
235678
you can do that by sorting the data source from where you are populating the list. Or while you are populating the list.\nIf you can tell me how you are populating, I can give you more pointers. I am not sure if there is any way to sort a list directly in java script.\n\njainnys\nMind Experts Inc.\nhttp://www.mindexp.com
131541
ls -l | more\n\n( '|' is called pipe, to get this use 'shift' and '&#92;' keys)\n\nyou should use space bar to go to the next page of list
95183
thats not a big issue.....u can rearrange the letters to numbers...for example if the problems lists the coordinates as a,b,c,d etc....mark a=1, b=2, c=3 atc....\nhope this helps
744311
The numbers are listed in alphabetic order if they were spelled out\n\neight\nfive\nfour etc.
889418
1. Select the list or table you want to sort. \n2. On the Table menu, click Sort. \n3. Select the sort options you want.\n4. Click OK.
347042
I just looked up the Add On.  It looks very good.  I know what might be your problem.\n\n(1)  Click on the cell to edit the formula.  \n(2)  Press Ctrl-Shift-Enter\n\nStep 2 will insert the {} which you need for an array function.  If this does not help not sure what the problem is without seeing the entire formula.
596850
Do these words have only numbers? or do they have extra letters?\nIf the numbers you need to convert are in the beggining of the cell, use the Value function\n=value(A1)\nassuming that the cell you want to convert is in A1\n\notherwise\nsend me you e-mail address , and I will be happy to help\n\nI am the XLMan
1077784
The A to Z button answers are correct, but you typically do not need to select your range to sort. Excel will expand to all the contiguous columns and rows. \n\nThen only time you need to select your range to sort is if either an entire or row or column is empty in the middle of your range.\n\nObviously if you are sorting only one column in the middle of other data and do not want the other columns to sort along with it you need to just select the data in that column. The sort button will ask you if you want to expand the selection.
1107100
Select the cells that you want this special formatting applied to, then select the 'Conditional Formatting' option from the 'Format' menu at the top of your screen.\nIn the 'Conditional Formatting' wizard, select 'Cell Value Is', then select 'Equal to', and in the third box type the letter 'x' (or whatever value you want).  Then click the 'Format' button and choose the formatting effects you want applied when your chosen value is entered.  Then just click 'OK' until done.  Best of luck!
613256
I didn't get you well,\nExcel already can open csv files (Comma separated values) if ther were seperated with commas.\nWhy you need to convert it to columns?\nany way...\n\nsend me more info.\n\n\nXLMan
311771
Right click in any menu toolbar, it will show you the common toolbars... select the bottom option "Customize"... In the toolbars TAB look for and select "Worksheet Menu Bar" this is the one that contein file, edit, view, insert, format ....etc\n\nYou're done!\n\nPlease vote!
957828
Just open it with Excel.  It will automatically populate the columns.\n-MM