Tabulys guide

Rows, columns & sheets

Insert, delete, resize, freeze panes and manage sheet tabs.

Insert and delete

  1. Select whole rows or columns, or a range of cells, to act on.
  2. Use the Insert and Delete buttons, or right-click a row or column heading.
  3. Use the Clear button to clear All, Formats or Contents from the selection.
  4. Press Ctrl+Shift++ to insert, or Ctrl+- to delete: on a range of cells a window asks whether to shift the cells right or down (left or up), or to insert/delete entire rows or columns; you can also right-click a cell and choose Insert… or Delete….
  5. Each operation is a single undo step and repoints all affected formulas, just like Excel.

Tip Press Ctrl+9 / Ctrl+0 to hide rows or columns, and Ctrl+Shift+9 / Ctrl+Shift+0 to unhide them.

Resize, hide and unhide

  1. Hover over the boundary between two column or row headings; the resize cursor appears.
  2. Drag the boundary to resize the column to its left, or the row above it.
  3. Double-click the boundary to autofit the width or height to the content.
  4. Select several whole columns or rows first to resize them all uniformly.
  5. Hide a row or column with Ctrl+9 or Ctrl+0: the heading marks the spot with two thin lines; to unhide it, select across the gap and use Unhide.

Freeze panes and view toggles

Freeze Panes keeps header rows or columns visible while the rest of the grid scrolls.

  1. Select the cell below and to the right of the rows and columns to keep visible.
  2. Click Freeze Panes; the frozen bands stay put as you scroll.
  3. Use the Freeze Panes arrow to freeze just the top row or the first column, or to unfreeze.
  4. Toggle Gridlines to show or hide the grid lines.
  5. Toggle Headings to show or hide the A/B and 1/2 row and column headers, or the formula bar.

Sheet tabs

  1. Click the + at the start of the tab strip, or press Shift+F11, to insert a sheet.
  2. Double-click a tab to rename it inline, then press Enter.
  3. Drag a tab to reorder it: dragging moves the sheet, it does not copy it.
  4. Right-click a tab for the context menu to delete, hide, colour or duplicate it: Duplicate, like Move or Copy… with Create a copy, gives a complete, independent copy of the sheet, with its own charts, notes, tables and controls.
  5. Hidden sheets disappear from the strip but stay in the file; unhide them from the menu.
  6. To work on several sheets at once, hold Ctrl and click their tabs, or Shift+click for a range, or choose Select All Sheets: whatever you type, format or clear goes into the same cells of every grouped sheet, and Delete, Hide and Tab Color act on all of them. Ungroup Sheets, or a click on a tab outside the grouped sheets, separates them again.

Tip Sheet names must be unique and at most 31 characters, and cannot contain : \ / ? * [ or ]. A name too long for its tab is shortened with an ellipsis (…); hover the tab to see it in full. Renaming a sheet updates every place that names it — formulas, names, rules, validations, charts, controls and PivotTable sources — except hyperlink targets, as in Excel; deleting it turns the references to it into #REF!. Deleting the sheet you are looking at takes you to the one that takes its place (or the one on the left, if it was the last), with the view you left it in.

Group and subtotal

Group rows or columns into collapsible outline levels, or insert automatic subtotals, as in Excel.

  1. Select the rows or columns to group, then use the Group command.
  2. Click the + and - buttons, or the 1/2/3 level numbers in the gutter, to collapse and expand levels.
  3. Use Clear Outline to remove the grouping.
  4. For subtotals, sort the data by the key column first, then open the Subtotals dialog.
  5. Choose the column to group by and the function, such as Sum, and confirm to insert subtotal rows and a grand total.

Tip The outline gutters and level buttons are on-screen only; collapsed rows and columns do not print. Resizing grouped columns does not take them out of their group; resizing columns that a collapsed group hides shows them again and opens the group.

Back to the guide

Productivity, made in Italy.

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