Tuesday, October 23, 2012

How to Change the Orientation of a Worksheet to Landscape in Microsoft Excel


1. Connect your computer to a printer if you have not set up a printer yet for your computer. You do not need an active printer connection to change the page orientation, but you do need a printer setting entered into the computer. Otherwise, Excel will gray out the page orientation option because it only applies to printing. Connecting a printer via USB will automatically launch the setup wizard. Follow the onscreen instructions to install the printer driver until the setup is complete.
2. Launch Excel and open your workbook to the worksheet you want in landscape mode.
3. Close out of any cells you are editing by pressing 'Enter' or clicking in another cell to save your changes, or press 'Esc' to exit the cell without change.
4. Click the 'Page layout' tab in the Office Ribbon, and then choose 'Orientation' from the 'Page setup' area.
5. Select 'Landscape' to change your page orientation. This will close the menu automatically and make the change.

Blogger news