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

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

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