This guide shows you different ways of changing the page orientation in Excel from portrait to landscape. Make it horizontal or vertical.

To change page setup for multiple tabs, the suggestion is to alter it for one tab, then select that tab first, followed by the others, go into page setup & then click OK.