+ Reply to Thread
Results 1 to 3 of 3

Hide or Show Cells when printing...

  1. #1
    Registered User
    Join Date
    02-26-2009
    Location
    Australia
    MS-Off Ver
    Office 365
    Posts
    64

    Hide or Show Cells when printing...

    I have a workbook that I want to show or hide a selection of cells depending on another cell when printing it.

    Example

    If cell x = A2A then display a certain cell set if anything else then exclude cell set from printing.

    All help is greatly apreciated.

    Thanks
    Last edited by demon8991; 04-02-2009 at 08:50 AM.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,040

    Re: Hide or Show Cells when printing...

    Can you with conditional formating paint that cells in white (actually same font color as cell)?
    In that case you won't see them when printing.
    Never use Merged Cells in Excel

  3. #3
    Registered User
    Join Date
    02-26-2009
    Location
    Australia
    MS-Off Ver
    Office 365
    Posts
    64

    Re: Hide or Show Cells when printing...

    Thanks for your help ive managed to sort it.

    Thank you

+ 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