You can try out the below macro. If you are new to macros..

--Set the Security level to low/medium in (Tools|Macro|Security).
--From workbook launch VBE using short-key Alt+F11.
--From menu 'Insert' a module and paste the below code.
--Get back to Workbook.
--Run macro from Tools|Macro|Run <selected macro()


Sub FitWorkbookToOneOne()
Dim intTemp As Integer
For Each sh In ActiveWorkbook.Sheets
With sh.PageSetup
.Orientation = xlPortrait
.PaperSize = xlPaperA4
.Zoom = False
.FitToPagesWide = 1
.FitToPagesTall = 1
End With
Next
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Val Mc" wrote:

I have approx. 200 sheets in my workbook and I need to fit each sheet to one
page. I can do it individually ( ie. page set up or format painter) but it
takes time. Can I convert the entire workbook to print to 1 page?