Learning how to convert Excel to PDF without losing formatting is important when sharing spreadsheets, financial reports, invoices, budgets, or business records. Converting an Excel file incorrectly can cause columns to become cut off, tables to split across pages, or text to appear too small. Fortunately, Microsoft Excel provides several settings that help preserve the original layout, fonts, colours, borders, and page arrangement.
-
Adjust Your Excel Spreadsheet Before Converting
Before converting your spreadsheet, make sure the information is properly arranged.
Follow these instructions:
- Open your Excel workbook.
- Check that all columns and rows contain the correct information.
- Adjust column widths to prevent text from being cut off.
- Increase row heights where necessary.
- Apply consistent fonts, colours, and borders.
- Remove unnecessary blank rows and columns.
- Check that formulas display the correct results.
Properly arranging your spreadsheet helps prevent formatting problems in the PDF.
-
Set the Correct Page Orientation
Choosing the correct page orientation helps ensure that your spreadsheet fits properly on the PDF pages.
To adjust the orientation:
- Open your Excel document.
- Click the Page Layout tab.
- Select Orientation.
- Choose Portrait for narrow spreadsheets.
- Choose Landscape for wide spreadsheets.
Landscape orientation is particularly useful for spreadsheets containing many columns.
-
Adjust the Page Size
The paper size determines how your spreadsheet appears when converted into a PDF.
Follow these steps:
- Click the Page Layout tab.
- Select Size.
- Choose your preferred paper size, such as A4 or Letter.
- Check whether the spreadsheet fits within the selected page size.
For most documents intended for printing in Kenya, A4 is a suitable choice.
-
Use the Fit to Page Option
The Fit to Page feature helps prevent columns and rows from extending beyond the PDF page.
Here is how to use it:
- Open the Page Layout tab.
- Find the Scale to Fit section.
- Set Width to 1 page.
- Set Height to Automatic.
This setting keeps all columns on one page wide while allowing the rows to continue onto additional pages.
Avoid forcing a very large spreadsheet onto one page in both directions because the text may become too small to read.
-
Set the Print Area
If your spreadsheet contains extra information that you do not want in the PDF, you can select the exact section to export.
Follow these instructions:
- Highlight the cells you want to include.
- Click the Page Layout tab.
- Select Print Area.
- Choose Set Print Area.
- Open Print Preview to check the selected content.
Only the selected area will be included when you print or export the spreadsheet.
-
Check Page Breaks and Margins
Page breaks determine where your spreadsheet is divided into separate PDF pages.
To adjust them:
- Click the View tab.
- Select Page Break Preview.
- Examine where the spreadsheet is divided.
- Drag the blue page-break lines to adjust the page divisions.
- Return to Page Layout and select Margins.
- Choose Normal, Narrow, or Custom Margins depending on your layout.
This helps prevent important tables and headings from being separated unnecessarily.
-
Convert Excel to PDF Using Save As
Once you have adjusted the formatting, you can convert the workbook into a PDF.
Follow these steps:
- Click File.
- Select Save As.
- Choose the folder where you want to save the document.
- Open the file type dropdown menu.
- Select PDF.
- Click Options if you want to choose whether to publish the active sheet, selected sheets, or the entire workbook.
- Click Save.
Your Excel spreadsheet will be converted into a PDF document.
-
Preview the PDF Before Sharing
After conversion, open the PDF and check the following:
- All columns and rows are visible.
- Text is readable and properly aligned.
- Colours, borders, and fonts are preserved.
- Tables are not cut off.
- Page numbers and headings appear correctly.
- No unwanted blank pages have been included.
If you notice formatting problems, return to Excel, adjust the page settings, and export the document again.
Also Read: How to Convert PDF to Word
Email your news TIPS to Editor@Kahawatungu.com — this is our only official communication channel
