#1
|
|||
|
|||
Sorting Excel Spreadsheet
Hello,
I need some assistance with sorting an Excel Spreadsheet. I have a document (attached) with entries. This is added to frequently and needs to alphabetized. I thought by adding the name in Column A and merging the cells along the length of the entry, then sorting, it would do this, however it will not let me and says "To do this, all the merged cells need to be the same size" Any suggestions on how to accomplish this? Thank you! |
#2
|
||||
|
||||
The sheet provided is some kind of template which is not very useful. Perhaps add some data and expected results?
Be aware that merged cells are one of XL's worst features
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
My advice is to use separate sheet for maintaining all contacts (or whatever info you have here). There every contact will be on single row - i.e. a you have table structure there. (P.e. Sheet Contacts with table tContacts which has columns ContactGroup, Address, Phone, Supervisor...)
Now when you need for some purpouse info in format displayed in your attached file, you design a report sheet, where you read all needed info from table tContacts. You can design this sheet to display all contacts (but depending on number of contacts this report can grow huge), or you can let user to select some subset (p.e. ContactGroub) to be displayed. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Searching/Sorting Options | ShaunO | Excel | 1 | 09-20-2016 09:50 AM |
Creating a master spreadsheet for sorting information | Notsonerdy | Excel Programming | 8 | 05-31-2016 04:39 AM |
CAUTION!! Sorting a spreadsheet with hidden columns will trash your data. | psmaster@earthlink.net | Excel | 0 | 11-24-2009 11:54 AM |
Sorting columns in Excel - please advise | Jonre | Excel | 2 | 08-21-2009 02:38 AM |
How do I use an Excel form to populate and Excel spreadsheet | apostht | Excel | 0 | 05-21-2006 11:17 AM |