Tabulys guide

Entering & editing data

Type into cells, edit values, auto-fill series and drag to move ranges.

Entering data

Tabulys infers the type of what you type: text, numbers, booleans, percentages, currency, fractions, dates, times, or formulas beginning with =. Numbers, dates and times are typed in the regional format of your language, as in Excel: in English 1,234.5 and 1/15/2024, in Italian 1.234,5 and 15/01/2024, with month names and the TRUE and FALSE words of the language. Formulas stay in English, with commas between arguments.

  1. Select a cell and start typing to overwrite its contents.
  2. Press F2 to edit the existing contents in place instead of replacing them.
  3. Or double-click the cell, or click the cell that is already selected: editing starts with the cursor where you clicked.
  4. Confirm with Enter to move down, Shift+Enter to move up, or Tab to move right.
  5. Shift+Tab confirms and moves left. After a series of Tab presses, Enter moves to the next row in the column where you started.
  6. When the rows above form a table that ends in the current column, Tab moves on its own to the start of the next row; press Right Arrow to go past the edge of the table.
  7. Press Esc to cancel the edit and keep the previous value.
  8. Press Delete to clear the contents of the selection.

Tip Type a value like 50%, 0 1/4 or a date and Tabulys applies the matching number format automatically. In a cell already formatted as a percentage, typing 12 gives 12%. Start with an apostrophe, or format the cell as Text, to keep what you type as text: '00123 stays 00123. The formula bar and F2 show the value in the same regional format, so confirming it again changes nothing.

AutoComplete and pick lists

As you type text that matches an entry already used higher up in the same column, Tabulys suggests the rest as dimmed “ghost” text. You can also pick from the list of values already entered in the column.

  1. Type the first letters of a text value that already appears in the same column.
  2. When the dimmed completion appears, press Enter or Tab to accept it and commit, or Right Arrow to accept it without leaving the cell.
  3. Keep typing to refine the suggestion, or press Backspace to dismiss it.
  4. Press Alt+Down Arrow, or right-click the cell and choose Pick From Drop-down List, to open the list of distinct values in the column.
  5. Use the arrow keys to highlight a value and press Enter to insert it.

Tip AutoComplete works on text only, never on numbers, dates or formulas. To turn the inline suggestion off, right-click a cell and clear AutoComplete Cell Values; the Alt+Down Arrow list stays available either way.

Selecting cells

  1. Drag across cells, or hold Shift and click, to select a rectangular range.
  2. Click a column letter or row number heading to select the whole column or row.
  3. Drag across headings to select several adjacent columns or rows.
  4. Hold Shift while clicking a heading to extend the current selection.
  5. Hold Ctrl while clicking to add a separate, disjoint area to the selection.

Tip Press Ctrl+Space to select the active column, or Ctrl+A to select the whole sheet. A selection that touches a merged cell always grows to contain it whole.

Reading selection totals in the status bar

When you select more than one cell, the status bar shows live aggregates of the selection — by default Average, Count and Sum.

  1. Select a range of cells that contains numbers.
  2. Look at the right side of the status bar: Average, Count and Sum appear automatically and update as you change the selection.
  3. Text and empty cells are ignored by the numeric figures; Count includes every non-empty cell, Numerical Count only the numbers.
  4. Click the totals to open the list of aggregates; the same list opens when you right-click the status bar, in the Customize Status Bar menu.
  5. Tick or untick Average, Count, Numerical Count, Minimum, Maximum or Sum to choose what is shown.
  6. Your choice is remembered the next time you open Tabulys.

Tip Aggregates that don't apply to the data (for example Sum when no numbers are selected) stay hidden automatically.

Fill handle

The fill handle is the small square at the bottom-right corner of the selection. Drag it to extend a series or copy values along.

  1. Select the cells that define the pattern, such as 1 and 2, or Jan.
  2. Drag the fill handle down, across or diagonally to project the series, watching the preview range; a diagonal drag extends the selection both ways at once.
  3. Release to fill; numbers, dates, text+number patterns and adjusted formulas are projected.
  4. Double-click the fill handle to fill down to the extent of the adjacent column.
  5. Press Ctrl+D to fill down or Ctrl+R to fill right within the selection.

Tip Hold Ctrl while dragging to switch between copying and incrementing a series. In the menu, the Fill submenu holds Series, which opens a Series dialog.

Move by dragging

  1. Select a single, contiguous range of cells.
  2. Hover over the border of the selection until the move cursor appears.
  3. Drag the border to the destination; an outline and a tooltip follow the pointer.
  4. Release to move the block, leaving the source cells empty.
  5. Hold Ctrl while dragging to copy instead of move, adjusting relative references.

Tip Press Esc during the drag to cancel. If the destination already holds data, Tabulys asks you to confirm overwriting it.

Get & Transform (query from a table or range)

Turn a table or a range into a reusable query: apply a chain of local transformation steps with a live preview, load the result to a new sheet as a table, and refresh it later to re-run the steps on the updated source.

  1. Select a range with headers (or a cell inside a table), then click Get Data or From Table/Range.
  2. In the Get & Transform panel, the Applied Steps list shows the Source; the data preview updates live as you edit the chain.
  3. Click Add and pick a step: Promote Headers, Remove Columns, Rename, Filter, Replace, Sort, or Change Type; fill in its parameters.
  4. Select a step and use Remove / Up / Down to delete or reorder it; the preview recomputes.
  5. Click Close & Load to write the result to a new sheet as a table (a single Undo step).
  6. When the source changes, use Refresh All to re-run every query.

Tip A step that names a missing column is skipped, so a stale chain never breaks Refresh. The query is saved in the file and reloads with it; Excel shows the loaded data as a normal table. External sources (Web, database, folder) and the full Power Query M round-trip are planned follow-ups.

Back to the guide

Productivity, made in Italy.

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