Tabulys guide

Sort, filter & clean

Sort, filter, remove duplicates and split text to columns.

Sort and filter

  1. Click a cell in the data, then use Sort A to Z or Z to A to sort by that column.
  2. Use Custom Sort to sort by several columns in the Sort by / Then by dialog.
  3. Click Filter, or press Ctrl+Shift+L, to add AutoFilter dropdown arrows to the headers.
  4. Click a header arrow and tick or untick values, or type into the search box, to filter rows.
  5. The panel is grouped into sorting commands, filters such as by colour, above or below average and Top 10, and the value checklist with its search box; confirm with OK.
  6. Use Clear to remove the filter and show all rows again.

Tip In a filter search box, prefix a number with >, >=, < or <= for a numeric filter.

Remove duplicates

  1. Click a cell inside the data region.
  2. Click Remove Duplicates.
  3. Tick the columns to compare, and set the My data has headers option as needed.
  4. Confirm to remove duplicate rows, keeping the first occurrence of each.
  5. Read the report showing how many duplicates were removed and how many unique values remain.

Tip It is a single undo step, so press Ctrl+Z if you need to bring the rows back.

Text to Columns

Split the text of one column into several columns, with a live preview, just like Excel.

  1. Select the column of text to split.
  2. Click Text to Columns.
  3. Choose Delimited and pick the separators (Tab, semicolon, comma, space or a custom character), or choose Fixed Width and place cut markers.
  4. Set a per-column format such as General, Text, a date order or Skip, watching the preview.
  5. Confirm to write the result into columns to the right, confirming any overwrite.

Flash Fill

Where to find it
  • Data › Data Tools
  • Shortcut menu

Flash Fill fills a column from examples: type one or two results next to your data and it works out the pattern for the rest — just like Excel.

  1. Type the result you want in the cell next to the data (for example the first name from a full name) and press Enter.
  2. Start typing the next result in the cell below: a grey preview of the whole column appears automatically as soon as the pattern is clear.
  3. Press Enter to accept the preview and fill the rest of the column in a single undo step, or press Esc to dismiss the suggestion and keep typing.
  4. Sources can be on either side of the target column and span several columns.
  5. You can also trigger it explicitly at any time with Ctrl+E, or the Flash Fill button.

Tip The automatic suggestion can be turned off from the Automatically Flash Fill item in the cell right-click menu; Ctrl+E still works. The preview only appears while the typed text matches the pattern, and it writes plain values, not formulas.

Find, Replace and Go To

  1. Press Ctrl+F to bring the keyboard to the search bar in the title bar with the In this document scope, and type the text: the cells found on every sheet come first in the dropdown, each with the name of its sheet, and the sheet doesn't move.
  2. Press Enter to select the next cell found, on another sheet too, and Shift+Enter for the previous one: it reaches beyond the first 50 rows shown as well, after the last one it starts again from the first, and the bar says which one you are on, for example 2 of 15. Esc closes the dropdown, and a second Esc goes back to the grid.
  3. Press Ctrl+H, click Replace… at the bottom of the dropdown, or choose Find or Replace from Find & Select, to open the Find and Replace window.
  4. Type the text to find; Find Next advances from the active cell and wraps around.
  5. Use Replace to change the matching cell and advance, or Replace All in one undo step.
  6. Tick options such as Match case, Match entire cell, Wildcards or Look in values.
  7. Press Ctrl+G or F5 to Go To a reference or named range.

Tip Find and Replace works on the raw cell contents, so replacing acts on formulas, not the formatted value.

Back to the guide

Productivity, made in Italy.

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