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