+ Reply to Thread
Results 1 to 2 of 2

Hide blank cells in a column

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    Hide blank cells in a column

    I want to hide blank cells in a column (NOT delete) and only one column at a time.
    There is data in column A5, A10, A71
    B4, B20, B30

    I want to hide all other cells except A5, A10, A71, B4, B20, B30
    So I need to perform the action on each column individually.

    Tomorrow there may be data in A5, A10, A71 and A100 and B4, b20, b30, b35 and C10, C20 so then I want the formula to adjust automatically and only display those cells that have something in them. I don't want to have to manually hide or unhide every day, because data will be changing every day.

    The only solution I can find is to download a tool called Kutools for Excel. However, my office will not allow that. I'm sure there's a way to do it in Excel (2010) but I'm not an expert and haven't really found any solution by searching. It may end up being a programming command - but again, I'm not savvy in that.


  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.

    Re: Hide blank cells in a column

    Try setting up a conditional format that sets the font colour to white (or whatever the background colour is)
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. Hide rows for blank Cells when there is another blank cell below
    By bilich in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-16-2016, 08:29 PM
  2. Hide blank rows in column -> in another column
    By InvalidTxtString in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-05-2016, 11:36 AM
  3. Hide Rows for First Set of Consecutive Blank Cells in Column
    By pastuslm in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-22-2015, 03:22 PM
  4. [SOLVED] Hide Rows if the cell in a certain column is blank or zero
    By Shannon561 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-16-2014, 07:00 AM
  5. [SOLVED] Hide any rows 5 through 16 in which column H is blank
    By Triscia in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-14-2013, 04:30 PM
  6. Hide columns if all cells are blank or 0.00
    By Atticgirl in forum Excel General
    Replies: 9
    Last Post: 07-21-2011, 08:44 AM
  7. Hide Row if ALL cells in Rng are Blank
    By hutch@edge.net in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-27-2009, 04:20 PM

Tags for this Thread


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