Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
expanding results
I have a list of data which sums up to make the total. What I want to do is
hide the detail, but show it if someone clicks on the total. For example, I have Product 1, product 2 and product 3 listed with their sales next to them. The top row is TOTAL SALES and has their combined total. I want to be able to hide the product detail, but click on the TOTAL SALES cell to expand and then contract the data - can this be done? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
expanding results
Can you detail the data, where is the Product 1 data, Product 2 etc.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "CheekyChappie" wrote in message ... I have a list of data which sums up to make the total. What I want to do is hide the detail, but show it if someone clicks on the total. For example, I have Product 1, product 2 and product 3 listed with their sales next to them. The top row is TOTAL SALES and has their combined total. I want to be able to hide the product detail, but click on the TOTAL SALES cell to expand and then contract the data - can this be done? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
expanding results
ok, here is the detail
TOTAL PRODUCTS 500 Product A 50 Product B 150 Product C 300 So the Products are directly below the total line. I want to be able to show the TOTAL PRODUCTS line only, but if they click on that cell, it expands to show the products underneath as it is about, and again to minimise them. Hope this is clearer. "Bob Phillips" wrote: Can you detail the data, where is the Product 1 data, Product 2 etc. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "CheekyChappie" wrote in message ... I have a list of data which sums up to make the total. What I want to do is hide the detail, but show it if someone clicks on the total. For example, I have Product 1, product 2 and product 3 listed with their sales next to them. The top row is TOTAL SALES and has their combined total. I want to be able to hide the product detail, but click on the TOTAL SALES cell to expand and then contract the data - can this be done? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
expanding results
You Could use Grouping.
Highlight the Detail Rows Go to "Data" "Group & Outline" and click "Group" You wil see a + (Plus) sign appear beside the detail which can be used to toggle hide or display the view. Paul CheekyChappie wrote: ok, here is the detail TOTAL PRODUCTS 500 Product A 50 Product B 150 Product C 300 So the Products are directly below the total line. I want to be able to show the TOTAL PRODUCTS line only, but if they click on that cell, it expands to show the products underneath as it is about, and again to minimise them. Hope this is clearer. "Bob Phillips" wrote: Can you detail the data, where is the Product 1 data, Product 2 etc. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "CheekyChappie" wrote in message ... I have a list of data which sums up to make the total. What I want to do is hide the detail, but show it if someone clicks on the total. For example, I have Product 1, product 2 and product 3 listed with their sales next to them. The top row is TOTAL SALES and has their combined total. I want to be able to hide the product detail, but click on the TOTAL SALES cell to expand and then contract the data - can this be done? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
expanding results
You Could use Grouping.
Highlight the Detail Rows Go to "Data" "Group & Outline" and click "Group" You wil see a + (Plus) sign appear beside the detail which can be used to toggle hide or display the view. Paul CheekyChappie wrote: ok, here is the detail TOTAL PRODUCTS 500 Product A 50 Product B 150 Product C 300 So the Products are directly below the total line. I want to be able to show the TOTAL PRODUCTS line only, but if they click on that cell, it expands to show the products underneath as it is about, and again to minimise them. Hope this is clearer. "Bob Phillips" wrote: Can you detail the data, where is the Product 1 data, Product 2 etc. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "CheekyChappie" wrote in message ... I have a list of data which sums up to make the total. What I want to do is hide the detail, but show it if someone clicks on the total. For example, I have Product 1, product 2 and product 3 listed with their sales next to them. The top row is TOTAL SALES and has their combined total. I want to be able to hide the product detail, but click on the TOTAL SALES cell to expand and then contract the data - can this be done? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
expanding results
Try this
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Const WS_RANGE As String = "A1" '<=== change to suit If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then Me.Rows("2:4").Hidden = False Else Me.Rows("2:4").Hidden = True End If End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "CheekyChappie" wrote in message ... ok, here is the detail TOTAL PRODUCTS 500 Product A 50 Product B 150 Product C 300 So the Products are directly below the total line. I want to be able to show the TOTAL PRODUCTS line only, but if they click on that cell, it expands to show the products underneath as it is about, and again to minimise them. Hope this is clearer. "Bob Phillips" wrote: Can you detail the data, where is the Product 1 data, Product 2 etc. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "CheekyChappie" wrote in message ... I have a list of data which sums up to make the total. What I want to do is hide the detail, but show it if someone clicks on the total. For example, I have Product 1, product 2 and product 3 listed with their sales next to them. The top row is TOTAL SALES and has their combined total. I want to be able to hide the product detail, but click on the TOTAL SALES cell to expand and then contract the data - can this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup on pivot table results = #N/A | Excel Worksheet Functions | |||
Returning Numeric Results across a Single Row in Consecutive Cells | Excel Worksheet Functions | |||
abdualmohsn | Excel Discussion (Misc queries) | |||
Date stamp formula results? Tricky problem? | Excel Discussion (Misc queries) | |||
calculating results in formulas | Excel Discussion (Misc queries) |