Microsoft Office Forums Sorting Excel Spreadsheet

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-16-2017, 08:37 PM
jmattingly85 jmattingly85 is offline Sorting Excel Spreadsheet Windows 7 64bit Sorting Excel Spreadsheet Office 2016
Novice
Sorting Excel Spreadsheet
 
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 offline Sorting Excel Spreadsheet Windows 7 64bit Sorting Excel Spreadsheet Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
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 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
__________________
Please note I am not active on this forum anymore
Reply With Quote
  #3  
Old 08-17-2017, 01:53 AM
ArviLaanemets ArviLaanemets is offline Sorting Excel Spreadsheet Windows 8 Sorting Excel Spreadsheet Office 2016
Expert
 
Join Date: May 2017
Posts: 508
ArviLaanemets has a spectacular aura aboutArviLaanemets has a spectacular aura about
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
Sorting Excel Spreadsheet 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 11:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft