+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : Hidden Data Showing On Print Outs

  1. #1
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2016 H: 365
    Posts
    825

    Hidden Data Showing On Print Outs

    Hi,

    I've created some reports where i've camouflaged some of the data within the reports because its only purpose is to provide a reference for some of the formulas. The problem i've now encountered is that whilst they look o.k. on screen because they aren't visible when I print them off (in black and white) they show up on the print out.

    Is there any way around this or do I need to move the hidden data out of the print range?

    Thanks in advance,

    Snook
    Last edited by The_Snook; 01-10-2012 at 10:03 AM.

  2. #2
    Forum Expert OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,655

    Re: Hidden Data Showing On Print Outs

    How have you hidden the data? If by using font/fill colours, I suggest you simply format those cells with a custom number format of ;;; and then they should not appear.
    Good luck.

  3. #3
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2016 H: 365
    Posts
    825

    Re: Hidden Data Showing On Print Outs

    Yeah, the font and fill colours are the same. I'll try your custom format suggestion now.

    Thanks,

    Snook

  4. #4
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2016 H: 365
    Posts
    825

    Re: Hidden Data Showing On Print Outs

    Worked a dream, thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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