Share and distribute
Print and PDF
Print a Business Central workbook or save it as PDF from the sheet: add a logo, set the print area, paper, scaling and repeated rows, and a header and footer.
updated: applies-to: 1.0.0.0
A print layout sets the page for each sheet: the area to print, the paper, the scaling, and a header and footer. Print / PDF and Send both use it, so a sheet looks the same on paper, in a PDF and in an email.
Add a logo
- On the Insert tab, choose Image.
- Give it alternative text, and choose how it sizes in its cells: Fit keeps its shape, Fill covers the cells, and Stretch fills them exactly.
- Set the top-left cell and the size in rows and columns, and turn off Show a title bar so the page shows only the picture.
- Choose Insert, then pick the file: PNG, JPEG or GIF, up to 2 MB.
Set up the print layout
Select the part of the sheet to print. On the View tab, open Print Layout. You can also insert one from the Insert tab, under Page, Print layout.
- Choose Use selection for the print area.
- Choose the orientation, the paper (A4, Letter, Legal or A3) and the margins.
- Under scaling, fit all columns on one page, fit to a number of pages wide, or adjust to a percentage of normal size.
- Set the rows to repeat at the top of every page, for example rows 1:2, and the columns to repeat at the left.
- Build the header and footer from tokens, then choose Save.
The header and footer each have a left, center and right part. The tokens are &[Page], &[Pages], &[Date], &[Time], &[Workbook], &[Sheet], &[Company], &[User] and &[Slicer:B2], so a footer such as Page &[Page] of &[Pages] numbers the pages. You can also print gridlines, center the page, print in black and white, and print the titles of the live data blocks.
Print or save as PDF
- In the File menu, choose Print / PDF, or press Ctrl+P. The dialog sums up the page setup, with links to Page setup... and Print layout....
- Choose This sheet or All sheets, and name the file.
- Choose Download PDF. Excel (values) downloads the numbers as numbers instead.
The PDF uses what each sheet shows now. The logo, pivot tables, charts and KPI cards print as pictures, with the header and footer on every page.
Send it by email
Send, in the same File menu, emails the workbook as a PDF, an Excel file, or both. Enter the recipients in To (users or email addresses, or choose Add user...), a Subject, the format and the sheets. To send it regularly, choose Schedule: see Send workbooks on a schedule.
When to use it
Use a print layout for any sheet that leaves Business Central, on paper or as a PDF, such as a monthly board pack or a one-page sales dashboard.