Do all the sheets in my workbook end up in the PDF?

That depends on your preparation before converting. The default behaviour generally takes all worksheets into the output, which means the raw data, calculation or notes tabs you keep in the background also enter the file you share. The most reliable way to prevent this is to hide the sheets you do not want to share before converting, or to define a print area covering only the relevant range. Opening the output and checking the page count before sending also catches this mistake.

Do I really have to configure page settings before converting?

It is not mandatory, but it is almost always necessary. If you convert without adjusting anything, Excel works with the default portrait orientation and 100% scale; for tables with many columns that means the table is divided into vertical strips and spread across several pages. For a small list with only a few columns, the defaults give a perfectly fine result. If your table exceeds the page width, the orientation and scaling settings determine whether the output is usable at all.

Do charts and conditional formatting carry over to the PDF?

Yes, both carry over visually. Charts appear as drawn, and the cell colours and data bars produced by conditional formatting enter the output with their current appearance. However, they are no longer dynamic — since there is no way to change a cell's value in a PDF, conditional formatting is not recalculated and charts are not updated. In other words, the PDF gives you a photograph of the table at the moment of conversion.

Is there a way to make a very wide table readable as a PDF?

There is no single magic setting, but several approaches help. Switching to landscape orientation gains roughly 40% extra width and rescues most medium-sized tables. Hiding intermediate calculation columns not needed for the report genuinely narrows the table. If those are not enough, dividing the table into meaningful sections and making each a separate page gives a far better result than shrinking everything to an unreadable size.

How to Convert an Excel File to PDF: Step-by-Step Guide

What to understand before converting

Converting an Excel file to PDF is technically a matter of a few clicks. But whether the result is usable depends on the preparation you do before pressing the convert button.

The reason is simple: an Excel worksheet has no page size, and a PDF does. The unlimited canvas you navigate by scrolling on screen has to be divided into fixed-size pages. If you do not direct that division, Excel performs it according to its own defaults, and the result is usually not what you expected.

This guide covers the page settings first, then the conversion steps, and finally the output check.

Four settings to configure before converting

These settings are found on Excel's Page Layout tab and are saved with the workbook — meaning that when you save the file and convert it, these preferences are reflected in the output.

Choose the orientation to suit the table. For tables with many columns, landscape orientation is almost mandatory. An A4 sheet in landscape is noticeably wider than in portrait and allows most medium-sized tables to fit onto a single page.

Define a print area. If you select the cell range you want to share and set it as the print area, only that region enters the output. If you keep calculation tables or helper columns in the background, this setting prevents them from leaking out.

Repeat the header row. Use the "Print Titles" setting to make the first row repeat at the top of every page. On tables spread over multiple pages this is, on its own, the most valuable setting — without it, there is no way to tell which column a number on the third page belongs to.

Check the scaling. The "Fit all columns on one page" option is useful, but be careful: to make the table fit, Excel may shrink the font to an unreadable size, and it will not ask you first. If the scale drops below 60%, you need to change your approach.

Step by step: converting an Excel file to PDF

1. Configure the page setup and save

Review the four settings above. Then switch to "Page Break Preview" in Excel and look at where the blue lines fall — these show where the page breaks will land and are the most reliable way to see the conversion result in advance. You can drag the lines to decide the split points yourself. When you are satisfied, save the file; unsaved settings are not in the file.

2. Upload the file

Drag and drop the .xls or .xlsx file you saved onto the Excel → PDF tool, or find it through the file picker. You can upload several files at once and convert them in a batch, which saves considerable time when working with many similar files such as monthly reports.

3. Start the conversion

When you press the convert button, the processing happens on the server: the workbook is parsed, the page settings you saved are applied, the page divisions are calculated and the PDF is produced. The time taken varies with the size of the table and the number of charts in it. A medium-sized table containing only data finishes in seconds, while a large workbook holding many charts and conditional formatting rules may take longer.

4. Check the output

This step should not be skipped. Open the PDF you downloaded and look at the following: Is the page count what you expected, or has the table spread across far more pages than you thought? Has a worksheet you did not want to share entered the output? Does the header row repeat on every page? Are the numbers at a readable size, or have they been shrunk excessively for the sake of fitting? Have columns been cut off on the right? This check takes a minute and prevents you from sending out an incorrect financial report.

Files with more than one worksheet

If your workbook contains several sheets, this is the issue that demands the most attention before converting. The default behaviour is generally to take all sheets into the output, which means the raw data, intermediate calculation or personal notes tabs you keep in the background enter the file you share.

There are two ways to prevent this. The first is to hide the sheets you do not want to share before converting. The second, and more reliable, is to define a print area only on the sheets to be shared. Whichever method you choose, opening the output and counting the pages should be your final check — if there are more pages than you expected, extra content has leaked in from somewhere.

The order of sheets in the output generally follows the tab order in the workbook. If you want the report to read in a logical sequence, dragging the tabs into the correct order before converting is a simple but effective preparation.

Additional settings that keep the output readable

Beyond the basic steps, a few small settings make a multi-page table output genuinely usable.

Gridlines. The grey lines you see on screen in Excel do not enter the output by default. If you have not drawn cell borders by hand, numbers appear to float in space in the PDF. Enabling gridline printing from Page Layout, or applying real borders to the table, noticeably improves readability.

Page numbers and dates. Adding a page number to the header or footer prevents multi-page outputs from getting out of order. Adding a date makes it easier to tell which version you are looking at, especially for reports produced regularly.

Column widths. If a long number does not fit in a narrow column, Excel displays it on screen as "#####", and that appearance carries straight into the PDF. Reviewing column widths before converting stops you finding unreadable cells in the output.

An honest warning: not every table fits on one page

You should not trust the fit-to-page option blindly. Forcing a fifty-column data table onto a single page produces a technically "successful" but practically useless PDF — readable when you zoom in on screen, unreadable when printed.

In such a situation there are three reasonable routes: divide the table into meaningful sections and make each a separate page, genuinely narrow the table by hiding intermediate calculation columns not needed for the report, or accept that the table will spread over several pages and preserve readability through repeated headers. All three are better than shrinking everything to a microscopic size.

About formulas and dynamic content

A PDF shows the calculated result of formulas; the formula itself does not enter the output. In most cases this is the desired behaviour — when sharing a financial report, your calculation logic stays hidden.

Similarly, charts and conditional formatting carry over visually but lose their dynamism. The PDF is a photograph of the table at the moment of conversion. If the other party needs to work with the numbers or run scenarios, PDF is the wrong format and you should share the workbook itself.

In summary

In moving from Excel to PDF, the real work is done before you press the convert button. Choosing the orientation to suit the table, defining a print area, repeating the header row and keeping scaling within the bounds of readability — these four settings determine output quality. Seeing the result once in page break preview, and opening the downloaded PDF before sending it, are the two most practical habits.