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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Keep data together 3
Sorting within Groups 3
group rows between blank rows 1
group rows 2
Grouping cells together for sorting 1
Auto filter columns while keeping groups of verticle cells togethe 1
grouping cells and sorting 1
Sorting multiple columns and maintaining grouping of information 2

Back
Top