Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 08-16-2017, 08:37 PM
jmattingly85 jmattingly85 is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Jul 2017
Posts: 6
jmattingly85 is on a distinguished road
Default 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!
Attached Files
File Type: xlsx Sample.xlsx (10.3 KB, 5 views)
Reply With Quote
  #2  
Old 08-16-2017, 11:59 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,335
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

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
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #3  
Old 08-17-2017, 01:53 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 409
ArviLaanemets will become famous soon enough
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 01:32 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft