Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Sheets in a Workbook
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Sheets in a Workbook
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 "Té" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Sheets in a Workbook
For OP
To print 1 of 1 you will have to print each worksheet as a separate print job. Gord Dibben MS Excel MVP On Thu, 6 Aug 2009 09:30:01 -0700, YESHWANT JOSHI wrote: 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 "Té" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Sheets in a Workbook
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 "Té" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing sheets in a Workbook | Excel Discussion (Misc queries) | |||
printing sheets from a workbook | Excel Worksheet Functions | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
Printing two sided workbook sheets | Excel Discussion (Misc queries) |