Tabulys guide

Cell formatting

Fonts, alignment, number formats, borders, merge & centre and wrap text.

Font, fill and borders

The font, fill and border commands apply cell formatting to the selected range.

  1. Select the cells to format.
  2. Use the Bold, Italic and Underline buttons, or Ctrl+B, Ctrl+I, Ctrl+U.
  3. Choose a typeface and size from the Font Family and Size combos, or grow and shrink them.
  4. Apply a font colour or fill colour from the swatch grid menus, including Automatic and No Fill.
  5. Apply a border preset such as All Borders, Outside or a thick box from the Borders gallery.

Tip The buttons and combos reflect the active cell's current formatting whenever you change the selection. To format whole rows or columns, select them by clicking their headings, or the whole sheet with Ctrl+A: the formatting also applies to the empty cells, including those beyond the last value, and whatever you type there later comes out already formatted.

Gradient fill and custom colours

Beyond the swatch palette, the Fill Color menu adds a gradient fill and an advanced colour picker, matching Excel's Fill Effects and More Colors.

  1. Select the cells to format.
  2. Open the Fill Color menu (the arrow next to the button) and choose Fill Effects… to open the gradient picker.
  3. Pick a direction — one of the four linear ones, or the rectangular gradient from the centre — and set its colour stops, or switch to the Pattern tab and pick one of the cell patterns with its two colours; then confirm — the cells show the fill on screen and in PDF, as a single undo step. The window opens on the fill the active cell already has.
  4. Choose More Colors… from the Fill Color or Font Color menu to pick any colour: drag on the saturation and brightness square and on the hue strip, or type the colour as hue, saturation and brightness, as R, G, B channels or as a hexadecimal code. The New and Current halves of the swatch compare it with the colour you started from.

Tip A gradient fill round-trips losslessly when you save the workbook. In More Colors… every value stays in step as you type, and a hexadecimal code pasted with Ctrl+V is adopted at once.

Alignment and wrapping

  1. Select the cells to align.
  2. Use the horizontal buttons to align left, centre or right, and the vertical buttons for top, middle or bottom.
  3. Click Wrap Text to flow long text onto several lines; the row height expands automatically.
  4. Click Merge & Centre to combine the selected cells into one centred cell.
  5. Use the Merge options to merge across, merge cells, or unmerge.
  6. In Format Cells (Ctrl+1) → Alignment, the Horizontal list also offers Fill, Justify, Distributed and Center Across Selection, rendered faithfully on screen and in PDF.

Tip Merging cells that hold data asks for confirmation before discarding all but the top-left value. Once merged, the cells behave as a single cell: the gridlines inside them disappear, and clicking any of them selects the whole region.

Working with merged cells

  1. Click anywhere inside a merged region: the whole region is selected, and the Name Box shows its top-left cell.
  2. Type, or press F2, to edit it: the text goes into the top-left cell, which is the only one that holds content.
  3. Press an arrow key to leave the region from its edge, not one step into it.
  4. Drag or Shift+click across a merged region: the selection always grows to contain it whole.
  5. Apply formatting, borders or a fill to a merged cell as you would to any other cell: the command covers the whole region.

Tip A merged region behaves as one cell everywhere: you cannot select or type into just one of the cells it is made of. Selecting a column that crosses a merge extends the selection to all the columns the merge spans.

Number formats

Where to find it
  • Format › Cells
  1. Select the cells to format.
  2. Open the Number Format list: under each format you see how the active cell will look, in your regional format.
  3. Choose a format, or More Number Formats… at the bottom of the list to open Format Cells on its Number section.
  4. Click Accounting Number Format for the Currency style, Percent Style for a percentage, or Comma Style for the Comma style.
  5. Use Increase Decimal and Decrease Decimal to change the decimal places: they start from the digits the cell shows.

Tip Currency, percentage and date formats are also applied automatically when you type a value in that form. In the General format a number adapts to the column width, showing fewer decimals or scientific notation; a fixed format that does not fit shows ####.

Format Cells dialog

Press Ctrl+1 to open the Format Cells dialog: the six sections (Number, Alignment, Font, Border, Fill and Protection) are listed on the left, and the options of the chosen section on the right, with a preview that shows the cell as it will look.

  1. Select the cells, press Ctrl+1 and pick a section from the list on the left.
  2. On Number, choose a category: only the options it uses appear beside it (decimal places, thousands separator, currency symbol, negative numbers, date, time or fraction type, format code), together with a preview of the value in your regional format; date and time types marked Regional follow the regional format of whoever opens the file.
  3. On Alignment, choose horizontal and vertical alignment, indent, rotation in degrees and text control (wrap text, shrink to fit, merge cells).
  4. On Font, pick the typeface from the list, where each name is written in its own typeface, then the size, style, effects, underline and colour, checking the result in the preview.
  5. On Border, choose a line style and colour, then apply them with Outline or Inside, or by clicking a side of the preview or the buttons around it.
  6. On Fill, choose a background colour and, if needed, a pattern and its colour (No fill removes both); on Protection, set Locked and Hidden, then confirm with OK.

Tip Fill patterns are painted by the same engine as the grid and the PDF, so each tile shows exactly the cell you will get. Locked and Hidden take effect only once the sheet is protected.

Cell Styles

The Cell Styles gallery applies named styles — Excel's full built-in set (Good, Bad, Neutral, Title, Headings, Total, Accents and number formats) plus your own custom styles. Applying a style links the cell to it, so editing the style updates every cell that uses it.

  1. Select the cells, then look at the style tiles in the Format pane, or open All cell styles to see them all at once.
  2. Click a style to apply it: the cell adopts the style's font, fill and borders.
  3. To change a style, select a cell that uses it and choose Modify Cell Style…: the Format Cells window opens on the style's attributes, and confirming updates every cell that uses it.
  4. Duplicate Cell Style copies the active cell's style under a new name; Delete Cell Style removes a custom style, and the cells that used it go back to the Normal style (built-in styles can't be deleted).
  5. Choose New Cell Style… to save the active cell's formatting as a custom style, or Merge Styles… to import styles from another workbook.

Tip Because each cell links to its named style, changing the style with Modify Cell Style… instantly restyles every cell that uses it.

Apply a document theme

A theme recolours and re-fonts the whole workbook at once: its accent colours and heading/body fonts flow to every cell that follows the theme.

  1. In the menu, pick a theme from the Themes submenu to apply its colours and fonts to the whole workbook, or choose All themes to see them all at once, as thumbnails.
  2. Use the Colors submenu to change only the colour scheme, or the Fonts submenu to change only the heading/body fonts.
  3. Press Ctrl+Z to undo a theme change in a single step.

Tip Cells keep their explicit formatting — only colours and fonts that follow the theme change.

Back to the guide

Productivity, made in Italy.

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