Locking Groups of Rows Together

Question

Is there a way to lock together multiple rows? For example, locking together rows 4-11. This would be for the purpose of using filters. Essentially if someone were to filter but name, or number, all rows corresponding to that name or number would appear, rather than just the row that contains it.

I'm hoping there's a way to do this because otherwise I'd have to change the layout and it would look cluttered making sure the name or other info is repeated every row.

Answer 1

Hi, look here on how to group

https://support.office.com/en-us/article/Outline-group-data-in-a-worksheet-08CE98C4-0063-4D42-8AC7-8278C49E9AFF

http://www.wikihow.com/Group-and-Outline-Excel-Data

Answer 2

Excel is a great tool but only when given instructions.

You must assist by letting Excel know why rows 4-11 should be treated as a group.

Find what is common to all rows in the group and filter by that parameter.

Gord