Excel sheet page formatting

[Alikat]

Is it possible to change the page size (eg from US letter to A4 size) of each sheet of a book in Excel, without actually entering each sheet? Thanks. 

[rinkytink]

Try going to File...Print...

Then choose the properties button.

Then the advanced button.

Set the paper size here.

[Alikat]

I have tried that but it only changes the first sheet, the rest remain A4, any more suggestions would be appreciated. Thanks.

[ursula62]

Select the sheets you want to change by holding down the control key and clicking on the tabs with the sheet names.

Then go into File > Page Setup and change the paper size there. It will change for all the selected worksheets.