How can I correct the same and get it in ALPHABETICAL order without retyping them all over again.
Can you please help me ? URGENT !!
2006-09-05 21:18:36 · 7 answers · asked by shenoy 1 in Computers & Internet ➔ Programming & Design
Highlight the data, then click Data->Sort.
2006-09-05 21:22:27 · answer #1 · answered by cdg1111us 2 · 1⤊ 0⤋
there's a neat trick to doing this fairly actual... it makes use of pivot table function. in case you spotlight your documents, all of it (Ctrl-Shift-8 will try this) and then click documents > Pivot Tables... you will get a communique field pop up. carry on with in the time of the stairs... on the 0.33 field, it is going to ask in case you like a clean sheet, confident... and then click end. you could now have a clean sheet with an empty grid... and a communique field including your "Column" names in it... drag the County field into the left hand field in the grid (the place it says "Drop Row Fields right here")... and then drag an identical column field (or the different) into the needed field in the grid (the place it says "Drop documents products right here")... Now and right it is the specific section... you could have a catalogue of the Counties... with a superb selection by making use of each. Double click between the numbers and you will get the "decrease" of the unique documents, by making use of county, which you're after (Excel Magic!). you're able to try this for each county. upload an entire to the final analysis including up the column you should entire. desire that facilitates. there is yet another selection... spotlight all your documents returned and then click documents > Subtotals... carry on with the stairs, you will need the documents taken care of by making use of County for this to function... besides the fact that it is going to insert a subtotal line on your documents after each county. Pivots and subtotals are great, as quickly as you get your head around them... attempt them out, have a play.
2016-10-14 09:14:32 · answer #2 · answered by ? 4 · 0⤊ 0⤋
Highlight the data and click Data->Sort.
Then select the ascending button and click OK.
2006-09-08 05:48:18 · answer #3 · answered by Lewiy 3 · 0⤊ 0⤋
You need to select the names or whatever you need to arrage.
Then go to DATA on excel sheet and click-sort--- ascending / descending
Good luck
2006-09-05 21:47:48 · answer #4 · answered by itsme 2 · 0⤊ 0⤋
Select the column and click on the A-Z button somewhere at the top.
2006-09-05 21:37:33 · answer #5 · answered by Hardrock 6 · 0⤊ 0⤋
highligh the names
click Sort Ascending icon
2006-09-05 21:26:51 · answer #6 · answered by czaroma 2 · 0⤊ 0⤋
select the data....DATA....SORT.....den ASECNDING OR DESCENDING
2006-09-05 21:59:55 · answer #7 · answered by vivek s 1 · 0⤊ 0⤋