Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jan 2011
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Document Maps in Excel 2007 - How do you create/edit?

    Hi,

    I would like to be able to generate automatically a document map (like the document map in MS Word).
    I saw that Excel sometimes generates such a map with reports (See example attached).
    I would like to be able to generate such a map (not necessarily with reports). Can this be done? If yes, how?

    Many thanks,

    Sylvia

    Example.png

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Data, outline section, Group...

    Steve

  3. #3
    New Lounger
    Join Date
    Jan 2011
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by sdckapr View Post
    Data, outline section, Group...

    Steve
    Hi,

    Many thanks Steve. I apologize. I am not a pro at Excel. Could you kindly provide details as to how I can generat this outline? Do I need to select something to group? How does it generate the titles and subtitles and hyperlinks automatically?

  4. #4
    2 Star Lounger
    Join Date
    Dec 2007
    Posts
    179
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Do you mean this:
    ?

    1. Select some lines or columns.

    2. Click the Data tab.

    3. Locate the Outline group in the ribbon on the Data tab. Usually this is at the far right.

    4. Click the Group icon.
    ?

    This ties a range of cells together (also called "an outline"), but I can't see where it gives you a document map.

    Could you provide some details.

    Thanks,

    avraham


    Quote Originally Posted by sdckapr View Post
    Data, outline section, Group...

    Steve

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Yes that is what I was thinking of, creating the outline, like is given on the left side of the example sheet.

    I thought the question was about the outlining. If it is about the hyperlinking: The hyperlinks can be created by right clicking and selecting insert hyperlinks, ctrl-k, or using the hyperlink function.

    I don't think that Excel has a builtin way to do this (thoughI have been using XL2010 for only a few months and never used XL2007, so I may be able to learn something)...

    Steve
    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •