Printing Sheets in a Workbook

T

Té

I have 4 worksheets in my workbook. When I go to print and choose the entire
workbook the print preview reads page 1 of 4 (referring to the whole book).
How can I set it up where it reads page 1 of 1 on each sheet, without
printing each sheet individually. So far sheets 2-4 it reads page 1 of 1
because they are separate sheets even though they're in a workbook together.
 
Y

YESHWANT JOSHI

in my opinion redefining the print area can solve your problem.
select the area of the workshet you want to take the print, click file-print
area-set print area.

if this helps, click yes below
 
G

Gord Dibben

For OP

To print 1 of 1 you will have to print each worksheet as a separate print
job.


Gord Dibben MS Excel MVP
 
Y

YESHWANT

Other way out is you can hard code the footer by simply adding the text "1 of
1" in the footer option in page setup.

click yes below, if 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