+ Reply to Thread
Results 1 to 5 of 5

How to make collapsible columns ?

  1. #1
    Registered User
    Join Date
    04-19-2011
    Location
    Berlin, Germany
    MS-Off Ver
    MS 365
    Posts
    29

    How to make collapsible columns ?

    Hello all,

    I'm running on Excel for Mac 2011.
    I have a pretty classical spreadsheet with data classified by lines and columns.
    I'd like to be able to make some of my columns collapsible as to reduce the width of my spreadsheet.

    How can I go about doing that ?

    Best regards,
    Alexandre

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2406 (Windows 11 23H2 64-bit)
    Posts
    82,813

    Re: How to make collapsible columns ?

    You can do one of two things:

    1. Select, right-click and hide columns.
    2. Use grouping on the Data ribbon.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    04-19-2011
    Location
    Berlin, Germany
    MS-Off Ver
    MS 365
    Posts
    29

    Re: How to make collapsible columns ?

    Oh, I found out. By grouping in the data tab.

  4. #4
    Registered User
    Join Date
    04-19-2011
    Location
    Berlin, Germany
    MS-Off Ver
    MS 365
    Posts
    29

    Re: How to make collapsible columns ?

    Perfect. Thank you.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2406 (Windows 11 23H2 64-bit)
    Posts
    82,813

    Re: How to make collapsible columns ?

    You're welcome!

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Create collapsible heading inside table
    By Excelforum*ser_mH7 in forum Word Formatting & General
    Replies: 6
    Last Post: 07-20-2018, 02:36 PM
  2. Counting number of cells inside collapsible row/column
    By Shahzai in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-11-2015, 02:18 PM
  3. Insert collapsible image in Word 2010?
    By MetroBOS in forum Word Formatting & General
    Replies: 0
    Last Post: 05-13-2015, 10:01 AM
  4. [SOLVED] make new columns from copying values from other columns
    By lenorsk in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-18-2012, 10:55 AM
  5. Expand/Collapsible Button
    By tasdan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-30-2012, 03:40 AM
  6. Expandable/Collapsible Flow Charts?
    By fuzzy1 in forum Excel General
    Replies: 0
    Last Post: 11-02-2007, 06:22 PM
  7. Collapsible Columns
    By oliver79 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-20-2007, 04:54 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1