Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel need to have a sub worksheet inserted into each row
I seem to recall that you can press on a + sign in the row number and this
then opens up a sub worksheet within. What I have is a number of companies which I have been researching. For each of these I would like to put information onto a seperate worksheet which can be viewed by clicking on the + sign on the row number. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel need to have a sub worksheet inserted into each row
You seem to be hinting at the "Data Group & Outline" feature
Try select a couple of row headers, then click Data Group & Outline Group You can do likewise with columns Any worth? hit YES below -- Max Singapore --- "RT" wrote: I seem to recall that you can press on a + sign in the row number and this then opens up a sub worksheet within. What I have is a number of companies which I have been researching. For each of these I would like to put information onto a seperate worksheet which can be viewed by clicking on the + sign on the row number. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel need to have a sub worksheet inserted into each row
Not in any version of excel that I've used.
But you can use those outlining symbols to show/hide rows. And there are a couple of ways you can get those outlining symbols. You could use Data|Subtotals (xl2003 menus) or you could use Data|Group and Outline (after selecting a few rows). RT wrote: I seem to recall that you can press on a + sign in the row number and this then opens up a sub worksheet within. What I have is a number of companies which I have been researching. For each of these I would like to put information onto a seperate worksheet which can be viewed by clicking on the + sign on the row number. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get an inserted symbol to show in another worksheet? | Excel Discussion (Misc queries) | |||
Link inserted rows throughout the worksheet. | Excel Worksheet Functions | |||
Using information from one worksheet, to rename inserted worksheet | Excel Worksheet Functions | |||
How do I see a .ESP image (logo) that is inserted in a worksheet? | Excel Discussion (Misc queries) | |||
cannot open inserted objected in worksheet | Excel Discussion (Misc queries) |