Quizzes & Puzzles39 mins ago
Sort Excel Workbook Alphabetically
12 Answers
I have a Excel workbook consisting of 7 columns of names. I've tried sorting the names A to Z style and it seems to work in column "A" but as I sort columns "B" to "G" the columns don't stay in alphabetical order. How can I sort all 7 columns alphabetically at the same time?? My operating system is Windows 10
Thank you in advance.
Thank you in advance.
Answers
Best Answer
No best answer has yet been selected by zingo1327. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.I don't understand what you mean.
When you sort by a column (let's say column A) each row is treated as a self-contained record and all the column entries in (say) row 10 will move along with the entry in cell A10. So if Row 10 contains (from A10 to G10)Linda, Jeff, Alan, Sue, Steve, Roy and Chris as your seven entries, that row in its entirety will finish up wherever "Linda" finishes up in the sorted list. I'm not sure what you mean that columns B to G do not stay in alphabetical order. They won't (unless by chance).
When you sort by a column (let's say column A) each row is treated as a self-contained record and all the column entries in (say) row 10 will move along with the entry in cell A10. So if Row 10 contains (from A10 to G10)Linda, Jeff, Alan, Sue, Steve, Roy and Chris as your seven entries, that row in its entirety will finish up wherever "Linda" finishes up in the sorted list. I'm not sure what you mean that columns B to G do not stay in alphabetical order. They won't (unless by chance).
Sorry guys. I never described the problem properly. I'm an avid novels reader and I need to put down on paper the novels I've read so I don't buy the same ones again. I've opened an Excel book using columns "A" to "G" with each column containing the titles of 50 novels (that's 7 x 50 book titles and it's growing every week).
I'd like to sort them as one alphabetically continuous list (On as few A4 pages as possible). I realise I could sort column "A" and print it off and so on but that means looking through 7 pages of novel titles in a busy Waterstones bookshop.At the moment I get by with 2 sheets of A4 paper but as I say it is not all in alphabetical order. Hope this clears up my situation. Thanks in advance
I'd like to sort them as one alphabetically continuous list (On as few A4 pages as possible). I realise I could sort column "A" and print it off and so on but that means looking through 7 pages of novel titles in a busy Waterstones bookshop.At the moment I get by with 2 sheets of A4 paper but as I say it is not all in alphabetical order. Hope this clears up my situation. Thanks in advance
ok then you need to sort each column individually but answer no when it asks if you want to expand the selection. Another way is to put them all in 1 column sort it then cut that entire column and past into a word document that is defined as 7 columns. Bit of a faff but excel does not work well with things like you are attempting.
Do you also have Word, or any similar word processor? If you, you can do this very easily by pasting the entire list and then splitting the page into as many columns as you like.
Alternatively, you need to implement "snaking columns" in Excel. This may sound a bit daunting, but it's pretty simple.
Follow the instructions here:
Alternatively, you need to implement "snaking columns" in Excel. This may sound a bit daunting, but it's pretty simple.
Follow the instructions here:
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.