+ Reply to Thread
Results 1 to 4 of 4

Printing without the value

  1. #1
    Registered User
    Join Date
    02-26-2019
    Location
    Belgium
    MS-Off Ver
    MS 365
    Posts
    7

    Printing without the value

    Hi,

    I'm wondering if I can print cells without their value.
    Let's say I have a simple table:
    A B
    1 0.5mm 0.2mm
    2 0.4 mm 0.1mm

    I would like to be able to the following:
    If I print this table, I would like it that the values in mm don't print. So this way I have a new/empty table.

    I hope my intensions are clear enough

    Regards

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: Printing without the value

    Not really.
    If I understand that there is some form/table in excel and you would like to use it print new blank form even if form/table is already filled on excel, right?
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Registered User
    Join Date
    02-26-2019
    Location
    Belgium
    MS-Off Ver
    MS 365
    Posts
    7
    Quote Originally Posted by KOKOSEK View Post
    Not really.
    If I understand that there is some form/table in excel and you would like to use it print new blank form even if form/table is already filled on excel, right?
    Yes, indeed. I know that in theory I could just give the values a white colour but that's too much of a hassle.

  4. #4
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Printing without the value

    You could put conditional formatting into your template to change the data white at will. See attached sheet. If L1 = Yes, the data turns white.
    Attached Files Attached Files
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ 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] Dynamic printing area for logic and economic printing
    By vendam in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-23-2018, 01:43 AM
  2. Replies: 1
    Last Post: 06-11-2014, 09:23 AM
  3. Replies: 0
    Last Post: 02-27-2014, 01:31 PM
  4. Replies: 0
    Last Post: 09-18-2013, 06:34 AM
  5. Replies: 0
    Last Post: 07-18-2012, 03:57 AM
  6. Replies: 3
    Last Post: 07-16-2012, 03:24 AM
  7. Disabling Printing ability of a sheet unless printing from a macro
    By cadamhill in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-05-2012, 04:41 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