OmniDocHow to convert Excel to PDF table and print it in the center
When exporting an Excel table to PDF, the table is often offset to one side of the page. This article explains how to turn on horizontal and vertical centering at the same time in the page margins of the page settings, and explains the difference between it and scaling and paper orientation. Finally, it gives a verification method after exporting.
Key points of this article
- Table centering is the page margin function in page settings. Checking horizontal and vertical centering will center the table on the paper.
- Centering, scaling, and paper direction are three things. When the table is tilted to one side, first check the centering, and then check whether the width exceeds the paper.
- Set the print area before exporting to prevent blank rows and columns from squeezing the table aside.
- After exporting the PDF, use print preview and PDF reader to check whether the left and right margins, pagination, and numbers are complete.
After exporting an Excel table to PDF, many people will find that the table is tilted to the upper left corner, leaving a large blank space on the right, or near the top of the page. This is common in reports, timetables, quotations, and data lists. It's usually not a problem with the table itself, but rather with the centering option in the page settings not being turned on.
This article is for anyone who needs to give their forms to someone else to print, file, or submit. After reading, you can center the table horizontally and vertically in Excel, and you can confirm whether the result is correct after exporting it to PDF. This article only talks about general page setting ideas and does not rely on a fixed menu position.
How to convert excel to pdf in the center? One sentence conclusion
The direct conclusion is: find the Margins tab in Excel's page setup, check both "Horizontal" and "Vertical" in Centering mode, and then export the PDF. If the table width exceeds the paper, you need to deal with scaling or paper orientation first, otherwise centering will have no effect.
| your situation | Recommended practices | reason |
|---|---|---|
| The form is narrow, only to the left or right | Check Horizontal Center | The left and right margins are inconsistent because the horizontal centering is not enabled. |
| The table is at the top of the page, and there is a lot of space below it | Check vertical center | Vertical centering is not enabled by default, and the table will stick to the top margin. |
| The table is very wide and is cut off on the right side or split onto the second page | Adjust scale or paper orientation first, then center | The part beyond the paper cannot be solved by centering |
| There are a lot of blank rows and columns before and after the table | Set the printing area first, then center it | The blank area is also involved in the calculation, and the table will be pushed to the other side. |
| To center multiple worksheets | Set each worksheet one by one and then export them collectively. | Page setup usually only affects the current worksheet |
Before you start: Confirm these points first
First confirm the actual range occupied by the form. If there are notes, old data or formatting residues on the right side of the table, Excel will include these areas into the printing range, and the centered table will be offset to the left. You can find this type of problem by pressing Ctrl+End after opening the table to view the last used cell.
Confirm paper size and orientation. The same table has completely different centering effects in A4 portrait and landscape orientations. Horizontal is more suitable for tables with many columns, while vertical is suitable for tables with many rows and few columns. Don’t rush to adjust the margins before the direction is determined.
- confirm whether zooming is required. * zooming determines whether the form can be put on one page. If the zoom ratio is too small, the word will become ugly; if you do not zoom, the table may be split into several pages. Centering works only after zooming, and the two should be considered together.
- distinguish between "center" and "margin size". * the margin size determines the width around the page, and the center determines the position of the form in the printable area. Reducing the left and right margins does not automatically center the table.
- prepare a sample. * if the form is very long, such as a 30-page report, it is recommended to use the first two or three pages to test the settings, and then export the whole form after confirming the effect, so as to avoid repeated adjustments.
# steps to center a table and export PDF in Excel
- Open the workbook you want to export, switch to the worksheet you want to print, and select the full table area.
two. Set the print area in the page layout settings to include only the cells that need to appear in the PDF.
- Open the page setup dialog box, select the margins tab, and retain or adjust the top, bottom, left and right margin values as appropriate.
- Check both horizontal and Vertical in the center mode area so that the form will be centered left and right, up and down in the printable area.
- If the table exceeds one page, go back to the page tab to adjust the zoom, or switch the paper direction, and then go back to the margin to check that the center is still valid.
- Turn on print preview to confirm that the table location, paging, and header and footer are as expected.
- Choose the printer output or save as PDF to export the file and save it locally.
When exporting, if you are using the print function that supports PDF output, you can select the range of pages to be consistent with the preview to avoid the difference between the number of pages exported and the preview.
# check item by item after completion
The exported PDF needs to be opened in the reader for inspection, and there are sometimes differences between the print preview and the final file.
| Check item | What do you think? | What if there's a problem? |
|---|---|---|
| Left and right blank | The blank widths on the left and right of the table are roughly the same. | Only one side is centered or the print area contains empty columns, go back to the margins and reset the print area |
| Upper and lower position | The form is not attached to the top, nor is it obviously on the bottom. | Do not check vertical center, fill it up and re-export |
| Paging situation | The form is not split to the second page, or the split position is reasonable. | Adjust the zoom or change to horizontal, and set the top header line if necessary |
| Numbers and words | The cell content is complete, no "#" appears or is truncated | Increase the column width, or reduce the font size, and then re-export |
| Number of pages | The number of PDF pages is the same as print preview | Check the print range and page number settings to remove excess blank pages |
If the PDF has been generated but finds that the content needs to be modified, such as correcting a number or paragraph text, you can use the PDF editor of the OmniDoc desktop client to modify the paragraph text, or you can delete, rotate, merge or split the page. It should be noted that the editor deals with text and pages and is not responsible for adjusting the layout of the table. Therefore, the centering problem should be returned to the Excel source file as far as possible and then exported. The download address of desktop client is download.omnidoc.top.
# frequently asked questions (FAQ)
1. Check only the level is in the middle, the form is still on the upper side, why?
Horizontal centering only deals with the left and right directions, and the upper and lower positions are determined by vertical centering. When the table is on the upper side, you need to check the vertical center at the same time, and the two options should be set together.
2. The table is already in the center, and then deviated after exporting PDF. What should I do?
First check that the page range and scale at the time of export are consistent with the print preview. Part of the export method recalculates the zoom, resulting in a change in position. It is recommended that after confirming the print preview, export directly with the same settings, and then check it in the PDF reader.
3. What is the reason why the margin has been modified but the print preview has not changed?
The common reason is that another worksheet is currently selected, or that the page setup is applied to only part of the worksheet. Switch to the target worksheet reset and verify that the print preview shows the current table.
4. Free online conversion site exported PDF can not be centered, how to choose?
When selecting such a tool, you can first see if it retains the table's column width, row height, and paging settings, and whether it has clear hints on file size, watermarks, and privacy instructions. If the format of the form is obviously deformed after conversion, it is recommended to go back to Excel to set up the page, and then print or save as PDF to export.
# Summary
Excel to PDF when the form is centered, the key is to set up the margins of the page to check both horizontal and vertical center, and first set the print area and zoom mode. After export, you can use print preview and PDF reader to check the blank space, paging and digital integrity item by item, and you can get the form file with the correct location.
