+ Reply to Thread
Results 1 to 3 of 3

Show/Hide Rows & Columns Toggle Button

  1. #1
    Registered User
    Join Date
    05-19-2015
    Location
    Houston, TX
    MS-Off Ver
    Pro 2013
    Posts
    30

    Show/Hide Rows & Columns Toggle Button

    I was sent a spreadsheet to use as a basis for a database and whoever created it included a show/hide toggle button for various column ranges and rows.

    On the attached pictures, for Row 3 there is a toggle button. Clicking the '+' button unhides Row 3, and clicking the '-' hides Row 3. I thought that was pretty useful and would like to use that on other spreadsheets, but I've searched all the menus and help files and can't find out how to add that to a spreadsheet. I went to the Macro list and there are non listed.

    Any idea how to add this?

    Thanks
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    06-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    51

    Re: Show/Hide Rows & Columns Toggle Button

    Hi axegrynder

    I think this is what you want:
    Highlight the columns that you want to hide/unhide, and the go to Data > Group > Group.

  3. #3
    Registered User
    Join Date
    05-19-2015
    Location
    Houston, TX
    MS-Off Ver
    Pro 2013
    Posts
    30

    Re: Show/Hide Rows & Columns Toggle Button

    Quote Originally Posted by Rschwar23 View Post
    Hi axegrynder

    I think this is what you want:
    Highlight the columns that you want to hide/unhide, and the go to Data > Group > Group.
    Yes that's it. 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. [SOLVED] Toggle Button to hide/unhide rows based on value
    By goomblar in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-03-2014, 07:35 AM
  2. button to toggle hide/unhide columns
    By dbuff in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-03-2013, 07:56 PM
  3. [SOLVED] Hide Show Excel Toolbars using a Toggle Button
    By HangMan in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 07-11-2012, 05:11 PM
  4. VBA hide row based on pull down with button to toggle show/hide
    By myronr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2012, 06:07 PM
  5. Using Toggle Button to hide/unhide rows that may change
    By jmpatrick in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2011, 09:48 AM

Tags for this Thread

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