When saving Excel file to PDF, there are multiple sheets being saved!

Hi guys,

I have an excel sheet template

When I savew it to pdf, there are 59 blank sheets being saved and the table on my sheet is saved on 2 pages (instead of 1 page).

Can anyone help me change the setup so that i can save the excel sheet as one page? I have even hgihglighted the cells to save it as a selection but it makes no difference.

Please find excel file attached. thank you!

The last cell in your sheet is IU996. It doesn't appear you are actually using any of those cells but you have formatted them with gray fill so they are printed.

The simplest way to deal with this is to select the cells in your form, go to Page Layout, Page Setup, Print Area, then Set Print Area.

You have the scale set to 10%, which is probably not what you want. Go to Page Layout, Page Setup, Print Titles, and click the Page tab. Set "Adjust to" to be 100%.

Now Export to PDF.

A somewhat better way to do this is to delete the excess rows and columns you have shaded. Then if you only want the form to be visible, you can hide all columns after and rows below the form. I can give detailed steps if you do not know how to do this.

Originally Posted by David A Coop

Your problem seems to be the size of your PRINT AREA.

Go to Page Layout/Print Area and select Clear Print Area.

Now select the print area you want.

Hope this resolves your problem - please let me know

Regards

David

Life saver - I mean time saver! thank you so much David!

similar steps as david, rep added nonetheless. thank you !