Skip to content
Bitta Apps

Chapter 4 of 4Page 2 of 4

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.

  1. On the Insert tab, choose Image.
  2. 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.
  3. 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.
  4. Choose Insert, then pick the file: PNG, JPEG or GIF, up to 2 MB.
Insert image dialog with alternative text, Fit, top-left cell A1, two rows by two columns and Show a title bar turned off

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.

  1. Choose Use selection for the print area.
  2. Choose the orientation, the paper (A4, Letter, Legal or A3) and the margins.
  3. Under scaling, fit all columns on one page, fit to a number of pages wide, or adjust to a percentage of normal size.
  4. Set the rows to repeat at the top of every page, for example rows 1:2, and the columns to repeat at the left.
  5. Build the header and footer from tokens, then choose Save.
Print layout dialog with the print area, landscape Letter paper, narrow margins, fit all columns on one page, rows 1:2 repeated, header and footer tokens

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.

  1. 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....
  2. Choose This sheet or All sheets, and name the file.
  3. Choose Download PDF. Excel (values) downloads the numbers as numbers instead.
Print or PDF dialog with the page setup summary, This sheet, the file name and the Download PDF and Excel values buttons

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.

Downloaded PDF page in landscape with the logo, the pivot tables, the charts and the KPI card, the company name on top and the page number below

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.

Next step

Ready to try Bitta Sheets?