printing a single row of info.

G

Gary

How can I print just one row of info from a work sheet that is normanlly
about 20 rows and 75 columns?
 
C

CyberTaz

Select the area to be printed & go to Print dialogbox. Choose "Selection",
then Print.

Or select the cells to be printed & go to File>Print Area>Set Print Area,
then Print.

HTH |:>)
 
G

Gary

Thanks, but it prints on several pages, any ideas on how to print on one page
Gary
 
D

Dave Peterson

just a guess...

Apply Data|Filter|Autofilter to your range.
Filter your range to show only the rows you want printed
print that visible range

Data|Filter|Showall
so you can see everything.

If this isn't close, you may want to post more details about what you really
want.
 
C

CyberTaz

If you mean having the additional cells in the 75 column row "wrap" back
under the previous columns, I have no idea. AFAIK that cannot be done, but
there are more talented than I in this Forum, so continue to check back. If I
come up with any ideas I'll let you know.

If I misunderstood, please clarify. |:>)
 
Top