Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I hide rows in excell 2003, and see the + sign to open?
I have a worksheet that shows on the left hand side of the screen shows
little plus and minus signs in boxes, the hide and unhide certain rows. Can someone explain how I go about setting those in a new worksheet? Thank You. |
#2
|
|||
|
|||
You can get those outlining symbols in a couple of ways.
You could subtotal the range (data|subtotal) or you could do it manually (Data|Group) S.L.Johnson wrote: I have a worksheet that shows on the left hand side of the screen shows little plus and minus signs in boxes, the hide and unhide certain rows. Can someone explain how I go about setting those in a new worksheet? Thank You. -- Dave Peterson |
#3
|
|||
|
|||
Good evening S L Johnson Sure thing. The facility you are looking for is the "Group" tool. Select the cell which you want to group and go to Data Group and Outline Group. As you are using XL 2003 you will get a dialog box to confirm whether you want to group columns or rows. Make your selection and click OK. Done! HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=380994 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|