| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
print cel in column to one page
How can I setup an Excel spreadsheet column (of many rows) to print out each row of this column on a separate page? For instance: Column1 Column2 Column3 aa 001 print1 ab 002 print2 ac 003 print3 I would want "print1" to print on a page, by itself; "print2" to print on a page by itself, etc... I only want the cels from Column3 to print; only those cels. How can I do that? -- Steven Young |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
print cel in column to one page
You can click on "View/Page Break Preview" and, by dragging the page breaks,
set each cell up as a separate page. Each cell will print on a separate page in the upper left corner. -- Best wishes, Jim "Steven Young" wrote: How can I setup an Excel spreadsheet column (of many rows) to print out each row of this column on a separate page? For instance: Column1 Column2 Column3 aa 001 print1 ab 002 print2 ac 003 print3 I would want "print1" to print on a page, by itself; "print2" to print on a page by itself, etc... I only want the cels from Column3 to print; only those cels. How can I do that? -- Steven Young |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
print cel in column to one page
Select the column/s , row/s or as may cells as you want to print in
combination or ramdom(using ctrl). Click on 'file', select 'print area', click 'set print area', then print using the printer icon.Hope it helps. "Steven Young" wrote: How can I setup an Excel spreadsheet column (of many rows) to print out each row of this column on a separate page? For instance: Column1 Column2 Column3 aa 001 print1 ab 002 print2 ac 003 print3 I would want "print1" to print on a page, by itself; "print2" to print on a page by itself, etc... I only want the cels from Column3 to print; only those cels. How can I do that? -- Steven Young |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get my column titles to print at the top of 2nd page? | Excel Worksheet Functions | |||
| How do I print the 1st column as a row header in each page? | New Users to Excel | |||
| Print 'Column A' on every page | Excel Worksheet Functions | |||
| How do I add more than one column on a page that I need to print | Excel Discussion (Misc queries) | |||
| How do I print a single column of data in two columns on one page | Excel Discussion (Misc queries) | |||
Linear Mode
