Microsoft Office Forums

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, 11 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,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
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
__________________
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
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: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:17 AM.


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