ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   In Excel need to have a sub worksheet inserted into each row (https://www.excelbanter.com/excel-worksheet-functions/263080-excel-need-have-sub-worksheet-inserted-into-each-row.html)

rt

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.

Max

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.


Dave Peterson

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


All times are GMT +1. The time now is 09:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com