If you have a lot of Worksheet and you would like to print all of it at the same, consider using VBA module code as followsSub PrintAllFirstPage() Dim sheet As Worksheet For Each sheet In Application.ActiveWorkbook.Worksheets sheet.PrintOut from:=1, To:=1 Next End Sub
you can change the page range by editing the value of from:=
and to:=