+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Excluding a row from printing

Hybrid View

  1. #1
    Registered User
    Join Date
    04-02-2009
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Excluding a row from printing

    Hello,

    I'm currently using Lotus 1-2-3 to make spreadsheets, and it has a feature that I really like. Here is a description of the feature from smartcomputing.com:
    "Exclude rows from printing. You can exclude a row from printing by typing a vertical bar (|) in the row's left-most cell within the print range. The vertical bar will not appear on the printout, and the suppressed data will remain in the worksheet for use in all applicable calculations."

    Does this feature exist in Excel 2007?
    Hiding cell won't suffice, I need the rows to stay visible for calculations, but I don't want them to appear when I print.

    Thanks for help.

  2. #2
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: Excluding a row from printing

    look at the example attached.
    there is a macro in the workbook_before_print, that looks for * in column A and hides those rows from printing.
    I don't quite know how to unhide those rows after printing, so I have created a button for that.
    I am sure some one will give you the code to unhide rows after printing is done.
    hope this helps.
    modytrane
    Attached Files Attached Files

+ 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