×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Excel 2003 - Printing Non-Continuous Rows In Spreadsheet

Excel 2003 - Printing Non-Continuous Rows In Spreadsheet

Excel 2003 - Printing Non-Continuous Rows In Spreadsheet

(OP)
I have a spreadsheet that shows some reinforcing choices in a few rows and I would like to have them visible to the user, but not print them in the output.  What is the simplest way to do this?  (FYI: There are hidden rows in the spreadsheet.)

Thanks

RE: Excel 2003 - Printing Non-Continuous Rows In Spreadsheet

Can you set the print area to not include the rows that are not to be printed? File/Print Area/Set Print Area...

Wheels within wheels / In a spiral array
A pattern so grand / And complex
Time after time / We lose sight of the way
Our causes can't see / Their effects.

RE: Excel 2003 - Printing Non-Continuous Rows In Spreadsheet

(OP)
I tried to do that, but the rows are in the middle of the spreadsheet and the print preview showed that it started a new page on either side of where I stopped and started the PRINT AREA.  Now that could be because I have title rows repeating at the top of each page.

RE: Excel 2003 - Printing Non-Continuous Rows In Spreadsheet

You could put the non-printing stuff in a comment.  Use Tools|Options|View|Comments & Indicator to make the comments visible and File|Page Setup|Sheet|Comments (None) to make the comments not print.

RE: Excel 2003 - Printing Non-Continuous Rows In Spreadsheet

You could set up a couple of views, one for working and one for printing, and just switch between them.

RE: Excel 2003 - Printing Non-Continuous Rows In Spreadsheet

This used to be a feature in Lotus that many people loved, which you can't do in excel without special programming.

Make a button, and modify the below macro to fit your needs inside the button.  Basically this is how it works.
In my case if my line item sum = 0, then my column A = |.
Then the macro goes through and hides the all the rows temporarly that the | temprorarly. It then prints the page.
Then unhides all the rows it just printed.



Sub LotusPrint()
    Dim UnhideRow() As Single
    Application.ScreenUpdating = False
    ' Locate the final row in column A
    FinalRow = Range("A65536").End(xlUp).Row
    Ctr = 0
' Check and hide each row that starts with a pipe
    For x = 1 To FinalRow
        If Left(Range("A" & x).Value, 1) = "|" Then
            ' Do nothing if the row is already hidden
            If Not Range("A" & x).EntireRow.Hidden Then
                Range("A" & x).EntireRow.Hidden = True
                ' Save the row number so that it can be unhidden
                Ctr = Ctr + 1
                ReDim Preserve UnhideRow(Ctr)
                UnhideRow(Ctr) = x
            End If
        End If
    Next x
    ' Print the sheet
    ActiveWindow.SelectedSheets.PrintOut
    ' Unhide any hidden rows
    If Ctr > 0 Then
        For x = 1 To Ctr
            Range("A" & UnhideRow(x)).EntireRow.Hidden = False
        Next x
    End If
    Application.ScreenUpdating = True
End Sub

Hopes this works for you.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login



News


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close