Articles on: Tutorials

Setting PDF Page layout from your XLSX/ODS Template

The "Page Break View" in Microsoft Excel and LibreOffice is a feature that allows you to see and manipulate the page breaks within your worksheet. It provides a visual representation of how your Excel data is distributed across pages when the document is generated with Carbone: the PDF will inherit the template page layout.


Here's how you can access the Page Break View:


Define page layout in Microsoft Excel


  1. Open your Excel workbook: Open the Excel template that you're working on.
  2. Go to the "View" tab: In the Excel ribbon, navigate to the "View" tab.
  3. Click on "Page Break Preview": Look for the "Page Break Preview" button and click on it. Alternatively, in some versions of Excel, it might be labeled as "Page Layout."
  4. Adjust page breaks: In Page Break Preview, you'll see your data divided into pages, and you can see where page breaks are currently located. Adjust the page breaks by dragging them with the mouse.
  5. Exit Page Break Preview: Once you've made the necessary adjustments, you can exit the Page Break Preview by clicking on "Normal" or another relevant view in the View tab.
  6. Check your document layout: Generate a PDF with Carbone



MS Excel - Page Break View


Define page layout in LibreOffice


  1. Open your LibreOffice Calc document: Launch LibreOffice Calc and open the spreadsheet template you want to work on.
  2. Go to the "View" menu: In the menu bar at the top of the LibreOffice window, click on "View."
  3. Select "Page Break Preview": In the "View" menu, hover over "Page Break Preview." This option might also be labeled as "Preview" or "Print Preview" in some versions.
  4. Adjust page breaks: In the Page Break Preview, you'll see how your data is divided into pages. You can adjust the page breaks by dragging them with the mouse.
  5. Exit Page Break Preview: Once you've made the necessary adjustments, you can exit the Page Break Preview by returning to the "Normal" view or a similar option in the "View" menu.
  6. Check your document layout: Generate a PDF with Carbone


LibreOffice - Page Break View

Updated on: 02/07/2024

Was this article helpful?

Share your feedback

Cancel

Thank you!