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?

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?