• Excel left margin boxes 1 2 3 4

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Excel left margin boxes 1 2 3 4

    Author
    Topic
    WSanntms
    AskWoody Lounger
    September 24, 2014 at 4:41 pm #496592

    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!

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WS13ILGal
      AskWoody Lounger
      September 24, 2014 at 9:59 pm #1468683

      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.

      Reply | Quote
      • WSanntms
        AskWoody Lounger
        September 25, 2014 at 10:38 am #1468727

        Perfect! Thanks!

        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.

        Reply | Quote
    Viewing 0 reply threads
    Reply To: Excel left margin boxes 1 2 3 4

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    March 2025
    S M T W T F S
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    3031  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.