If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to sort rows with only two columns?
Using excel I have set up a file that has all my dvd's. This file has four
columns: genre/title/year/minutes. I have no problem adding newly purchased dvd's to the list and sorting by title. I always add the new ones to the end of the list. The problem I have is with my book collection which only has two columns: genre and title. For some reason, it will not sort by title. The name of this file is MY BOOK COLLECTION, which is row 1. It is merged and centered with columns 1 & 2. After I click on SORT the window has MY BOOK COLLECTION in it and I cannot get it to sort by TITLE. However if I delete row 1 completely, it will sort by TITLE. I do not have this problem if I have more than 2 columns. What is the solution? |
#2
|
|||
|
|||
how to sort rows with only two columns?
Merged cells can cause all sorts of downstream disruptions & problems.
Refrain from using. Unmerge all merged cells if any. If you need to "merge" col headers for neater appearance's sake, use the alignment tab in FormatCells to "Centre across Selection" - scroll down in the droplist for "Horizontal" under Text alignment - its the penultimate selection. In that way, you'd get the best of it for appearances sake while keeping underlying cells unmerged. -- Max Singapore http://savefile.com/projects/236895 Downloads:23,000 Files:370 Subscribers:66 xdemechanik --- "rapsgumbo" wrote: Using excel I have set up a file that has all my dvd's. This file has four columns: genre/title/year/minutes. I have no problem adding newly purchased dvd's to the list and sorting by title. I always add the new ones to the end of the list. The problem I have is with my book collection which only has two columns: genre and title. For some reason, it will not sort by title. The name of this file is MY BOOK COLLECTION, which is row 1. It is merged and centered with columns 1 & 2. After I click on SORT the window has MY BOOK COLLECTION in it and I cannot get it to sort by TITLE. However if I delete row 1 completely, it will sort by TITLE. I do not have this problem if I have more than 2 columns. What is the solution? |
Thread Tools | |
Display Modes | |
|
|