How do I group multiple lines so that they stay together during a.

R

rgilles

I have a spreadsheet set-up in which information for one product, in some
instances, takes up five lines. I need to be able to sort the worksheet, but
I can't figure out how to keep the information grouped together during a sort
function. Is it possible to group multiple lines together and then sort
them?
 
B

Bernie Deitrick

R.,

You need to use another column with a key value that is the same for all
line that you want to have sorted together, then sort on that column. The
values in that column could be the result of a formula, or manually entered.

HTH,
Bernie
MS Excel MVP
 
Top