For Excel 2007
Select the worksheet or worksheets for which you want to change the orientation.
On the Page Layout tab, in the Page Setup group, click Orientation, and then click Portrait or Landscape.
Note : If you don't have a printer set up, the Orientation option will appear dimmed, and you won't be able to select it. To resolve this, you must set up a printer by finding and installing printer drivers for Windows Vista or finding printer drivers for Windows XP. The option also appears dimmed when you're in process of editing the contents of a cell. To resolve this, press ENTER to accept the changes or ESC to cancel the changes.
This post was edited by TupacAshakur on Aug 9 2011 08:25pm