How to Group Rows Together and Sort in Excel

This quick tip may only be useful to a few of you but for those that see a use for it – it could be a real headache saver.  

Have you ever had an Excel spreadsheet where you want to be able to sort by a column but there are several rows that need to be kept together when you sort?  Maybe you have a name in Row 2 and in Row 3 and 4 is more information about the person named in Row 2?  You can’t just sort because then Row 3 and 4 will no longer be next to the main information in Row 2?  Make sense?  Did I lose you after the first sentence?  Let me show you what I’m talking about….

How to Group Rows Together and Sort in Excel:  http://screencast.com/t/NBqeU55kk

This how-to video and Microsoft informational page can be found here:  X:\IT\Professional Development\Microsoft Excel

 

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *