Change Orientation Of Excel 2010 Spreadsheet

In contrast to previous versions of Excel, Excel 2010 includes a slew of features to quickly manage the page layout and cell spacing including both row and fields. Whether you want to set the page size, change row height/width, tweak default column width or adjust page margins, it provides all frequently used page layout settings on the ribbon. Like Word and PowerPoint, Excel 2010 page orientation is also set to Portrait, by default, but you can easily switch to Landscape according to your page print requirements. Along with orientation, you can also set the page size, as it offers a number of page size presets including Letter, Tabloid, Legal, A3, A4, B4, B5 and more. The portrait orientation is ideal of long data sets, which include only a few columns, however, if you’re working on a data set that is spread across the screen, you should choose Landscape orientation to take print out of all required fields.

Apart from page layout and spreadsheet-related controls, you can quickly change the page orientation from the Orientation drop-down menu, accessible from Page Layout tab on the ribbon. It’s worth mentioning here that it doesn’t offer a way to permanently change the default orientation of the spreadsheet. However, if you want to tweak the default height and width of the page, open Page Setup (accessible via More Paper Size option present in Size drop-down menu), and specify the required height and width of your spreadsheet. Here, you can also set the page margins, paper size and print quality (DPI).

Once page orientation is set to Landscape, you can verify the orientation from Print Preview window.


569d1274874433-change-orientation-spreadsheet-

568d1274874432-change-orientation-spreadsheet-

 

Advertisement
  • Myashkov

    But cannot set different page layout orientation in Excel, as in Word. Example – when you have 2 pages long data sheet, the first page to be in portrait orientation, but second to be “Landscape” oriented. :(