I have seen a way to collapse a column dependent on the criteria. ie. show all, only those with values etc. It is for an order form. I want to list many products but only want to display and print those with quantities in them. Can anyone point in the right direction. Thanks.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
collapsing a list
- Thread starter icky
- Start date
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.
Similar threads
- Replies
- 2
- Views
- 194
- Replies
- 2
- Views
- 79
- Replies
- 0
- Views
- 157
- Question
- Replies
- 1
- Views
- 215
- Replies
- 0
- Views
- 201
