Tabulys guide

File

The step-by-step guide to every command in the File menu of Tabulys.

Protect Sheet

Where to find it
  • File › Info › Protect

Locks the cells of the current sheet so their contents cannot be changed, and sets what everyone may still do. Use it once the figures are settled and the sheet is being passed around. The password is checked the way Excel checks it: a sheet protected in Excel stays protected here and asks for its own password, and one protected here asks for it in Excel too.

Some things stay off whatever you tick: merging or unmerging cells, data validation, tables, grouping rows and columns, and turning the filter on or off. Deleting rows or columns and sorting need their option and, on top of that, cells that are all unlocked. The full list, family by family, is in the topic “What sheet protection blocks” in the Print, PDF & protection section.

The two selection options decide where you can move. With only Select unlocked cells ticked, clicking a locked cell does nothing, the arrow keys skip locked cells, and Tab and Enter move to the next unlocked cell in reading order — Shift+Tab and Shift+Enter to the previous one — wrapping round from the last to the first, as in a form. With neither ticked there is no active cell, and the arrow keys scroll the sheet.

  1. If some cells must stay editable, select them, click Format and choose Unlock Cell.
  2. Click Protect Sheet.
  3. If you want a password, type it in Password (optional) and type it again in Reenter password to confirm, in the same window.
  4. Under Allow all users of this worksheet to:, tick what stays allowed among the fifteen options — Select locked cells, Select unlocked cells, Format cells, Format columns, Format rows, Insert columns, Insert rows, Insert hyperlinks, Delete columns, Delete rows, Sort, Use AutoFilter, Use PivotTable & PivotChart, Edit objects, Edit scenarios. The two selections go together: ticking Select locked cells also ticks Select unlocked cells, and clearing that one also clears the other.
  5. Click OK: the window stays open and still until the protection is written and, if the wait grows longer, shows a spinner with “Protecting…”.
  6. To remove the protection, click Protect Sheet again: without a password it comes off at once; with one, Unprotect Sheet opens and always asks for it. While the password is being checked the window stays still, with “Verifying the password…” if the wait grows longer; if it is wrong, the window stays open with “The password is incorrect. Try again.” and you can correct it there.

Tip While the sheet is protected, the commands the protection doesn't allow are grey: click one to read why and which option would make it available. A gesture without a button that the protection refuses, such as typing into a locked cell, shows Excel's message “The cell or chart you're trying to change is on a protected sheet”. Protection covers one sheet at a time, so repeat it on each sheet that has to be locked.

Protect Workbook

Where to find it
  • File › Info › Protect

Locks the structure of the workbook: while it is protected, sheets can't be added, deleted, renamed, moved, copied, hidden or unhidden, and their tab colour can't change. The contents of the cells are left as they are.

  1. Click Protect Workbook.
  2. In the Protect Structure and Windows window, leave Structure ticked.
  3. If you want a password, type it and type it again in Reenter password to confirm.
  4. Click OK: the sheet-tab menu items that would change the sheets turn grey, and the + button next to the tabs, when pressed, says why it doesn't add a sheet.
  5. To remove the protection, click Protect Workbook again and, if there is a password, enter it in Unprotect Workbook: if it is wrong, the window stays open for another try.

Tip A gesture on the tabs that the protection refuses — double-clicking to rename, dragging, Shift+F11 — shows Excel's message “Workbook is protected and can't be changed.” The window doesn't offer Windows because Excel 365 ignores it: a workbook protected for its windows only opens unprotected, here as in Excel. To stop the cells being edited as well, protect each sheet with Protect Sheet.

Encrypt with Password

Where to find it
  • File › Info › Protect

Locks the whole file behind a password, so it cannot be opened without one. Use it for a workbook whose contents must stay unread by whoever gets hold of the file. The file is encrypted the way Excel 365 encrypts it, so it opens with the same password in Excel too.

  1. Click Encrypt with Password.
  2. In the Encrypt Document with Password window, type the password and click OK.
  3. Type it again in Confirm Password: if the two passwords don't match, the first window opens again so you can retry.
  4. Click OK: the window stays still until the password is applied and, if the wait grows longer, shows a spinner with “Applying the password…”.
  5. Note the password down somewhere safe: from now on every save, including the automatic one, writes the file encrypted.

Tip There is no way into an encrypted file without its password, so a lost password means a lost workbook. To remove the encryption, run the command again and leave the password empty. An encrypted workbook opens in one window only — New Window is grey and tells you why — and does not join a shared editing session. The password you type and the key derived from it are erased from the program's memory as soon as they are no longer needed. Files encrypted by other programs that follow the Office standard open as well.

Allow Edit Ranges

Where to find it
  • File › Info › Protect

Marks the parts of a sheet that stay editable once the sheet is protected, so a locked sheet can keep a few cells open. You can give a range a password: whoever knows it can edit the range, everyone else can't. Use it for a form where only the answers are filled in.

  1. With the sheet unprotected, select the cells that must stay editable.
  2. Click Allow Edit Ranges: Allow Users to Edit Ranges opens.
  3. Click New…, check Title and Refers to cells and, if you want a password, type it in Range password (optional) and type it again in Reenter password to confirm: the characters stay hidden.
  4. Click OK to go back to the list; if you gave a password, until it is set the note at the bottom says “Setting the password of…” and New, Modify and Delete wait until it is done.
  5. To change a range that already has a password, choose it and click Modify…: leave both password boxes empty to keep it, type a new one to change it, or tick Remove the range password to remove it.
  6. Close the list and click Protect Sheet to put the protection in force.

Tip On a protected sheet, typing into a range with a password opens Unlock Range: with the right password the range stays unlocked while the workbook is open, and locks again when the sheet is protected anew or the range changes name or password. While the sheet is protected, Allow Edit Ranges is grey — as in Excel, ranges can't be added, changed or deleted — and clicking it tells you why.

Unshare Workbook

Where to find it
  • File › Info › Protect

Shows who can open this workbook and takes their access away, so you go back to working on the file alone. The window lists both those who will lose access and those who will keep it because a folder above the file is shared.

  1. Click Unshare Workbook.
  2. The window lists who can open the workbook and where each access comes from.
  3. Read what will be removed and what will stay.
  4. Confirm with Unshare.

Tip Access that comes from a shared folder cannot be removed here: the window names the folder, and that is where you remove it.

Back to the guide

Productivity, made in Italy.

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