drop down boxes on left hand side of workbook

N

NickPro72

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?
 
K

Kevin B

It could be the subtotal function that's found on the DATA menu, if I'm
interpreting you question correctly.
 
N

NickPro72

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

get rid of drop down boxes in excel 2007 6
Oversensitive touchpad on modern laptops 0
Drop down list 1
hide drop down list 1
Protecting sheets with drop down boxes 6
Help With Linking Drop Down Boxes 7
Drop Down--How do I copy and update cell link/input range 1
Conditional Drop Down Boxes 1

Top