|
18 May 14 - 10:45 AM (#3626793) Subject: BS: Excell spreadsheet question From: Deckman I am creating a spreadsheet to organize the songs in my repitore. Using the Windows Excell spreadsheet format, I've made five columns: A through F. Column "A" will be the song title. I've entered about 150 titles randomly. Here's my question: How can I organize the songs in column "A" alphabetically? Thank you for your help. bob(deckman)nelson |
|
18 May 14 - 11:04 AM (#3626799) Subject: RE: BS: Excell spreadsheet question From: GUEST,CS Choose the 'Data' tab from the top bar. Then 'Sort' you should get A-Z Z-A (and a custom option) |
|
18 May 14 - 11:11 AM (#3626801) Subject: RE: BS: Excell spreadsheet question From: Jeri Highlight the parts of the spreadsheet with data in them first, or you'll only sort the column. Put another way, if there's data in the row, it won't follow what's in the column when it moves, unless it's all highlighted. |
|
18 May 14 - 11:14 AM (#3626803) Subject: RE: BS: Excell spreadsheet question From: GUEST,CS I muffed that a bit, but it's 'Data' then 'Sort', then a pop up box in which you choose which 'Column' (select 'A'), what to 'Sort on' (select 'Values') and how to 'Order' (select 'A-Z') |
|
18 May 14 - 11:15 AM (#3626804) Subject: RE: BS: Excell spreadsheet question From: GUEST,CS Yeah highlight it all too ;-P |
|
18 May 14 - 11:28 AM (#3626809) Subject: RE: BS: Excell spreadsheet question From: Deckman WOW ... MUDCAT strikes again. I had the perfect answer in 20 minutes. Thanks to both of you for helping me. This will be very useful as I know my list will be well over 1,000 in number. bob(deckman)nelson |
|
18 May 14 - 11:32 AM (#3626811) Subject: RE: BS: Excell spreadsheet question From: Musket Your list can up to 16,384 per sheet. Or 16,383 plus a list header to be correct. |
|
18 May 14 - 11:50 AM (#3626819) Subject: RE: BS: Excell spreadsheet question From: GUEST If you want to get really flash, don't bother sorting the data table at all, but use it as the foundation of a Pivot Table. Just make certain Row 1 has the column headers, highlight the entire columns by using the top line above it, and drag the fields into place - you can still drag them around later anyway. You probably want one as a count field just to kid Excel you're doing something, but the rest will tell you, for example, who sings a particular song. |
|
18 May 14 - 12:02 PM (#3626824) Subject: RE: BS: Excell spreadsheet question From: Nick It currently has 1048576 rows by 16384 columns - more likely to use the rows for songs? |
|
18 May 14 - 12:08 PM (#3626826) Subject: RE: BS: Excell spreadsheet question From: Musket My mistake. It used to have 16384 rows and I use 16 bit compatibility for OLE with an old AutoCad.... Still, lots of songs. |
|
18 May 14 - 01:34 PM (#3626850) Subject: RE: BS: Excell spreadsheet question From: mg I do not trust the sort function in excel so i always make a copy and sort from the copy. I also highlight every ten rows or so woth a color to make sure the whole row sorted correctly. |
|
18 May 14 - 01:44 PM (#3626856) Subject: RE: BS: Excell spreadsheet question From: Deckman Thanks Mary .... bob |
|
18 May 14 - 05:32 PM (#3626914) Subject: RE: BS: Excell spreadsheet question From: Mr Red if you sort and there are header rows within the selected block, make sure the "sort dialog" knows about those headers. Micro$oft thinks for itself, don't trust it blindly. I usually select columns and tick yes to header row. It is easier unless I have multiple specific areas of interest in the same columns. I would advise setting the columns to specific format - names as text, numbers as numbers, rather than leaving it "general". Another anomaly that may have been sorted by Micro$oft with a nag screen asking for guidance is: any numbers in the text will take precedence eg "123 Child" comes way above "Child 123" whereas "Child 123" goes after "Child 120" which may sound obvious but beware numbers in text. |
|
19 May 14 - 05:32 AM (#3626972) Subject: RE: BS: Excell spreadsheet question From: MartinRyan Always worth testing out the basics on a sample of your data before committing to large scale data entry/import. It's easier to see what's happening AND it can save you a lot of sticking plaster! Regards |
|
19 May 14 - 09:38 AM (#3627044) Subject: RE: BS: Excell spreadsheet question From: Sandra in Sydney I always Save my table before sorting it - & don't Save or Save As if I don't need to keep the new version. I've been using small spreadsheets for years but only learnt how to Sort a few months ago, & learnt how to Wrap Text in a column just a few days back! sandra (expert - NOT) |
|
19 May 14 - 11:03 AM (#3627086) Subject: RE: BS: Excell spreadsheet question From: Bonzo3legs if you put 123 Child in cell A1 you can reverse the order with this formula: =RIGHT(A1,LEN(A1)-SEARCH(" ",A1))&" "&LEFT(A1,SEARCH(" ",A1)-1) |
|
20 May 14 - 06:48 AM (#3627342) Subject: RE: BS: Excell spreadsheet question From: Scabby Douglas Apart from sorting data, as described by several people above, you may also want to use the Autofilter function. Assuming the first row of your table has column names.. * Click on a single cell inside your table. * From the Data menu, select "Filter" * Alongside each column you can click a down-pointing triangle button If for example one column is "Year Recorded" - you can include or exclude years as required. You can apply multiple filters on different columns. Filter by Year, and SongTitle, by example. To view all data again, select an applied filter and check "Select All" in the dropdown. To return your table to the way it was before you filtered, unclick the "Filter" option. Filtering does not move your data around in the way that sorting does, although watch out that you can also choose "Sort" in some of the Filter menu options. Cheers STeven |