Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    Toronto, canada
    Posts
    23
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Hide Unhide Columns

    I have attached a spreadsheet that I found on this site. In the left hand corner under the formula bar the numbers 1 & 2 appear, clicking on them hide or unhide columns. In addition there is a + and - sign that will allow you to hide unhide columns. Can anyone tell me if this is an excel option or is it VB code and if so what is the code/macro used?
    Attached Files Attached Files

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    The cells were selected, then on the "DATA" tab, the grouping option was used. No VB code; a standard feature.
    Attached Images Attached Images
    Last edited by kweaver; 2012-08-11 at 16:56.

Posting Permissions

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