How to print excel sheet in landscape in mail

To print an Excel sheet in landscape orientation when sending it as an email attachment, you can follow these steps:

Method 1: Using Excel

  1. Open your Excel file and go to the "Page Layout" tab in the ribbon.
  2. Click on the "Orientation" dropdown menu and select "Landscape".
  3. Click on the "Print" button in the "Print" group to open the Print dialog box.
  4. In the Print dialog box, select the printer you want to use and click on the "Properties" button.
  5. In the Printer Properties dialog box, click on the "Paper" or "Layout" tab and select "Landscape" as the orientation.
  6. Click "OK" to close the Printer Properties dialog box and then click "Print" to print the Excel sheet.
  7. Save the Excel file as a PDF or XLSX file and attach it to your email.

Method 2: Using Microsoft Outlook

  1. Open your email client (Microsoft Outlook) and compose a new email.
  2. Attach the Excel file to the email by clicking on the "Attach File" button and selecting the Excel file.
  3. Right-click on the attached file and select "Properties" (or "File Properties" in Outlook 2016 and later).
  4. In the Properties dialog box, click on the "General" tab and select "Landscape" as the orientation.
  5. Click "OK" to close the Properties dialog box.
  6. Send the email as usual.

Method 3: Using a third-party add-in

There are several third-party add-ins available that can help you print Excel sheets in landscape orientation when sending them as email attachments. For example, you can use the "Print Friendly & PDF" add-in for Outlook, which allows you to print and save web pages, including Excel files, in landscape orientation.