Filtering with Multiple Lines

E

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!
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
You must log in or register to reply here.

Similar threads

R
  • Question
Adding Multiple Vertical Lines on Horizontal Bar Chart
Replies
1
Views
178
NdNoviceHlp
NdNoviceHlp
AOB
  • Solved
Apply a dynamic include/exclude in outer FILTER formula to dynamically determine which columns to return
Replies
4
Views
38
AOB
AOB
B
  • Question
VBA code to cut and paste multiple filtered rows based on multiple criteria
Replies
2
Views
457
Alex Blakenburg
A
J
  • Solved
Is there a way to create a vlookup that brings in something only one time per order #?
Replies
2
Views
39
jloosen
J
J
  • Question
Automatically setting filters based upon user selection criteria
Replies
1
Views
141
John_w
J

Forum statistics

Threads
1,214,632
Messages
6,120,655
Members
448,975
Latest member
sweeberry

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top