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
- Open your Excel file and go to the "Page Layout" tab in the ribbon.
- Click on the "Orientation" dropdown menu and select "Landscape".
- Click on the "Print" button in the "Print" group to open the Print dialog box.
- In the Print dialog box, select the printer you want to use and click on the "Properties" button.
- In the Printer Properties dialog box, click on the "Paper" or "Layout" tab and select "Landscape" as the orientation.
- Click "OK" to close the Printer Properties dialog box and then click "Print" to print the Excel sheet.
- Save the Excel file as a PDF or XLSX file and attach it to your email.
Method 2: Using Microsoft Outlook
- Open your email client (Microsoft Outlook) and compose a new email.
- Attach the Excel file to the email by clicking on the "Attach File" button and selecting the Excel file.
- Right-click on the attached file and select "Properties" (or "File Properties" in Outlook 2016 and later).
- In the Properties dialog box, click on the "General" tab and select "Landscape" as the orientation.
- Click "OK" to close the Properties dialog box.
- 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.