| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down boxes on left hand side of workbook
I have worked with workbooks before that have drop down boxes on the left
hand side that pull up extra rows when open and hide these rows when closed. The drop down boxes are to the left of the row numbers and are in a grayed out area. I am trying to create this gray area with drop down boxes. Any idea how? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
drop down boxes on left hand side of workbook
It could be the subtotal function that's found on the DATA menu, if I'm
interpreting you question correctly. -- Kevin Backmann "NickPro72" wrote: I have worked with workbooks before that have drop down boxes on the left hand side that pull up extra rows when open and hide these rows when closed. The drop down boxes are to the left of the row numbers and are in a grayed out area. I am trying to create this gray area with drop down boxes. Any idea how? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
drop down boxes on left hand side of workbook
No, Sorry I was very unclear when asking this question. I actually found
what I was looking for and all I needed to do is highlight rows then group. This produces the gray area on the left that I was talking about and has a drop down box for those rows. Thanks for the response anyway. "Kevin B" wrote: It could be the subtotal function that's found on the DATA menu, if I'm interpreting you question correctly. -- Kevin Backmann "NickPro72" wrote: I have worked with workbooks before that have drop down boxes on the left hand side that pull up extra rows when open and hide these rows when closed. The drop down boxes are to the left of the row numbers and are in a grayed out area. I am trying to create this gray area with drop down boxes. Any idea how? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002: Can Vlookup search at left hand side of the table? | Excel Discussion (Misc queries) | |||
| Losing count on bottom left hand side when filtering - HELP!!! | Excel Discussion (Misc queries) | |||
| y-axis moves from the left hand side to the right hand side | Excel Discussion (Misc queries) | |||
| y-axis moves from the left hand side to the right hand side! | Charts and Charting in Excel | |||
| How do I get my y axis on the left hand side of my chart? | Charts and Charting in Excel | |||
Linear Mode
