Home |
Search |
Today's Posts |
#1
|
|||
|
|||
printing a single row of info.
How can I print just one row of info from a work sheet that is normanlly
about 20 rows and 75 columns? |
#2
|
|||
|
|||
Select the area to be printed & go to Print dialogbox. Choose "Selection",
then Print. Or select the cells to be printed & go to FilePrint AreaSet Print Area, then Print. HTH |:) "Gary" wrote: How can I print just one row of info from a work sheet that is normanlly about 20 rows and 75 columns? |
#3
|
|||
|
|||
Thanks, but it prints on several pages, any ideas on how to print on one page
Gary "CyberTaz" wrote: Select the area to be printed & go to Print dialogbox. Choose "Selection", then Print. Or select the cells to be printed & go to FilePrint AreaSet Print Area, then Print. HTH |:) "Gary" wrote: How can I print just one row of info from a work sheet that is normanlly about 20 rows and 75 columns? |
#4
|
|||
|
|||
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. Gary wrote: Thanks, but it prints on several pages, any ideas on how to print on one page Gary "CyberTaz" wrote: Select the area to be printed & go to Print dialogbox. Choose "Selection", then Print. Or select the cells to be printed & go to FilePrint AreaSet Print Area, then Print. HTH |:) "Gary" wrote: How can I print just one row of info from a work sheet that is normanlly about 20 rows and 75 columns? -- Dave Peterson |
#5
|
|||
|
|||
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. |:) "Gary" wrote: Thanks, but it prints on several pages, any ideas on how to print on one page Gary "CyberTaz" wrote: Select the area to be printed & go to Print dialogbox. Choose "Selection", then Print. Or select the cells to be printed & go to FilePrint AreaSet Print Area, then Print. HTH |:) "Gary" wrote: How can I print just one row of info from a work sheet that is normanlly about 20 rows and 75 columns? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple worksheet queries | Excel Worksheet Functions | |||
problem printing to PDF | Excel Discussion (Misc queries) | |||
Convert one row and 50 columns of info to a single printable page | Excel Worksheet Functions | |||
is it possible to use F9 to manually calculate in a single sheet or single workbook? | Excel Discussion (Misc queries) | |||
paste info into merged cells | Setting up and Configuration of Excel |