+ Reply to Thread
Results 1 to 5 of 5

Mass (specific) Hide/Un-hide Columns

  1. #1
    Registered User
    Join Date
    06-18-2019
    Location
    Alabama, USA
    MS-Off Ver
    2019
    Posts
    3

    Mass (specific) Hide/Un-hide Columns

    Hello,

    I hope you all can help. I have a spreadsheet with dozens of sheets that contain pivot tables. It's based on a year's time with two columns for each month. One for Actual and one for Goal. Because of the way the pivot tables are set up, I need to have columns for each, but I only want one showing. The Goal column should be unhidden with the Actual hidden until the current month arrives. Then I would hide the Goal and unhide the actual.

    Is there a way I can hide, for example, all of the July Goal Columns on each sheet and unhide all of the July Actual columns at once?

    Thank you for any advice/guidance you can give.

    Moderator's note:
    Cross-posted at https://www.mrexcel.com/forum/excel-...-workbook.html
    Last edited by 6StringJazzer; 06-18-2019 at 02:18 PM.

  2. #2
    Registered User
    Join Date
    06-18-2019
    Location
    Central MN USA
    MS-Off Ver
    10 & 365
    Posts
    5

    Re: Mass (specific) Hide/Un-hide Columns

    Rather than hide and unhide, I would recommend using Data Group. The reason is it's sometimes difficult to remember what is hidden. Data Group will give you an outline so you always know there is more data in the background.

    Select the columns to group, either a single column or contiguous columns. You will see a bracket across the top indicating the group, and also numbered outline indicators on the top left. You can Group and Ungroup all at the same time.

    Group Columns.JPG

  3. #3
    Registered User
    Join Date
    06-18-2019
    Location
    Alabama, USA
    MS-Off Ver
    2019
    Posts
    3

    Re: Mass (specific) Hide/Un-hide Columns

    That's a great idea and a good solution, but is there any way to make this apply across multiple sheets or would I have to go into each sheet to group and ungroup?

  4. #4
    Registered User
    Join Date
    06-18-2019
    Location
    Alabama, USA
    MS-Off Ver
    2019
    Posts
    3

    Re: Mass (specific) Hide/Un-hide Columns

    Actually, I think I just figured it out. I can shift/select all of the worksheets and then pick the column to hide on the one I want. Ctrl0 and then it hides it from all of them. Same thing on the unhide. I'll use your group next time though!

    Thank you!

  5. #5
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,275

    Re: Mass (specific) Hide/Un-hide Columns

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Read this to understand why we (and other sites like us) consider this to be important.

    I have added the link for you because new members may not post links but please bear this in mind in the future.
    Jeff
    | | |?| |?| |?| |?| | |:| | |?| |?|
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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] Automatically Hide or not Hide columns, based on cell value (to the left)
    By sherylt13 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-04-2018, 07:47 PM
  2. Hide Rows/Hide Columns Based on Value in Cell
    By brickwall823 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2015, 02:42 PM
  3. hide specific columns
    By jiayeepoh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-15-2015, 04:13 AM
  4. [SOLVED] Hide specific Rows in Sheet1 + hide 5 more in Sheet2
    By bluesurger in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 06-02-2014, 07:19 AM
  5. Hide specific columns dependant on number in specific cell
    By ladbroke in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-13-2012, 04:46 PM
  6. Hide columns with 0 in a specific cell
    By Poldark in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-18-2012, 05:27 AM
  7. Hide on mass - Macro
    By Irprogram in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-17-2009, 07:12 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