Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Creating manual outlines

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.


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Creating manual outlines

Hi,



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

Data Group and outline Group.




--
JP

http://www.solutionsvba.com


"Randy Clark" wrote in message
...
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.




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Creating manual outlines

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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a list with entries from cells and manual entry too Rims Excel Discussion (Misc queries) 2 August 26th 08 08:58 AM
Sub-total outlines Mark Excel Worksheet Functions 1 March 26th 08 03:54 PM
Sorting Outlines ecounts12 Excel Worksheet Functions 0 June 6th 06 04:57 PM
Excel Outlines Joyce Excel Worksheet Functions 2 September 20th 05 07:58 PM
Using Outlines in Excel Sandi Excel Discussion (Misc queries) 1 March 7th 05 06:12 PM


All times are GMT +1. The time now is 03:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"