| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort by color: Is there an easy way to sort columns or rows in EX | Excel Worksheet Functions | |||
| How do I sort rows keeping columns together? | Excel Worksheet Functions | |||
| Changing Columns and Rows around to sort | Excel Discussion (Misc queries) | |||
| How to sort data from rows into columns? | Excel Discussion (Misc queries) | |||
| Sort on rows (not columns) | Excel Discussion (Misc queries) | |||
Threaded Mode
