You may often need to share your spreadsheet with others, especially if you want to preserve its formatting or ensure it looks the same on different devices. One of the easiest ways to do this is by exporting your Excel file to a PDF. This will allow others to view the document as you intended, without worrying about missing fonts or layout issues. In this article, we'll guide you through the steps to export an Excel spreadsheet to a PDF file for easy sharing.
---
Why Export Excel to PDF?
Before jumping into the steps, let's quickly review why you might want to convert an Excel file to a PDF in the first place:
Preserved Formatting: Unlike Excel files, PDFs maintain the exact look of your document, no matter what device or software the recipient uses to open it.
Universal Accessibility: PDFs can be opened on almost any device or operating system without needing Excel.
Professional Appearance: If you're sharing reports or business data, PDFs look more polished and professional than sending raw Excel files.
Security: With a PDF, you can control what others can do with your file. For example, you can restrict editing or printing.
---
How to Export an Excel File to PDF
Follow these steps to convert your Excel spreadsheet into a PDF for sharing:
Step 1: Open Your Excel Document
Open the Excel workbook you want to export. Make sure it’s the correct file and that all the data you want to share is up to date.
Step 2: Go to the "File" Menu
In the top-left corner of Excel, click the File tab. This will open the file options menu.
Step 3: Select "Save As" or "Export"
You have two main options to save your file as a PDF:
Save As: This option saves your file in a different location or with a different name.
Export: This option is available in newer versions of Excel and is a more direct way to convert the file.
Click on either Save As or Export, depending on what version of Excel you are using.
Step 4: Choose PDF Format
If you're using Save As, you'll be asked to choose a location on your computer to save the file. In the Save as type dropdown menu, select PDF.
If you're using Export, you’ll see a Create PDF/XPS Document option. Click it, and then select PDF as the file type.
Step 5: Select PDF Options (Optional)
Before you save, you can choose some options to customize the PDF output:
Entire Workbook: Select this if you want to convert the whole Excel file, including all sheets.
Active Sheet(s): This option allows you to only convert the currently active sheet.
Selection: If you only want to convert a selected range of cells, you can choose this option.
You may also want to adjust the page orientation (portrait or landscape), margins, or scaling to make sure your content fits properly onto the PDF pages.
Step 6: Save the PDF
After choosing your preferred settings, click Save or Publish. Excel will then convert the file into a PDF format and save it to your chosen location.
---
Customizing PDF Output
Sometimes, your Excel spreadsheet might not fit perfectly on a PDF page. To avoid this, you can customize how the document appears:
Adjusting the Page Layout
Before exporting, you might want to adjust how your content fits on a PDF page. Here’s how:
1. Page Layout Tab: Go to the Page Layout tab in Excel.
2. Margins: You can change the margins to make more room for content.
3. Orientation: Switch between portrait or landscape depending on which fits your data better.
4. Size: If your sheet is too large, you can reduce the print size by selecting a smaller page size.
Setting Print Areas
If your Excel sheet is large and only a portion of it is important to share, you can set a Print Area:
1. Highlight the area you want to include in your PDF.
2. Go to the Page Layout tab and select Print Area > Set Print Area.
When you export the file, only the selected area will be saved to the PDF.
Scaling Your Spreadsheet
If your data is too wide or tall for a single page, Excel has a feature that scales the content automatically:
1. In the Page Layout tab, find the Scale to Fit section.
2. Adjust the Width, Height, and Scaling options to shrink the content to fit on one page, if necessary.
---
Checking the PDF Before Sharing
Once your Excel sheet is converted to a PDF, open the PDF file to check if everything looks good. Make sure the layout, fonts, and data appear as expected. Check the following:
Text Alignment: Ensure that columns and rows are aligned properly.
Page Breaks: Sometimes, page breaks can occur in odd places. If needed, adjust the print area or scaling options.
Readability: Make sure the font size and content are readable. You can adjust these in Excel before exporting.
---
Sharing the PDF
Now that your Excel sheet is in PDF format, you can easily share it with others via email, cloud storage, or any other method you prefer. Because PDFs are universally accessible, the person receiving the file doesn’t need Excel installed to view the document.
---
How to divide columns and rows across multiple pages
To divide columns into multiple pages when exporting your Excel sheet to PDF, you can adjust the page breaks or set the document to fit across several pages. Here’s how you can do it:
1. Manually Insert Page Breaks
You can manually insert page breaks to control where the content divides across multiple pages:
Step 1: Go to the View tab and click on Page Break Preview. This will show a preview of how your sheet will look when printed, with blue lines indicating where the page breaks will occur.
Step 2: Click on the column or row where you want the page to break.
Step 3: Go to the Page Layout tab and click Breaks > Insert Page Break. This will insert a break at the selected point.
Step 4: You can adjust the page breaks by dragging the blue lines in Page Break Preview mode to fine-tune where the content divides across pages.
2. Fit Data to Multiple Pages
If you want to fit the data across multiple pages automatically, you can adjust the scaling options:
Step 1: Go to the Page Layout tab.
Step 2: In the Scale to Fit group, you’ll see options like Width and Height.
Step 3: Set Width to “1 page” and Height to “Automatic” (or vice versa, depending on whether you want the data to stretch across pages horizontally or vertically).
This will scale your content so that it fits on the selected number of pages.
Step 4: You can also try Fit to (under Page Layout > Scale to Fit) and enter a number of pages (e.g., “Fit to 2 pages wide by 1 page tall”).
3. Print Titles and Adjust Repeating Rows or Columns
If your data is long and spans multiple pages, you may want to repeat column headers or row labels on every page for clarity.
Step 1: Go to the Page Layout tab.
Step 2: Click on Print Titles (under the Page Setup group).
Step 3: In the dialog box that appears, go to the Rows to repeat at top field, and select the rows you want to repeat on every page (e.g., your header row).
Step 4: For repeating columns, go to Columns to repeat at left and select the columns you want to repeat (e.g., your row labels).
4. Check and Adjust Page Breaks
If you're unsure about how your sheet will look when exported:
Step 1: Go to File > Print.
Step 2: In the Print Preview, you’ll see how your sheet is divided into pages.
Step 3: If the content doesn’t look right, go back to Page Layout and adjust the page breaks, scaling, or margins.
---