Tabulys guide

Print, PDF & protection

Page layout, PDF export, sheet protection, comments and notes.

Page layout

The page layout settings control how the sheet prints and exports.

  1. Set the Orientation to Portrait or Landscape, and the paper Size such as A4 or Letter.
  2. Choose Margins (Normal, Wide, Narrow or custom).
  3. Set or clear the Print Area from the current selection.
  4. Use Print Titles to repeat header rows or columns on every page.
  5. Press Ctrl+P to open the Print window and see the pages as they will print.

Tip Open the Page Setup dialog from Print Titles or Margins for exact values, scaling and header/footer field codes.

Print sheets, the workbook or a selection

Print… — or Ctrl+P — opens the Print window, built around its preview: on the left, the page that will come out of the printer, laid out exactly like the PDF — same page breaks, repeated titles, header and footer — and shaped like the paper; on the right, what to print, the pages and the number of copies, and under them how many pages will be printed. Under the title the window says what will print: the names of the active sheets, the name of the workbook, or the sheet and its selected range.

  1. Use the Print… command or press Ctrl+P.
  2. Under Print what, choose Active sheets (the active sheet, or every tab you selected together with Ctrl or Shift), Entire workbook (every visible sheet that has something to print) or Selection (only the selected cells, instead of the print area).
  3. Choose All Pages, or Custom Range and type the pages in the field under it, for example 1-3,5: the numbers are those of the whole print, so in an entire workbook page 5 can be the first page of the second sheet.
  4. Set the number of copies with − and +, or type it.
  5. Browse the preview with the arrows under the page, the mouse wheel or Page Up and Page Down, and check Pages to print.
  6. Click Print: the browser's print dialog opens, where you choose the printer — leave its copies at 1, the document already contains yours.

Tip Orientation, paper size, margins and scaling belong to each sheet. When several sheets print together they are one print: the page numbers in headers and footers run on from sheet to sheet, as in Excel. Hidden sheets and empty sheets are not printed. Printing a selection does not change the print area. If the range contains no page, a warning says so and every page will be printed. Copies come out collated, up to 99. In the desktop app the PDF opens in the system's default viewer, and you print from there.

Headers, footers and live date/time

The Header/Footer tab of the Page Setup dialog sets a header and footer for the printout, including different content on even pages and on the first page.

  1. Open the Page Setup dialog and select the Header/Footer tab.
  2. Type the header and footer for odd/all pages, using the field codes &P (page), &N (total), &D (date), &T (time), &A (sheet) and &F (file).
  3. Tick 'Different odd and even pages' and fill the even header/footer to alternate them on even pages.
  4. Tick 'Different first page' and fill the first-page header/footer for a cover page.
  5. Export to PDF or press Ctrl+P: the right header is chosen per page and &D/&T show the current date and time.

Tip The date and time follow your language: a short date, and a time without seconds (12-hour with AM/PM in English, 24-hour elsewhere). Leaving an even or first-page box empty falls back to the odd/all-pages header.

Export to PDF

Where to find it
  • File › Save, Export, Print

The Export command, choosing PDF Document, exports the active sheet as a PDF, paginated like an Excel printout.

  1. Open the sheet you want to export.
  2. Use the Export command and choose PDF Document.
  3. The used area is laid out on the chosen paper; gridlines and row and column headings appear only when Print Gridlines and Print Headings are on.
  4. View the PDF in a new tab on the web, or save it via the system dialog on desktop.

Tip PDF export honours your page layout settings, including orientation, paper, margins, print area and scaling.

Protect a sheet or workbook

Protection sets what can be changed, at three levels: the locked cells of a sheet (Protect Sheet), the parts of a protected sheet that stay open, if need be only to whoever knows their password (Allow Edit Ranges), and the list of sheets in the workbook (Protect Workbook). It doesn't encrypt the file: to stop it being opened, use Encrypt with Password.

Passwords are checked and written as in Excel 365: a sheet, workbook or range protected in Excel stays protected here and asks for its own password, and a protection set here asks for it in Excel too. You type a password twice when you set it, and it is always asked for when you remove a protection that has one.

  1. Select the cells that must stay editable, then click Format and choose Unlock Cell: all the others stay locked.
  2. If a part must stay open only to whoever knows a password, define it with Allow Edit Ranges before you protect the sheet.
  3. Click Protect Sheet, set a password if you want one and tick what stays allowed for everyone.
  4. Click Protect Workbook to lock the structure, so sheets can't be added, deleted, renamed or moved.
  5. To remove a protection, click its button again; with a wrong password the window stays open for another try.

Tip A cell with Hidden formula (Format Cells, Ctrl+1, Protection tab) shows only its result on a protected sheet: the formula appears neither in the formula bar nor in the cell. If a protection uses an algorithm that can't be verified here, it can't be removed: the window says so, and it has to be removed with the application that applied it.

What sheet protection blocks

On a protected sheet every command follows the same rules as Excel 365, and the buttons, the menus, the shortcuts and the windows always give the same answer. A command the protection doesn't allow is grey, and clicking it tells you why; a gesture without a button, such as typing into a locked cell, shows Excel's message.

Content. Typing, clearing, pasting, filling, replacing, moving cells, array formulas and the tools that write into the sheet — Goal Seek, Solver, Consolidate, Data Analysis — are refused if even one target cell is locked and outside the editable ranges, and then no cell changes. On unlocked cells, without Format cells only the contents are pasted, and Clear All keeps the formatting.

Always off, whatever you tick: changing a cell's Locked or Hidden formula setting, merging and unmerging cells, data validation, grouping and ungrouping rows or columns, inserting or deleting cells by shifting the others, every table feature, turning the filter on or off, the sheet background, inserting sparklines, the editable ranges, Remove Duplicates, Subtotal, Data Table, Text to Columns and Flash Fill.

With their option. Format cells allows formats, styles, conditional formatting and existing sparklines, on locked cells too. Format columns and Format rows allow width and height, hiding and unhiding, and expanding and collapsing groups. Insert columns and Insert rows are enough on their own. Use AutoFilter allows choosing the criteria, and clearing and reapplying a filter that is already on.

With the option and unlocked cells. Delete rows and Delete columns work on whole rows or columns selected, and need every deleted cell to be unlocked; Sort needs the whole range unlocked, header included; Insert hyperlinks needs the cell unlocked, and a link can only be removed from an unlocked cell.

PivotTables, objects and scenarios. With Use PivotTable & PivotChart you can create PivotTables and change their fields and layout, but refreshing them, filtering their items and changing their source stay off, and Refresh All skips those on protected sheets. Without Edit objects no objects can be inserted, a locked object can't be selected — the click goes to the cell underneath — and notes can't be edited; comments can always be written. Without Edit scenarios, locked scenarios can't be changed or deleted and hidden ones don't appear, but adding one is still possible.

Hidden formulas. A cell with Hidden formula shows only its result: the formula doesn't appear in the formula bar, in the cell being edited, with Show Formulas, in the Watch Window or in Evaluate Formula, and FORMULATEXT returns #N/A.

  1. On the protected sheet, click the grey command you need: the window that opens says why it isn't available and how to make it available.
  2. If an option is missing, remove the protection with Protect Sheet and protect the sheet again with that option ticked among the actions all users may perform.
  3. If unlocked cells are needed, remove the protection, select the cells, choose Unlock Cell from the Format menu, and protect the sheet again.
  4. If the command is one of those that are always off, remove the protection, run the command and protect the sheet again.

Tip If the sheet lets only unlocked cells be selected, unlock the cells of the editable ranges too: an editable range makes a locked cell editable, but not selectable.

Encrypt a file with a password

  1. Click Encrypt with Password.
  2. Type a password, confirm it in the Confirm Password window and save: the file is encrypted the way Excel 365 encrypts it (AES-256) and can only be opened with that password, in Excel too.
  3. To open an encrypted file — from Open, from Aerarys, from the recent files or from a link — the Enter Password window appears straight away: type the password and click OK.
  4. While the file opens the window stays still and, if the wait grows longer, shows “Opening the file…”; with a wrong password it stays open with “Incorrect password. Try again.” and you can correct it there.
  5. To remove the encryption, run the command again and leave the password empty.

Tip If you lose the password it cannot be recovered, so store it safely. If you cancel the password request, the workbook you had before stays open. The recovery copy of an encrypted workbook is encrypted too, and asks for the password when it is restored. This differs from Protect Sheet, which only restricts editing and does not encrypt the file.

Comments and notes

Tabulys supports both Excel annotation systems: threaded Comments (with replies) and legacy Notes.

  1. Select the cell to annotate.
  2. Use New Comment for a threaded comment, or New Note for a legacy note.
  3. Type the text and confirm; the cell gets a corner indicator (purple for a comment, red for a note).
  4. Toggle Show Comments to open the side panel listing the annotations.
  5. Click a card in the panel to jump to its cell, reply, resolve or delete it.

Accessibility Checker

Find accessibility problems in your workbook — images or shapes missing alternative text, tables without a header row, merged cells, and hard-to-read low-contrast text — and fix them.

  1. Click Check Accessibility to open the panel.
  2. Problems are grouped by severity: Errors, Warnings and Tips.
  3. Click a card to jump to the cell or object it points to.
  4. On a missing-alternative-text card, choose Add alternative text to describe the image or shape for screen readers (a single undo).
  5. Click Recheck to scan the workbook again after making changes.

Tip A shape that already contains text is exempt from the alternative-text rule — only images and empty shapes are flagged.

Back to the guide

Productivity, made in Italy.

Bring the whole suite to your team — simple, secure and entirely yours.