Tabulys guide

Tools

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

Name Manager

Where to find it
  • Tools › Formulas › Names
Ctrl+F3

Lists every name defined in the workbook and what each one refers to, so you can check, change or remove them from one place.

  1. Click Name Manager.
  2. Find the name you want in the list.
  3. Edit what it refers to, or delete it.
  4. Close the dialog when you have finished.

Tip Deleting a name that formulas still use leaves them pointing at nothing, so check before you remove one. A name that cannot be accepted does not close the dialog: the reason appears below the fields. A name shown in red is one Excel would remove when opening the file: select it to read how to fix it.

Define Name

Where to find it
  • Tools › Formulas › Names
Ctrl+Alt+F3

Gives the selected cells a name, so a formula can say what it means instead of quoting cell addresses.

  1. Select the cells you want to name.
  2. Click Define Name.
  3. Type the name in the dialog that opens.
  4. Confirm to save it, then use the name in your formulas.

Tip Define Name opens its window; Name Manager lists everything you have defined.

Use in Formula

Where to find it
  • Tools › Formulas › Names

Puts one of the workbook's defined names into the formula you are writing, so you can choose it from a list instead of remembering how it is spelled.

  1. Start typing a formula in a cell, up to the point where the name belongs.
  2. Click Use in Formula.
  3. Click the name you want: it is inserted where you are typing.
  4. When the list is long, choose Paste Names to see all of them and pick from there.

Tip You can also click it without having typed anything: the selected cell starts a new formula with the name already in it.

Create from Selection

Where to find it
  • Tools › Formulas › Names
Ctrl+Shift+F3

Turns headings you have already typed into names. Select a block together with its row or column labels and Tabulys names the ranges after them.

  1. Select the cells together with the labels that describe them.
  2. Click Create from Selection.
  3. Set the options in the dialog that opens.
  4. Confirm to create the names.

Tip This names many ranges in one go; Define Name is the one to use for a single range.

Trace Precedents

Where to find it
  • Tools › Formulas › Formula Auditing

Draws arrows from a formula back to the cells it reads, so you can see where a suspicious result comes from.

  1. Click the cell holding the formula.
  2. Click Trace Precedents.
  3. Follow the arrows back to the cells the formula reads.
  4. Click Remove Arrows when you have finished.

Tip Trace Dependents, just below it, does the opposite: it shows what depends on a cell.

Trace Dependents

Where to find it
  • Tools › Formulas › Formula Auditing

Draws arrows from the selected cell out to every formula that reads it. Check this before you change or delete a value.

  1. Click the cell you are about to change.
  2. Click Trace Dependents.
  3. Follow the arrows to the formulas that will move with it.
  4. Click Remove Arrows when you have finished.

Tip The arrows are drawn over the sheet only; tracing alters nothing in the data.

Remove Arrows

Where to find it
  • Tools › Formulas › Formula Auditing

Clears the tracing arrows once you have followed them, so the sheet is readable again.

  1. Trace a formula first, so there are arrows on the sheet.
  2. Click Remove Arrows to clear them all.
  3. In the menu, the more selective clears follow the Remove Arrows item.

Tip Nothing is lost by clearing them: trace the formula again and the arrows come straight back.

Show Formulas

Where to find it
  • Tools › Formulas › Formula Auditing
Ctrl+`

Switches the sheet from showing results to showing the formulas that produce them, so a whole block of calculations can be read at a glance.

  1. Click Show Formulas.
  2. Read the formulas in the cells that normally show their results.
  3. Click Show Formulas again to bring the results back.

Tip The switch changes only what is displayed; the values and the formulas themselves are untouched. It applies to the sheet you are on: switch to another sheet and the button shows that sheet's state, and the file keeps each sheet's choice.

Error Checking

Where to find it
  • Tools › Formulas › Formula Auditing

Goes looking for the formulas that return an error and takes you through them one at a time. A formula that reads its own cell, directly or through other cells, is a circular reference: Tabulys does not calculate it and keeps its value, warns you the first time, and the status bar shows Circular References with the cell — click it to go there.

  1. Click Error Checking.
  2. Look at the first formula it reports.
  3. Correct it, or move on to the next one.
  4. Repeat until no formula is left to report.

Tip When the error is buried in a long formula, Evaluate Formula shows you which part goes wrong.

Evaluate Formula

Where to find it
  • Tools › Formulas › Formula Auditing

Works through a formula one step at a time, showing what each part turns into. The way to find which piece of a long formula is at fault.

  1. Click the cell holding the formula.
  2. Click Evaluate Formula.
  3. Step through the formula, watching each part become its value.
  4. Close the dialog when you have found the step at fault.

Tip Evaluating changes nothing: it only shows you what the formula is already doing.

Watch Window

Where to find it
  • Tools › Formulas › Formula Auditing

Keeps chosen cells in view while you work somewhere else, so you can watch a total react to edits made far away from it.

  1. Select the cells you want to keep an eye on.
  2. Click Watch Window.
  3. Add the selected cells to the window.
  4. Carry on editing; the window keeps their values in sight.

Tip Most useful when the cells you edit and the total they feed sit on different sheets. The watched cells are saved in the file, as in Excel: reopen the workbook — an Excel workbook too — and the window lists them again; adding or removing one marks the workbook as modified.

Calculation Options

Where to find it
  • Tools › Formulas › Calculation

Decides when formulas recalculate: on their own after every edit, or only when you ask. Worth changing when a large workbook becomes slow to type in.

  1. Click Calculation Options.
  2. Choose when the workbook should recalculate.
  3. Carry on editing; the choice applies to the whole workbook.

Tip With automatic recalculation switched off, results stay as they are until you click Calculate Now.

Calculate Now

Where to find it
  • Tools › Formulas › Calculation
F9

Recalculates every formula in the workbook, once. This is the button you need when automatic recalculation is switched off.

  1. Edit the values your formulas depend on.
  2. Click Calculate Now.
  3. Check that the results have refreshed.

Tip Calculate Sheet, next to it, is quicker when only the sheet you are on matters.

Calculate Sheet

Where to find it
  • Tools › Formulas › Calculation
Shift+F9

Recalculates the formulas of the current sheet only, and leaves the rest of the workbook as it is.

  1. Open the sheet whose results you want to refresh.
  2. Edit the values its formulas depend on.
  3. Click Calculate Sheet.

Tip If results on other sheets also depend on these changes, use Calculate Now instead.

Spelling

Where to find it
  • Tools › Proofing
F7

Goes through the text of the sheet and flags the words it does not recognise, with the rules of the dictionary of the interface language: inflected forms and compound words are not mistakes. Run it before a workbook leaves your hands.

  1. Open the sheet to check.
  2. Click Spelling.
  3. Deal with the flagged words one by one: change them, ignore them or add them to the dictionary.
  4. Carry on until the check reaches the end of the sheet: if the dictionary is missing or still loading, the window says so instead of saying the check is complete.
  5. With Personal Dictionary review the words you added, remove one, or import and export them as a text list.

Tip Only text is examined: numbers, dates and words written in capitals are left alone however they are written.

Thesaurus

Where to find it
  • Tools › Proofing
Shift+F7

Looks up another word with the same meaning as one of those in the active cell. When the cell holds a label of several words, you choose which one gets replaced.

  1. Select the cell holding the word you want to change.
  2. Click Thesaurus.
  3. If the cell holds several words, pick the one to replace from the strip.
  4. Select a synonym and click Insert.

Tip Look Up drills into the selected synonym without moving the word Insert will replace, and the bottom line always names the cell the box was opened on.

Workbook Statistics

Where to find it
  • Tools › Proofing

Shows what the workbook contains — sheets, cells with data, formulas and the objects placed on the sheets — with the current sheet and the whole workbook side by side.

  1. Click Workbook Statistics.
  2. Read each row all the way across: on the left the sheet you are on, on the right the whole workbook.
  3. A dash means the question does not apply to that scope.
  4. Click Close when you have finished.

Tip A kind of object missing from this sheet but present elsewhere still gets a row, with 0 on the left and the workbook total on the right: that is how you find where the weight of a workbook really sits.

Check Performance

Where to find it
  • Tools › Proofing

Lists what weighs on the workbook and what the calculation engine cannot skip: empty cells that still carry formatting, and formulas re-evaluated on every edit. Every row carries the measurement behind it.

  1. Click Check Performance.
  2. Read the rows: unused formatting is listed one sheet at a time, always-recalculated formulas one cell at a time.
  3. Select a sheet row and click Optimize to strip the formatting nobody claims.
  4. Select a formula row and click Go to cell to see it in the sheet.

Tip Optimize can be undone with Ctrl+Z, and before you press it the row says how many cells will visibly change.

Check Accessibility

Where to find it
  • Tools › Proofing

Inspects the workbook for what makes it hard to read for some people, and lists what it finds. Run it before you publish a file or send it on.

  1. Click Check Accessibility.
  2. Read the problems the check reports.
  3. Fix each one in the sheet.
  4. Click Check Accessibility again to close the pane.

Tip Run the check again after a big edit, because new content can bring new problems with it.

Translate

Where to find it
  • Tools › Proofing

Translates the text of the selected cells into another language and shows it next to the original, so you can read it before it goes into the sheet.

  1. Select the cells to translate (Ctrl+A for the whole sheet).
  2. Click Translate.
  3. Check the target language in the pill at the top right and change it if you need to.
  4. Read the translation next to the original, row by row.
  5. Click Replace to write it into the sheet.

Tip A single Undo puts every cell back: the replacement is one change. Formulas and numbers are never translated, and a cell that could not be translated says so and is left as it was.

New Comment

Where to find it
  • Tools › Comments and Notes
  • Shortcut menu
Ctrl+Shift+F2

Starts a conversation on the selected cell, or adds a reply if the cell already has one. Every comment carries who wrote it and when, and the Comments pane lists them all.

  1. Select the cell the conversation is about.
  2. Click New Comment, or press Ctrl+Shift+F2.
  3. Write your comment: the window shows who signs it and which cell it goes on.
  4. Press Ctrl+Enter or click Add.

Tip A cell holds either a note or a conversation: on a cell with a note New Comment is off, and Convert to Comments turns the note into a conversation.

Comment

Where to find it
  • Tools › Comments and Notes
  • Shortcut menu
Ctrl+Shift+F2

Opens a conversation on the selected cell: you write the first comment, and others can reply to it and mark it resolved. For a label that needs no answer, use a note instead.

  1. Click the cell the conversation is about.
  2. Click Comment.
  3. Write your comment in the window: Enter starts a new line.
  4. Press Ctrl+Enter or click Add.

Tip A purple speech bubble in the corner marks the cell; it turns grey once the conversation is resolved.

Previous Comment

Where to find it
  • Tools › Comments and Notes › Browse Comments

Steps back to the comment before the current one. Use it with Next Comment to walk a sheet's remarks in order.

  1. Click Previous Comment.
  2. Read the comment it brings you to.
  3. Click it again to keep moving back through the sheet.
  4. Use Next Comment to turn round.

Tip Show Comments opens the panel if you would rather see them all at once.

Next Comment

Where to find it
  • Tools › Comments and Notes › Browse Comments

Moves on to the comment after the current one. It is the forward half of going through a sheet's remarks one at a time.

  1. Click Next Comment.
  2. Read the comment it brings you to.
  3. Click it again for the one after that.
  4. Use Previous Comment to go back.

Tip Answer or delete each comment as you pass it, and the walk doubles as a way of clearing them.

Delete comment

Where to find it
  • Tools › Comments and Notes
  • Shortcut menu

Deletes the conversation on the active cell, replies included. Use it when a discussion no longer matters; Resolve keeps it on record instead.

  1. Select the cell with the purple speech bubble.
  2. Click Delete.
  3. Press Ctrl+Z if you change your mind.

Tip Delete is off on a cell with no conversation; to delete a single reply, use Delete on its card in the Comments pane.

Show Comments

Where to find it
  • Tools › Comments and Notes

Opens the pane that lists the sheet's conversations in reading order, each with its cell and date, and closes it again. Notes do not appear there: they stay on the sheet, next to their cells.

  1. Click Show Comments.
  2. Click a card to go to its cell; Reply, Edit, Resolve and Delete are on the card itself.
  3. Click Show Comments again to close the pane.

Tip Closing the pane hides it, it does not remove anything; Delete does that.

Notes

Where to find it
  • Tools › Comments and Notes › Notes
  • Shortcut menu
Shift+F2

Attaches a note to the selected cell: a yellow label written directly on the sheet, next to the cell, with no replies and no dates. Use notes for labels and reminders, and comments for anything other people should answer.

  1. Select the cell.
  2. Click Notes, or press Shift+F2: the note opens next to the cell.
  3. Type the text; Enter starts a new line.
  4. Press Esc or click elsewhere on the sheet to keep it.
  5. To remove a note, right-click the cell and choose Delete Note; Ctrl+Z brings it back.

Tip In the menu, the items that follow Notes show or hide the note of the cell, show all notes at once, and convert the sheet's notes into comments. A red triangle in the corner marks a cell with a note.

Show Changes

Where to find it
  • Tools › Comments and Notes

Lists the edits other people have made to the shared workbook: who made them, when, on which cell and from which value to which. The pane opens on the right and only has something to show on shared workbooks.

  1. Share the workbook, so the shared session opens by itself.
  2. Click Show Changes.
  3. Scroll the list: the most recent change is at the top.
  4. Click an entry to take the sheet to the cell it changed.

Tip A change that has already happened is neither accepted nor rejected: to go back, use Undo. When the workbook is not shared the pane still opens and says why it is empty.

Select Objects

Where to find it
  • Tools › Drawing and Macros › Drawing Tools

Puts the pointer back to picking things out, after a spell of drawing. Use it the moment you want to move or change something instead of adding more ink.

  1. Click Select Objects.
  2. Click the object or the ink you want to work with.
  3. Pick a pen again when you want to carry on drawing.

Tip While a pen is chosen, dragging leaves ink instead of selecting, which is exactly what this button undoes.

Lasso Select

Where to find it
  • Tools › Drawing and Macros › Drawing Tools

Circles ink strokes freehand so you can pick them up: the ones enclosed whole stay chosen, and you move or delete them together.

  1. Click Lasso Select.
  2. Draw a loop around the strokes you want to pick up.
  3. Drag inside the box to move them, or press Delete to remove them.

Tip Only what falls fully inside counts: a stroke sticking out of the loop is left where it is.

Eraser

Where to find it
  • Tools › Drawing and Macros › Drawing Tools

Rubs out ink you have drawn on the sheet. Reach for it to clean up a stroke rather than start the whole drawing again.

  1. Click Eraser.
  2. Drag over the ink you want to remove.
  3. Click Select Objects when you have finished.

Tip The eraser takes away ink only: the cells underneath and their contents are untouched.

Pen: Silver

Where to find it
  • Tools › Drawing and Macros › Drawing Tools

Draws a silver line over the sheet. A quiet colour, for a mark that shows without competing with the figures.

  1. Click Pen: Silver.
  2. Drag across the sheet to draw.
  3. Click Select Objects when you have finished.

Tip Use the Eraser to take a stroke back out again.

Pen: Black

Where to find it
  • Tools › Drawing and Macros › Drawing Tools

Draws a black line over the sheet. It is the plainest of the pens, for annotating without bringing colour into it.

  1. Click Pen: Black.
  2. Drag across the sheet to draw.
  3. Click Select Objects when you have finished.

Tip The other pens draw the same stroke in a different colour.

Pen: Red

Where to find it
  • Tools › Drawing and Macros › Drawing Tools

Draws a red line over the sheet. Red reads as a correction, so keep it for what needs attention.

  1. Click Pen: Red.
  2. Drag across the sheet to draw.
  3. Click Select Objects when you have finished.

Tip Ink lies over the grid, so marking a figure in red leaves the value itself as it was.

Pen: Galaxy

Where to find it
  • Tools › Drawing and Macros › Drawing Tools

Draws a line that shifts through several colours as it goes. Use it where a mark should stand out rather than blend in.

  1. Click Pen: Galaxy.
  2. Drag across the sheet to draw.
  3. Click Select Objects when you have finished.

Tip The colours come with the pen, so there is nothing to set before you start drawing.

Pencil

Where to find it
  • Tools › Drawing and Macros › Drawing Tools

Draws with a grainier, pencil-like stroke rather than the clean line of a pen. Use it for rough marks and sketching.

  1. Click Pencil.
  2. Drag across the sheet to draw.
  3. Click Select Objects when you have finished.

Tip Pencil marks come out with the Eraser just as pen ink does.

Highlighter: Yellow

Where to find it
  • Tools › Drawing and Macros › Drawing Tools

Draws a see-through yellow band over the sheet, so what is underneath still reads. Use it to pick out a row or a figure rather than to write.

  1. Click Highlighter: Yellow.
  2. Drag across the cells you want to pick out.
  3. Click Select Objects when you have finished.

Tip Because the band is translucent, the values you draw over stay readable.

Pen: Blue

Where to find it
  • Tools › Drawing and Macros › Drawing Tools

Draws a blue line over the sheet. A useful second colour when black is already carrying a meaning of its own.

  1. Click Pen: Blue.
  2. Drag across the sheet to draw.
  3. Click Select Objects when you have finished.

Tip Changing pen part way through is just a click: the strokes already drawn keep their own colour.

Pen: Green

Where to find it
  • Tools › Drawing and Macros › Drawing Tools

Draws a green line over the sheet. A calm colour for ticks and approvals, next to the red kept for corrections.

  1. Click Pen: Green.
  2. Drag across the sheet to draw.
  3. Click Select Objects when you have finished.

Tip Give each colour one meaning and a marked-up sheet reads at a glance.

Action Pen

Where to find it
  • Tools › Drawing and Macros › Drawing Tools

Turns what you write by hand into a command, so you can act on the sheet directly. Reach for it when you are working with a pen rather than a mouse.

  1. Click Action Pen.
  2. Write the command you want by hand on the sheet.
  3. Wait while the writing is read and carried out.
  4. Click Select Objects to go back to the pointer.

Tip If you only want ink rather than an action, pick one of the pens instead.

Add Pen

Where to find it
  • Tools › Drawing and Macros › Drawing Tools

Creates a pen of your own — type, colour and thickness — and keeps it beside the ones you already have. The pens in the strip have a fixed colour and thickness: a thinner red pen, or a narrower highlighter, can only come from here.

  1. Click Add.
  2. Choose a type, a colour and a thickness: the stroke next to each choice is the mark that pen will leave.
  3. Click + to keep more than one pen, or Delete to discard the one shown.
  4. Click Use to close the window and draw with it.

Tip Your pens belong to you, not to the workbook: a file you send carries the ink you drew, never the pens you drew it with.

Ink to Shape

Where to find it
  • Tools › Drawing and Macros

Turns freehand strokes into precise geometric shapes. Merydion proposes the shape each stroke most resembles and draws it over the stroke, so you can judge before converting.

  1. Draw one or more strokes on the sheet with a pen.
  2. Click Ink to Shape.
  3. Look at the preview: the stroke sits under the proposed shape.
  4. Check the strokes to convert; if the proposed shape is not the right one, pick another from the other shapes.
  5. Click Convert.

Tip Strokes Merydion is unsure about are not checked for you, and the window says why. An open stroke, such as a line, does not become a shape. A single Undo brings back all the conversions at once.

Ink Equation

Where to find it
  • Tools › Drawing and Macros

Opens a window where you write the formula by hand, with the mouse or the pen, and watch it become a real equation. The preview at the top shows exactly what will go into the sheet.

  1. Click Ink Equation.
  2. Write the formula on the blank sheet of the window, one symbol at a time.
  3. Check the preview at the top: that is the formula that will be inserted.
  4. If a symbol was read wrong, press Correct, touch it and pick another reading.
  5. Click Insert to put it in the sheet, or Edit… to refine it in the equation editor.

Tip Symbols read with low confidence mark themselves: those are the ones to check with Correct. Undo stroke removes the last mark without clearing the rest.

Ink Replay

Where to find it
  • Tools › Drawing and Macros

Watches the sheet's ink strokes being drawn again, one after another, in the order you made them. It is there to retrace an annotation: what was marked first and what came after. It changes nothing in the sheet.

  1. Draw one or more strokes on the sheet with a pen.
  2. Click Ink Replay.
  3. Watch the strokes reappear in the order you drew them.
  4. Use the button to pause and resume, and drag the bar to go back to the part you want.
  5. Close the window: the sheet is unchanged.

Tip The space bar pauses and resumes, the arrows move by a second, Home starts over. If you picked strokes with Lasso Select only those are replayed, and the line under the stage says which. On a sheet with no ink the window still opens and tells you so.

Hide Ink

Where to find it
  • Tools › Drawing and Macros

Puts the pen strokes drawn on the workbook out of sight without deleting them. The choice belongs to the workbook, so it travels with the file and is still in force when you open it again.

  1. Click Hide Ink.
  2. The strokes on every sheet stop being drawn; the button stays pressed.
  3. Click it again to bring them back.

Tip Picking up a pen, the eraser or the lasso brings the ink back on its own: asking to draw is asking to see.

Macros

Where to find it
  • Tools › Drawing and Macros

A macro records the formatting commands you apply to cells — font, colours, borders, alignment, number format, cell styles — and repeats them on the cells selected when you run it. It is not a program you write: it is the sequence you have just performed, kept so you can perform it again.

  1. In the menu, open the Macros submenu and choose Record Macro.
  2. Format the cells the way you want them. Choosing the cells is not recorded, and neither is what you type into them: a macro always works on the current selection.
  3. Choose Stop Recording from the same submenu. The macro is saved and the list opens on it.
  4. Select other cells, open View Macros from the same submenu, choose the macro and click Run.

Tip Running a macro leaves a single Undo step, however many commands it contains. Steps… shows exactly what it will do before you run it, and Edit… gives it a name and a shortcut (Ctrl or Alt plus a letter or a digit). Macros belong to you, not to the workbook: they stay on this account and do not travel inside the file you send.

Back to the guide

Productivity, made in Italy.

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