print cel in column to one page

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
 
J

Jim Jackson

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.
 
F

FC

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.
 

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

Top