Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Complete List of Excel Lookup and Reference Functions, References and Examples
  • To count total rows in a range in Excel
  • Vlookup Examples in Excel
  • Count rows with at least n matching values
  • Count unique text values with criteria

Data Analysis Examples

  • How to combine 2 or more chart types in a single chart in Excel
  • Conditional Formatting New Rule with Formulas in Excel
  • Conditional Formatting Data bars Examples in Excel
  • How to Create Thermometer Chart in Excel
  • Excel Frequency Function Example

Data Validation Examples

  • Excel Data validation no punctuation
  • Excel Data validation allow uppercase only
  • Excel Data validation specific characters only
  • How To Create Drop-down List in Excel
  • Excel Data validation number multiple 100

How To Change Paper Orientation In Excel

by

— Print a worksheet in landscape or portrait orientation

Default paper orientation is mostly  portrait.

Excel can fit three more columns of information on the page in landscape mode than it can in portrait mode.

2 Ways to change page orientation in Excel

Because many worksheets are wider than they are tall (such as budgets or sales tables that track expenditures over a period of time), you may find the need to switch the orientation from the default portrait mode to landscape mode.

Worked Example:   How to choose page/paper size in Excel before Printing

a. Page Layout tab → Page Setup group → Orientation button reveals a drop-down menu with these two options:

  • Portrait
  • Landscape
Worked Example:   Print Headers and Footers in Excel

 

For report,  portrait orientation may work better.

b. Change the page orientation when you are ready to print

  1. Select the worksheet, worksheets, or worksheet data that you want to print.

  2. Click File > Print.
  3. In the Page Orientation drop-down box, under Settings, click Portrait Orientation or Landscape Orientation.
  4. When you are ready to print, click Print.
Worked Example:   How to setup and print Excel worksheets

Post navigation

Previous Post:

Select, Insert, Rename, Move, Delete Worksheets in Excel

Next Post:

How to choose page/paper size in Excel before Printing

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • SUBSTITUTE function: Description, Usage, Syntax, Examples and Explanation
  • Remove line breaks in a cell in Excel
  • CODE function: Description, Usage, Syntax, Examples and Explanation
  • Split dimensions into three parts in Excel
  • How to check if cell contains some words but not others in Excel
  • Calculate number of hours between two times in Excel
  • Get first Monday before any date in Excel
  • Convert time to time zone in Excel
  • Display Date is same month in Excel
  • Get date from day number in Excel
  • INTRATE function: Description, Usage, Syntax, Examples and Explanation
  • IRR function: Description, Usage, Syntax, Examples and Explanation
  • ACCRINT function: Description, Usage, Syntax, Examples and Explanation
  • NPER function: Description, Usage, Syntax, Examples and Explanation
  • RATE function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles