View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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