Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to collapse rows in Excel,leaving a plus sign to open/close
I know how to hide / show the rows, but how do it so as to leave a little
plus sign in the corner that allows me to control the number of rows to expand / contract (and I know you can do it - I've seen it on other spreadsheets!) |
#2
|
|||
|
|||
Answer: How to collapse rows in Excel,leaving a plus sign to open/close
Yes, you can definitely collapse rows in Excel and leave a plus sign to open/close them. Here's how you can do it:
That's it! You can now collapse and expand your grouped rows using the plus and minus signs. This is a great way to organize your data and make it easier to navigate.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to collapse rows in Excel,leaving a plus sign to open/close
Maybe you saw Data|subtotals in action--or Data|Group and Outline???
Both of these will show the outlining symbols to the left of the worksheet. Exasperated and Requiring Assistance wrote: I know how to hide / show the rows, but how do it so as to leave a little plus sign in the corner that allows me to control the number of rows to expand / contract (and I know you can do it - I've seen it on other spreadsheets!) -- Dave Peterson |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to collapse rows in Excel,leaving a plus sign to open/clos
Thanks mate - u r a deadset legend My display name is now no longer "Exasperated and Requiring Assistance" but, "Cool, Calm and Collected" Much obliged ;) "Dave Peterson" wrote: Maybe you saw Data|subtotals in action--or Data|Group and Outline??? Both of these will show the outlining symbols to the left of the worksheet. Exasperated and Requiring Assistance wrote: I know how to hide / show the rows, but how do it so as to leave a little plus sign in the corner that allows me to control the number of rows to expand / contract (and I know you can do it - I've seen it on other spreadsheets!) -- Dave Peterson |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to collapse rows in Excel,leaving a plus sign to open/close
I don't know what you want
On Wednesday, April 11, 2007 9:04 PM Exasperated and Requiring Assistanc wrote: I know how to hide / show the rows, but how do it so as to leave a little plus sign in the corner that allows me to control the number of rows to expand / contract (and I know you can do it - I've seen it on other spreadsheets!) On Wednesday, April 11, 2007 9:40 PM Dave Peterson wrote: Maybe you saw Data|subtotals in action--or Data|Group and Outline??? Both of these will show the outlining symbols to the left of the worksheet. Exasperated and Requiring Assistance wrote: -- Dave Peterson On Wednesday, April 11, 2007 10:14 PM ExasperatedandRequiringAssistanc wrote: Thanks mate - u r a deadset legend My display name is now no longer "Exasperated and Requiring Assistance" but, "Cool, Calm and Collected" Much obliged ;) "Dave Peterson" wrote: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel should allow all open worksheets to close at once | Excel Discussion (Misc queries) | |||
Expand/Collapse Rows | Excel Worksheet Functions | |||
How do I open or close grouped columns/rows in a protected excel s | Excel Discussion (Misc queries) | |||
Collapse rows with duplicates | Excel Worksheet Functions | |||
How do I hide rows in excell 2003, and see the + sign to open? | Excel Worksheet Functions |