Printing selected rows?

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

vette

Thread Starter
Joined
Sep 21, 2002
Messages
152
I'm using Microsoft Excel for tracking information and I would like to print out selected rows in a group. Is there any way that I can print randomly selected rows like 1,5,10,15 and have them print out on the page as if they were consecutive rows and not one row per page with spacing as they apear on screen? This uses a couple of pages instead of being able to print one page.
 
Joined
Aug 25, 2004
Messages
893
Hello...

I believe if you hide the rows you do not want to print, you will be able to print the rows SHOWN. Not 100% sure without trying, but I believe it will work.
 

vette

Thread Starter
Joined
Sep 21, 2002
Messages
152
If I go to the window drop down menu and click on hide the whole window is gone, selected rows and all. It also does not allow me to select the print option then either. Any other suggestions?
 
Joined
Aug 25, 2004
Messages
893
Mark the row you do not want to print - whole row.

FORMAT -> ROW -> HIDE

Works for columns also.. I just tried it. It prints only the columns and rows that are not hidden.

Shane
 

vette

Thread Starter
Joined
Sep 21, 2002
Messages
152
I know how to print the selected rows but they would print with the same spacing on the paper as they appear on screen. What I wanted to do is to have them print out in a group to use less paper. I do think though that I may have found a way to print out the info that will work for me.
Thanks for the help.....
 
Joined
Aug 25, 2004
Messages
893
Sounds like it is time to switch to a database or learn visual basic? :) Hope whatever you have found works....

Shane
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top