printing a single row of info.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I print just one row of info from a work sheet that is normanlly
about 20 rows and 75 columns?
 
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 |:>)
 
Thanks, but it prints on several pages, any ideas on how to print on one page
Gary
 
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.
 
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. |:>)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Row height setting problem 8
counting blank cells within two columns 2
Automatically adding additional rows 3
Print Frozen Panes? 2
Bland Rows 9
Macro to hide rows with zero values in columns 2
Numbering rows when printing 7

Back
Top