+ Reply to Thread
Results 1 to 5 of 5

How do I hide a row from printing if a cell along the row is blank.

  1. 04-16-2020, 04:23 AM #1
    timstoneATC
    timstoneATC is offline
    Registered User
    Join Date
    04-15-2020
    Location
    Bristol, England
    MS-Off Ver
    Office 2016
    Posts
    2

    How do I hide a row from printing if a cell along the row is blank.

    Hi All, please see attached a screenshot of my query.

    Is it possible that if a cell is blank (or ideally has an 'N') that the whole row of that blank cell is missed from being printed?

    So for example, cell C9 on my screenshot has an 'N', therefore, all of row 9 is missed when the document is printed, but it is still a visible row on the worksheet for editing?

    I hope that makes sense.

    Thanks in advance

    Kind Regards

    Tim
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 04-16-2020, 04:25 AM #2
    AliGW
    AliGW is online now
    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. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,497

    Re: How do I hide a row from printing if a cell along the row is blank.

    Welcome to the forum.

    This will require VBA - shall I move this thread for you?
    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.
    Reply With QuoteRegister To Reply
  3. 04-16-2020, 04:26 AM #3
    timstoneATC
    timstoneATC is offline
    Registered User
    Join Date
    04-15-2020
    Location
    Bristol, England
    MS-Off Ver
    Office 2016
    Posts
    2

    Re: How do I hide a row from printing if a cell along the row is blank.

    Please, thanks Ali
    Reply With QuoteRegister To Reply
  4. 04-16-2020, 04:27 AM #4
    AliGW
    AliGW is online now
    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. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,497

    Re: How do I hide a row from printing if a cell along the row is blank.

    Thread is now in the VBA section.
    Reply With QuoteRegister To Reply
  5. 04-16-2020, 10:08 AM #5
    Marc L
    Marc L is offline
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow Re: How do I hide a row from printing if a cell along the row is blank.


    Hi,

    maybe without any VBA procedure just using a filter displaying only the rows to be printed …
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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. [SOLVED] Hide value if cell is blank
    By cny in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-07-2016, 09:44 PM
  3. Hide a row if cell contains blank
    By nostrum in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-13-2015, 02:45 PM
  4. STOP PRINTING IF CELL is BLANK E.G B2 is blank then stop printing
    By gopising in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-17-2014, 10:03 AM
  5. Hide Column & Print page Macro printing blank page?!
    By Margate in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2013, 03:59 PM
  6. Hide cell content in printing
    By Marsha in forum Excel General
    Replies: 4
    Last Post: 07-11-2005, 04:05 PM
  7. Printing if a cell is blank
    By Martin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2005, 12:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1