print cel in column to one page

  • Thread starter Thread starter Steven Young
  • Start date Start date
S

Steven Young

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 prin

on a page by itself, etc...


I only want the cels from Column3 to print; only those cels.


How can I do that
 
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.
 
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.
 
Back
Top