Creating manual outlines

  • Thread starter Thread starter Randy Clark
  • Start date Start date
R

Randy Clark

I've looked through help files and newsgroups and can not
seem to understand how I would create a set of manual
outlines. My data does not have subtotals so AutoOutline
is not appropriate. I would have thought the Group method
applies, but I'm not working with Pivot data either.

If someone has already tackled this problem, please post
some hints. Thanks, Randy.
 
Hi,



First select the columns or rows, you wish to group, then go to:

Data > Group and outline > Group.
 
Sorry I wasn't more clear. I'm looking for a VB programming solution to
creating these outlines. I am familiar with the menu approach.

Randy
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlines 2
Programatically Add Outline and Grouping with VBA 1
Outlining with condition? part 2 7
ClearOutLine Method 1
copy outlined data in excel 1
Outline, expand or collapse via VBA 1
percent of row in subtotal range 1
How to programmatically determine which rows are outlined using Excel VBA code 1

Back
Top