Tabulys guide

Insert

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

Insert Cells

Where to find it
  • Insert › Cells and Sheets
  • Shortcut menu

Makes room in the middle of a sheet by adding cells and pushing the existing ones aside. In the menu, the other things you can insert follow the Insert item.

  1. Select the place where the new cells should go.
  2. Click Insert: the cells shift down, or right if the selection is taller than it is wide.
  3. To choose the direction yourself, or to insert entire rows or columns, choose Insert Cells… among the items that follow Insert in the menu, or press Ctrl+Shift++ or right-click and choose Insert….

Tip Select three cells before you click and you insert three, so you rarely need to repeat the command.

PivotTable builder

Where to find it
  • Insert › Tables › PivotTable
  • Pane › Table

Summarises a large range without a single formula. The window composes the table with you — tick the fields, drag them into Filters, Columns, Rows and Values — while the preview beside it shows the table you are about to create.

  1. Select a cell inside the data, or the whole range you want to summarise.
  2. Click PivotTable: the window opens with a first summary already composed, and the line under the title states the range, the records and the fields it read.
  3. Tick a field to add it, or drag it into Filters, Columns, Rows or Values; the arrow beside a placed field moves it, reorders it, removes it, or changes Summarize Values By.
  4. Watch the preview on the right — it is the table that will be created — and read the help line under it: it explains whatever has the focus, writes a value field as the formula it computes, such as SUM(Sales), and warns you when something deserves it.
  5. Under Place in choose New Worksheet, or Existing Worksheet and a Location, then click Create.

Tip Suggested composes the table again from the summaries the engine proposes, and Layout and Grand totals decide its shape. Nothing is settled: on the sheet the field list opens by itself, ready for you to carry on.

Summarize with PivotTable

Where to find it
  • Insert › Tables › PivotTable
  • Pane › Table

Builds a PivotTable from the data in this table, to total and group the rows instead of reading them one by one.

  1. Click any cell inside the table.
  2. Click Summarize.
  3. A dialog opens where you set the options.
  4. Confirm, and the PivotTable is built from the table's data.

Tip The table itself is untouched: the PivotTable is a second view of the same rows.

Recommended PivotTables

Where to find it
  • Insert › Tables › PivotTable

Shows a list of ready-made summaries for the data you selected, each with a preview of the table you would get. Pick the one that answers your question instead of building the PivotTable from scratch.

  1. Select a cell inside the data range, or the whole range.
  2. Click Recommended.
  3. Scroll the list on the left: for each proposal the preview on the right shows the table that will be created.
  4. Pick the proposal you want and click OK.
  5. The PivotTable is created on a new sheet, ready to adjust with the field list.

Tip A long preview is shortened and says so: the created table will have every row. If none of the proposals convince you, cancel and use PivotTable to build one field by field.

PivotTable field list

Where to find it
  • Insert › Tables › PivotTable
  • Pane › PivotTable

Brings back the list of fields for the PivotTable you are working on, so you can rearrange the summary. Reach for it when the list is not on screen.

  1. Click inside the PivotTable you want to change.
  2. Click Field List.
  3. Drag the fields into rows, columns and values.
  4. Watch the PivotTable rebuild itself as you go.

Tip The button stays greyed out until the cursor is inside a PivotTable, so create one first.

Field List

Where to find it
  • Insert › Tables › PivotTable
  • Pane › PivotTable

Shows or hides the PivotTable's Fields pane, where you choose which fields go in rows, columns, values and filters.

  1. Click any cell inside the PivotTable.
  2. Click Field List.
  3. Drag fields between the pane's Filters, Columns, Rows and Values areas.
  4. Click Field List again to close the pane.

Tip It is the same Field List command wherever you find it: there is only one pane.

Table

Where to find it
  • Insert › Tables
Ctrl+L

Turns a range into a proper table of rows and columns, so the block can be treated as one object rather than as loose cells.

  1. Select the cells you want to turn into a table.
  2. Click Table.
  3. Check the range in the dialog that opens, then confirm.
  4. Click any cell inside the table to work on it.

Tip A table is also the tidiest starting point for a PivotTable or a slicer.

Form

Where to find it
  • Insert › Tables

Fills a table one record at a time, in a window with one field per column — and finds a record by describing what it must contain.

  1. Click any cell inside the table.
  2. Click Forms.
  3. Type the values, then use the arrows beside the counter to move from one record to the next.
  4. Click New to start a record, Criteria to look for one.

Tip In Criteria a bare word means “begins with”, >100 compares numbers, and = on its own finds the empty cells.

Recommended Charts

Where to find it
  • Insert › Charts

Looks at the data you selected and offers the charts that suit it, each drawn with your own numbers and with a line saying why it is suggested.

  1. Select the data you want to chart, including its headings.
  2. Click Recommended.
  3. Pick a chart from the gallery and read why it is suggested.
  4. Click OK to place it on the sheet.

Tip Select a single cell and the whole surrounding block of data is used, so you rarely need to select the range by hand. If the selected cells can't make this chart, nothing is inserted: a window tells you what is missing and how to fix the selection.

Column or Bar Chart

Where to find it
  • Insert › Charts

The workhorse chart for comparing values across categories: vertical columns, or horizontal bars when the labels are long.

  1. Select the data you want to chart, including its headings.
  2. In the menu, Column or Bar Chart opens a submenu of its types.
  3. Pick the variety you want from the choices shown.
  4. Drag the chart into place on the sheet.

Tip If the selected cells can't make this chart, nothing is inserted: a window tells you what is missing and how to fix the selection.

Line or Area Chart

Where to find it
  • Insert › Charts

Plots values against a period so the trend is visible: a line for the shape of the change, an area when the size of the total matters too.

  1. Select the data, with the periods in one column and the values beside them.
  2. In the menu, Line or Area Chart opens a submenu of its types.
  3. Pick the variety you want from the choices shown.
  4. Drag the chart into place on the sheet.

Tip For the same idea inside a single cell, a sparkline takes up far less room. If the selected cells can't make this chart, nothing is inserted: a window tells you what is missing and how to fix the selection.

Pie or Doughnut Chart

Where to find it
  • Insert › Charts

Shows how one total splits up, each value a slice of the whole.

  1. Select the values that make up the total, with their labels.
  2. In the menu, Pie or Doughnut Chart opens a submenu of its types.
  3. Pick the variety you want from the choices shown.
  4. Drag the chart into place on the sheet.

Tip Slices are hard to compare past a handful; with many values a column chart says more. If the selected cells can't make this chart, nothing is inserted: a window tells you what is missing and how to fix the selection.

Scatter Chart

Where to find it
  • Insert › Charts

Plots pairs of values as points, so you can see whether two measurements move together.

  1. Select two columns of numbers, one for each axis.
  2. In the menu, Scatter Chart opens a submenu of its types.
  3. Pick the variety you want from the choices shown.
  4. Drag the chart into place on the sheet.

Tip Both columns must hold numbers; a column of labels belongs on a column chart instead. If the selected cells can't make this chart, nothing is inserted: a window tells you what is missing and how to fix the selection.

Hierarchy Chart

Where to find it
  • Insert › Charts › Hierarchy, Waterfall, Statistic, Map

Shows data that nests, categories inside categories, as boxes inside boxes, with the size of each box set by its value.

  1. Select the data, with each level of the hierarchy in its own column.
  2. In the menu, the types follow the Hierarchy Chart item.
  3. Pick the variety you want from the choices shown.
  4. Drag the chart into place on the sheet.

Tip It only reads well when the parts genuinely add up to their container; otherwise a column chart is clearer. If the selected cells can't make this chart, nothing is inserted: a window tells you what is missing and how to fix the selection.

Waterfall Chart

Where to find it
  • Insert › Charts › Hierarchy, Waterfall, Statistic, Map

Shows how a starting value becomes a final one, one increase or decrease at a time. The usual choice for a budget or a margin explained step by step.

  1. Select the steps in the order you want them read.
  2. In the menu, the types follow the Waterfall Chart item.
  3. Pick the variety you want from the choices shown.
  4. Drag the chart into place on the sheet.

Tip The order of your rows is the order of the steps, so sort the data before you chart it. If the selected cells can't make this chart, nothing is inserted: a window tells you what is missing and how to fix the selection.

Filled Map

Where to find it
  • Insert › Charts › Hierarchy, Waterfall, Statistic, Map

Shows your values on a geographic map: every region is coloured according to its number, so you see at a glance where the value is high and where it is low. The names are recognised offline, from the geography that ships with the application.

  1. Put the region names in one column and the numbers beside them.
  2. Click Maps.
  3. Read the summary: it tells you how many rows were recognised, and names the ones that were not.
  4. Choose the map area, the projection, the labels and the colours while you watch the map change.
  5. Click Insert.

Tip Names work in every interface language, and so do country codes: Italy, Italien, IT and ITA all reach the same country. If the selected cells can't make this chart, nothing is inserted: a window tells you what is missing and how to fix the selection.

PivotChart

Where to find it
  • Insert › Charts

Charts the summary a PivotTable produces, and follows it: rearrange the fields and the chart redraws with them.

  1. Click inside the PivotTable you want to chart.
  2. Click PivotChart.
  3. Pick the chart type you want.
  4. Drag the chart into place on the sheet.

Tip No PivotTable yet? Build one first with PivotTable. If the selected cells can't make this chart, nothing is inserted: a window tells you what is missing and how to fix the selection.

PivotChart

Where to find it
  • Insert › Charts

Creates a chart linked to the PivotTable you are in: it charts the summary and follows it when you rearrange the fields.

  1. Click any cell inside the PivotTable you want to chart.
  2. Click PivotChart.
  3. Pick the chart type you want.
  4. Drag the chart into place on the sheet.

Tip It is the same PivotChart command wherever you find it.

Line Sparkline

Where to find it
  • Insert › Sparklines and Filters › Sparklines

A miniature line chart living inside a single cell, next to the numbers it describes. Use it to show a trend without giving a whole chart the space.

  1. Select the cells holding the row of values.
  2. Click Line Sparkline.
  3. Choose the cell where the sparkline should appear.
  4. Confirm to draw it.

Tip Widen the column and raise the row a little: a sparkline is only as readable as the cell holding it.

Column Sparkline

Where to find it
  • Insert › Sparklines and Filters › Sparklines

A miniature bar chart inside one cell. Better than a line when the values are separate measurements rather than a continuous trend.

  1. Select the cells holding the row of values.
  2. Click Column Sparkline.
  3. Choose the cell where the sparkline should appear.
  4. Confirm to draw it.

Tip Keep the sparkline beside its numbers: the two are meant to be read together.

Win/Loss Sparkline

Where to find it
  • Insert › Sparklines and Filters › Sparklines

A miniature chart that shows only the direction of each value, above or below the line, and ignores how big it is. Good for a run of results.

  1. Select the cells holding the row of values.
  2. Click Win/Loss Sparkline.
  3. Choose the cell where the sparkline should appear.
  4. Confirm to draw it.

Tip Use it when only the sign of each value matters; Column Sparkline shows the size as well.

Slicer

Where to find it
  • Insert › Sparklines and Filters
  • Pane › Table

Adds a panel of buttons that filter the data as you click them, so anyone can narrow the view without opening a filter menu.

  1. Click inside the table or PivotTable you want to filter.
  2. Click Slicer.
  3. Choose the field to filter by in the dialog that opens.
  4. Click the buttons in the slicer to narrow the data.

Tip The slicer shows which values are active, so the filter in force stays visible on the sheet.

Insert Slicer

Where to find it
  • Insert › Sparklines and Filters
  • Pane › Table

Adds a panel of buttons beside the table; clicking one filters the table to that value. It is the friendliest filter for a table other people will use.

  1. Click any cell inside the table.
  2. Click Slicer.
  3. A dialog opens where you choose what the slicer filters on.
  4. Click a button on the slicer to filter the table to that value.

Tip Select the slicer afterwards for its layout and style choices.

Timeline

Where to find it
  • Insert › Sparklines and Filters

A slider for dates: drag along it to narrow the data to a period, instead of picking dates from a list.

  1. Click inside the table or PivotTable you want to filter.
  2. Click Timeline.
  3. Choose the date field in the dialog that opens.
  4. Drag along the bar to pick the period you want.

Tip It needs a field of real dates; to filter by anything else, use a slicer.

Formula Builder (Insert Function)

Where to find it
  • Insert › Functions
Shift+F3

Opens the Formula Builder, where you build a formula from the whole function library or understand the one already in the cell. Each argument has its own box, and its value and the result update as you type.

  1. Click the cell where you want the formula, or one that already holds a formula.
  2. Click fx next to the formula bar, or click Insert Function.
  3. Search for a function by name or by what it does, or pick a category, then press Enter to add it.
  4. Fill in the argument boxes: each one shows its value, and the result below updates as you type.
  5. Check the Structure and Suggestions tabs, then click Insert (Update if the cell already had a formula).

Tip Press F4 to switch a reference between relative and absolute ($A$1). When Suggestions finds a problem, Fix corrects the whole formula in one click, and Ctrl+Z takes it back.

AutoSum

Where to find it
  • Insert › Functions
  • Toolbar
Alt+=

The fastest way to total a column or a row: Tabulys looks at the cells above or to the left of the selection and writes the sum for you.

  1. Click the empty cell below a column of numbers, or to the right of a row.
  2. Click AutoSum.
  3. Check the range Tabulys proposes and correct it if it is not the one you meant.
  4. Confirm to write the formula into the cell.

Tip Click the arrow next to AutoSum to choose another summary instead of a plain sum.

Sum

Where to find it
  • Insert › Functions
  • Toolbar
Alt+=

Writes a total for the run of figures above the selected cell, or to its left. It is the quickest way to close off a column or a row of numbers.

  1. Select the empty cell just below a column of figures, or just to the right of a row.
  2. Click Sum.
  3. Check the range it has picked up, and correct it if it has guessed short.
  4. Confirm the formula to write the total into the cell.

Tip Click the arrow next to Sum for the other quick calculations over the same run of cells.

Recently Used

Where to find it
  • Insert › Functions › By Category

A short list of the functions you have reached for lately, so the one you keep using is a click away.

  1. Click the cell where you want the result.
  2. Click Recently Used: the Formula Builder opens on that category.
  3. Choose a function from the list.
  4. Fill in its arguments, then confirm.

Tip The list is built from what you actually use, so it stays empty until you have used a function.

Financial

Where to find it
  • Insert › Functions › By Category

The financial corner of the library: functions for loans, interest and investments.

  1. Click the cell where you want the result.
  2. Click Financial: the Formula Builder opens on that category.
  3. Choose the function you need.
  4. Fill in its arguments, then confirm.

Tip If the function you want is not listed here, Insert Function reaches the whole library.

Logical

Where to find it
  • Insert › Functions › By Category

Functions that test a condition and answer true or false. Reach for these when a cell should react to the data instead of holding a fixed value.

  1. Click the cell where you want the result.
  2. Click Logical: the Formula Builder opens on that category.
  3. Choose the function you need.
  4. Fill in its arguments, then confirm.

Tip A logical function is often used inside another formula, to decide what the rest of it works on.

Text

Where to find it
  • Insert › Functions › By Category

Functions that cut, join, tidy up or change the case of text held in cells. Useful when data arrives in the wrong shape.

  1. Click the cell where you want the result.
  2. Click Text: the Formula Builder opens on that category.
  3. Choose the function you need.
  4. Fill in its arguments, then confirm.

Tip The result is a new value in the formula cell; the text it reads is left exactly as it was.

Date & Time

Where to find it
  • Insert › Functions › By Category

Functions for dates and times, from today's date and the current time to the calculations you build on them.

  1. Click the cell where you want the result.
  2. Click Date & Time: the Formula Builder opens on that category.
  3. Choose the function you need.
  4. Fill in its arguments, then confirm.

Tip A date a formula works out only moves on when the workbook recalculates, which Calculation Options governs.

Lookup & Reference

Where to find it
  • Insert › Functions › By Category

Functions that search a table for a matching value, or that point at a cell by its position rather than by its address.

  1. Click the cell where you want the result.
  2. Click Lookup & Reference: the Formula Builder opens on that category.
  3. Choose the function you need.
  4. Fill in its arguments, then confirm.

Tip Naming the range you search, with Define Name, makes these formulas far easier to read later.

Math & Trig

Where to find it
  • Insert › Functions › By Category

Arithmetic, rounding and trigonometry, from the everyday sums to the specialised ones.

  1. Click the cell where you want the result.
  2. Click Math & Trig: the Formula Builder opens on that category.
  3. Choose the function you need.
  4. Fill in its arguments, then confirm.

Tip For a plain total of a column, AutoSum is quicker than picking a function from here.

More Functions

Where to find it
  • Insert › Functions › By Category

The categories the other buttons do not cover, so nothing in the library is out of reach.

  1. Click the cell where you want the result.
  2. Click More Functions: the Formula Builder opens on that category.
  3. Choose a category, then the function you need.
  4. Fill in its arguments, then confirm.

Tip If you are not sure which category holds a function, Insert Function shows them all in one place.

Insert Python

Where to find it
  • Insert › Functions › Python

Writes a Python formula in the cell. The code is written in a window that shows, at every keystroke, the value the cell will take — or the error, with the line it happened on. The code reads the sheet with xl("A1:C9"), and the last value it computes is what the cell shows.

  1. Select the cell that will hold the formula.
  2. Click Insert Python.
  3. Write the code. Enter adds a line, Tab indents, and xl("A1:C9") reads the sheet.
  4. Read the Result band: it shows the value the cell will take, or the error with its line.
  5. Click Insert. The cell holds =PY("…") and recalculates like any other formula.

Tip Run the command again on the same cell to reopen the code and change it. The Python available here is a declared subset: there are no libraries to import, and whatever is missing says so instead of failing silently.

Python Editor

Where to find it
  • Insert › Functions › Python

Shows the Python code a workbook carries — one fragment per cell — and lets you read and change it. Tabulys does not run Python: the code travels with the file, so what you write here is what runs where the workbook is opened with a Python engine.

  1. Click Editor.
  2. Pick a fragment from the list on the left: each one names the sheet and the cell that holds it.
  3. Write in the code area. Enter starts a new line and keeps the indentation; Tab indents.
  4. Read the strip under the editor: it names the first thing that does not add up, or the cells the code reads.
  5. Press Apply, or Ctrl+Enter, to write the changed code back into the cells.

Tip The list holds only the Python code the workbook already carries: those cells come from a workbook authored in Excel, and Tabulys reads, edits and saves them without running them.

Python initialization

Where to find it
  • Insert › Functions › Python
  1. Click Initialization.
  2. Write the code that opens the workbook's Python session: the imports and the helper functions that every Python formula will take for granted.
  3. Read the strip under the code: it names the first error with its line and its column, and clicking it takes the cursor there.
  4. Look at the "What the formulas find" column: it lists the names your code leaves ready for the formulas.
  5. Click Save. The code travels with the file.

Reset Calculation

Where to find it
  • Insert › Functions › Python

Throws away the calculation session — the dependency graph, the memoised formulas and the values stored in formula cells — and starts again from the formula text. Unlike Calculate Now, which refreshes what is out of date, Reset trusts nothing that was already there. It is the command for a workbook that came from somewhere else, whose stored values nobody has ever checked.

  1. Click Reset.
  2. Read the survey: how many formula cells there are, how many carry a stored value, and how many of those values disagree with what the formula computes now.
  3. Look at the list: each row names the sheet and the cell and shows the stored value next to the computed one.
  4. Choose Everything to clear and recalculate, or Outputs only to clear and wait for the next calculation.
  5. Click Reset.

Tip Reset cannot be undone with Ctrl+Z: like Calculate Now it recalculates derived values. Volatile formulas such as RAND() are counted separately and never as disagreeing — they change every time by design. In the menu, the two choices follow the Reset item directly.

Pictures

Where to find it
  • Insert › Illustrations

Puts an image from this device, from Aerarys files or from your Photos library onto the sheet: a logo, a photo, a diagram produced somewhere else.

  1. Click roughly where you want the picture to sit.
  2. Click Pictures.
  3. In the dialog, choose the source in the left column: This device, Aerarys or Photos.
  4. Browse the folders and click the picture you want to select it.
  5. Click Insert (or double-click the picture).
  6. To insert more than one picture, click each one you want: the dialog counts them at the bottom, and they go in in the order you picked them.
  7. Pictures inserted together are offset from one another, so none hides the others.
  8. Drag the picture into place, or drag a corner to resize it.

Tip In the menu, Pictures opens a submenu with the other places an image can come from.

Shapes

Where to find it
  • Insert › Illustrations

Draws lines, arrows and geometric figures over the sheet: an arrow between two blocks, a box around a result, a pointer to a number that needs explaining.

  1. Click Shapes.
  2. Pick the shape you want from the choices shown.
  3. Drag on the sheet to draw it at the size you want.
  4. Drag the shape itself to move it.

Tip Shapes float above the grid, so the cells underneath keep their values and their formatting.

Icons

Where to find it
  • Insert › Illustrations

Inserts a ready-made symbol from the built-in collection, handy for marking a status or heading a column without drawing anything yourself.

  1. Click roughly where you want the icon.
  2. Click Icons.
  3. The gallery opens with every icon, grouped by category.
  4. Choose a symbol from the collection that opens.
  5. Confirm to place it, then drag it into position.

Tip For a character you can type inside a cell, Symbol is the better choice.

3D Models

Where to find it
  • Insert › Illustrations

Inserts an object you can look at from any angle, choosing the view from a gallery.

  1. Click 3D Models.
  2. The gallery opens with twelve ready-made solids: click one to insert it on the sheet, anchored to the selected cell.
  3. To use a file of your own, click This Device at the bottom of the gallery and choose a .glb, .gltf, .obj or .stl file.
  4. Select the model.
  5. Drag the model to move it, or one of its handles to resize it.

SmartArt

Where to find it
  • Insert › Illustrations

Shows a short set of ideas as a ready-made diagram - a sequence, a cycle, a hierarchy - instead of drawing the boxes and arrows yourself.

  1. Click the cell you want the diagram anchored to.
  2. Click SmartArt.
  3. Type your text: one line per box - Enter adds a line, Tab makes it a sub-entry.
  4. Pick the layout whose thumbnail shows what you mean, choose a colour, and check the live preview before you confirm.

Tip A diagram carries a short list far better than a long one: keep each entry to a few words so it stays readable at page size.

Screenshot

Where to find it
  • Insert › Illustrations

Takes a picture of a screen, a window or a browser tab and inserts the part you choose onto the sheet.

  1. Click the cell you want the picture anchored to.
  2. Click Screenshot.
  3. Choose the screen, window or tab to capture in the browser dialog, then confirm.
  4. The capture opens whole and already selected: drag on it to keep only a part, or drag the handles of the selection.
  5. Capture again takes a new picture; Whole capture puts the selection back.
  6. Click Insert: the selected area is added to the sheet as a picture, anchored to the active cell.

Tip Only the selected area is inserted — the shaded part stays off the sheet. Screen capture needs the browser version: in the desktop app the command is switched off.

Text Box

Where to find it
  • Insert › Text, Links and Symbols

Draws a box that holds text anywhere on the sheet, free of the grid: a title over a chart, a caption, a note beside a block of figures.

  1. Click Text Box: the box appears at the active cell with the cursor already inside.
  2. Type the text; Enter starts a new paragraph.
  3. Select part of the text by dragging, double-clicking a word or with Shift+arrows, and format it with the font commands or with Ctrl+B, Ctrl+I, Ctrl+U.
  4. Press Esc or click outside to confirm; to edit the text again, double-click the box, or select it and press Enter.

Tip With the box selected but not open for editing, the font and alignment commands format all of its text. The text is not in a cell, so no formula can read it.

Header and Footer

Where to find it
  • Insert › Text, Links and Symbols

Writes what repeats at the top and bottom of every printed page. Each band has three parts — left, centre and right — and the page shown above is the one that will be printed.

  1. Click Header & Footer.
  2. Type in the Left, Centre or Right box of the header, of the footer, or of both.
  3. To add the page number, the date or the sheet name, place the cursor and press the field button.
  4. Turn on Different first page or Different odd and even pages to write a separate version.
  5. Click OK.

Tip The preview resolves the fields with the real sheet name, file name and page count. Type && to print a literal ampersand.

WordArt

Where to find it
  • Insert › Text, Links and Symbols

Puts a decorated heading on the sheet. You write the words and choose how they look in the same window, so the thirty styles show your own text while you type it.

  1. Click WordArt.
  2. Type your text: the preview and all thirty style tiles redraw with your words.
  3. Click the style you want.
  4. Click Insert. The WordArt lands at the selected cell as a text box with no fill and no outline, and stays selected.

Tip The WordArt is an object like any other: move it, resize it, arrange it, delete it. To change how it looks afterwards, leave it selected — WordArt Styles, Text Fill, Text Outline and Text Effects all work on it.

Signature Line

Where to find it
  • Insert › Text, Links and Symbols

Mark where the file is to be signed: the sheet shows an X, a rule, and the name and title of whoever should sign. Merydion does not collect the signature itself — the file is signed in Excel, with a signing service, or by hand on the printout.

  1. Select the cell where you want the signature line.
  2. Click Signature Line.
  3. Fill in the suggested signer and their title: these are the two lines that will appear under the rule.
  4. The e-mail address and the instructions are optional and do not appear on the sheet — they travel inside the file, for whoever collects the signature.
  5. Choose whether the signer may add a comment and whether the signing date will appear on the line, then click Insert.
  6. The signature line behaves like any other picture: select it to move or resize it, or press Ctrl+Z to remove it.

Tip Every field may be left empty: a signature line with no name shows just the X and the rule, which is the form to sign by hand.

Checkbox

Where to find it
  • Insert › Text, Links and Symbols

Puts a tickable box in the selected cells. The box is cell formatting, so it travels with the cell when you sort, filter or insert a row; the cell value stays TRUE or FALSE, and formulas read it just as before.

  1. Select the cells where you want the box.
  2. Click Checkbox.
  3. Click a box to tick it, or select several cells and press the spacebar to flip them together.
  4. To remove the boxes, select the cells again and click Checkbox once more.

Tip Empty cells become FALSE; cells that already hold text, numbers or a formula are left untouched. Pressing Delete once clears the ticks, pressing it again removes the boxes.

Object

Where to find it
  • Insert › Text, Links and Symbols

Puts a file made with another program inside the workbook. The file travels with the workbook, and on the sheet you see either its contents or its icon with a caption.

  1. Click Object.
  2. Choose how it should look: its contents (images only) or an icon with a caption.
  3. Type a caption, or leave it empty to use the file name.
  4. Click Choose file… and pick the file to carry inside the workbook.

Tip Only files a painter can draw show their contents; everything else appears as an icon with its caption, and the file itself is still inside the workbook.

Equation

Where to find it
  • Insert › Text, Links and Symbols

Adds a mathematical formula to the sheet. The formula goes into a text box of its own, which you can then move, resize and arrange like any other object.

  1. Click Equation.
  2. Build the formula in the window: type letters and numbers, click a structure such as a fraction or a root to add it, and click a symbol to insert it.
  3. Move between the parts of a structure with Tab, or click straight into the one you want.
  4. Click Insert. The formula lands at the selected cell, in a box measured on it. To change it later, select it and click Equation again: the same window reopens on it and the button reads Update.

Tip Type a backslash name and then a space to get the symbol: \alpha becomes α, \sum becomes ∑. The names are the ones shown under the symbols in the window. For a well-known formula, open the Equation submenu and pick it from the list — it opens already written, ready to adjust.

Symbol

Where to find it
  • Insert › Text, Links and Symbols

Inserts a character your keyboard does not offer: a currency sign, an accented letter, an arrow, a mathematical sign.

  1. Click where the character should go.
  2. Click Symbol.
  3. Find the character you want in the dialog that opens.
  4. Confirm to insert it.

Tip For a picture-like mark rather than a typed character, Icons fits better.

Back to the guide

Productivity, made in Italy.

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