Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    Bethesda, md
    Posts
    24
    Thanks
    5
    Thanked 3 Times in 1 Post

    Excel left margin boxes 1 2 3 4

    To the left of the Excel 2013 cells is a vertical margin with 4 small numbered boxes at the top - 1 2 3 4. This is not something I have seen before. What is the function of these? Illustration attached. Thanks!
    Attached Images Attached Images

  2. #2
    Star Lounger
    Join Date
    Jan 2011
    Location
    Illinois
    Posts
    62
    Thanks
    17
    Thanked 2 Times in 2 Posts
    Those are outline levels. Either the sheet has subtotals applied, or the sheet is grouped and outlined. Clicking on each of the numbers will reveal (or hide) different levels of data.

    Clicking the (1) generally only shows grand totals, the (2) would show category-level subtotals, and so on.

    Here is some additional information on outlining.

  3. The Following User Says Thank You to 13ILGal For This Useful Post:

    anntms (2014-09-25)

  4. #3
    New Lounger
    Join Date
    Dec 2009
    Location
    Bethesda, md
    Posts
    24
    Thanks
    5
    Thanked 3 Times in 1 Post

    Cool Perfect. Thanks!

    Perfect! Thanks!

    Quote Originally Posted by 13ILGal View Post
    Those are outline levels. Either the sheet has subtotals applied, or the sheet is grouped and outlined. Clicking on each of the numbers will reveal (or hide) different levels of data.

    Clicking the (1) generally only shows grand totals, the (2) would show category-level subtotals, and so on.

    Here is some additional information on outlining.

Tags for this Thread

Posting Permissions

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