Filtering with Multiple Lines

ExcelBeginner

New Member
Joined
Sep 10, 2002
Messages
7
I have a spread sheet of formulas and each formula is multiple lines. I want to be able to filter and pick a formula heading and have all the lines associated with it shown (opposed to the one line I can see now). Is there any way to group the lines in Excel 2000 so that they will automatically show up?
Thanks!
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Watch MrExcel Video

Forum statistics

Threads
1,118,522
Messages
5,572,637
Members
412,476
Latest member
luihp329
Top