Tabulys guide

Format

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

Number Format

Where to find it
  • Format › Cells
  • Toolbar
  • Pane › Cells

Chooses how the values in the selected cells are shown, from plain numbers to dates and currency. The stored value never changes, only its appearance.

  1. Select the cell or range you want to format.
  2. Open the Number Format list: under each format you see the active cell's value in that format.
  3. Choose the format you want, or More Number Formats… to open Format Cells.

Tip Because formatting is display only, a figure that looks rounded still calculates with all of its digits.

Accounting Number Format

Where to find it
  • Format › Cells › Number Style
  • Toolbar
  • Pane › Cells

Shows the selected cells as money, with the currency symbols and the decimal points aligned down the column. Apply it to a whole column of amounts rather than to one figure.

  1. Select the column of amounts you want to format.
  2. Click Accounting Number Format.
  3. Click the arrow next to it to choose a different currency.

Tip Widen the column afterwards if the formatted amounts no longer fit within it.

Percent Style

Where to find it
  • Format › Cells › Number Style
  • Toolbar
  • Pane › Cells

Shows the values in the selected cells as percentages. Use it on ratios and shares, so they read as a percentage rather than as a fraction.

  1. Select the cell or range holding the values.
  2. Click Percent Style.
  3. Click Increase Decimal if the percentage needs decimal places.

Tip To go back, pick a different entry from the Number Format list.

Comma Style

Where to find it
  • Format › Cells › Number Style
  • Pane › Cells

Groups the digits of large numbers so thousands are easy to read at a glance. Worth applying to any column whose figures run to four digits or more.

  1. Select the cell or range holding the numbers.
  2. Click Comma Style.
  3. Use Increase Decimal or Decrease Decimal to settle how many decimals show.

Tip For money, Accounting Number Format lines up the currency symbol as well.

Increase Decimal

Where to find it
  • Format › Cells › Number Style
  • Toolbar
  • Pane › Cells

Shows one more digit after the decimal point in the selected cells. Use it when a rounded display hides a difference that matters.

  1. Select the cell or range you want to change.
  2. Click Increase Decimal.
  3. Click it again for each further digit.

Tip Those digits were in the stored value all along; revealing them changes nothing in the calculations. On a cell in General it starts from the digits the cell shows; dates, times and fractions do not change.

Decrease Decimal

Where to find it
  • Format › Cells › Number Style
  • Toolbar
  • Pane › Cells

Shows one fewer digit after the decimal point in the selected cells. It tidies a column of figures without touching what they hold.

  1. Select the cell or range you want to change.
  2. Click Decrease Decimal.
  3. Click it again for each further digit you want out of sight.

Tip The display rounds but the stored values do not, so a total can look a digit out from the figures above it.

Cell Styles

Where to find it
  • Format › Cells › Cell Styles
  • Pane › Cells

A grid of ready-made looks you apply in one click. Working with styles keeps a workbook consistent far better than formatting each cell by hand.

  1. Select the cell or range you want to restyle.
  2. Pick a style from the cell styles in view.
  3. If the one you want is not there, choose All cell styles to open the whole catalogue at once.

Tip A style sets several properties at once, so it replaces formatting you had applied by hand to the same cells. It changes only what the style includes, though: a style that does not include protection leaves the cell locked or unlocked as it was.

All cell styles

Where to find it
  • Format › Cells › Cell Styles
  • Pane › Cells

Opens the whole catalogue of cell styles at once, grouped by family: good, bad and neutral; data and model; titles and headings; themed styles; number formats. The style the selected cell already carries is marked.

  1. Select the cell or range you want to restyle.
  2. Click All cell styles.
  3. Click a style to apply it.
  4. Use New Cell Style or Merge Styles at the end of the catalogue to make a style of your own or take one from another workbook.

Tip The catalogue shows every style at once, so you can compare the ones that look alike instead of looking for them one at a time.

Conditional Formatting

Where to find it
  • Format › Cells

Colours cells according to a rule, so the sheet flags things for you: the values over a threshold, the blanks, the outliers. The colouring follows the values as they change.

  1. Select the range the rule should watch.
  2. Click Conditional Formatting.
  3. In the submenu that opens, choose the kind of rule you want.
  4. Set the rule in the dialog that opens and confirm it.

Tip Apply the rule to the whole column rather than cell by cell, so the rows you add later are covered too.

Format as Table

Where to find it
  • Format › Cells

Turns a plain range into a table, with a banded style and filter controls on the header row. Reach for it once your data has settled into columns with headings.

  1. Select the range, including its header row.
  2. Click Format as Table.
  3. In the menu, Format as Table opens a submenu of table styles: pick a different one. Each preview shows the style on your table, with the options it has turned on.
  4. Use the filter controls on the header row to order or narrow the data.

Tip Give every column a heading before you convert, because the header row is what the filters are labelled by.

Font

Where to find it
  • Format › Font and Borders
  • Toolbar
  • Pane › Cells

Sets the typeface the contents of the selected cells are drawn in. It applies to the whole cell, not to part of a value. The list shows the fonts the app renders faithfully, each written in its own typeface; Advanced…, at the bottom of the list, opens a window where you can search fonts by name and preview them on the active cell's text.

  1. Select the cell or range you want to change.
  2. Open the Font list.
  3. Choose a typeface from the list.

Tip Select whole columns before you choose, so a table stays in one typeface as it grows.

Increase Font Size

Where to find it
  • Format › Font and Borders › Size
  • Toolbar
  • Pane › Cells

Steps the contents of the selected cells up to the next size. Handy when you want something bigger without deciding on an exact number.

  1. Select the cell or range you want to change.
  2. Click Increase Font Size.
  3. Click it again for each further step up.

Tip Decrease Font Size, beside it, walks the size back down again.

Decrease Font Size

Where to find it
  • Format › Font and Borders › Size
  • Toolbar
  • Pane › Cells

Steps the contents of the selected cells down to the next size. Use it to fit more into a column without widening it.

  1. Select the cell or range you want to change.
  2. Click Decrease Font Size.
  3. Click it again for each further step down.

Tip Increase Font Size, beside it, takes the size back up.

Font Size

Where to find it
  • Format › Font and Borders › Size
  • Toolbar
  • Pane › Cells

Sets how large the contents of the selected cells are. Reach for it when a heading has to stand out, or a label has to fit a narrow column. The list offers sizes from 8 to 72 points; Advanced…, at the bottom of the list, opens a window where you can type any size from 1 to 409 points and see a preview.

  1. Select the cell or range you want to change.
  2. Open the Font Size list.
  3. Choose a size from the list.

Tip To nudge the size a step at a time instead, use Increase Font Size and Decrease Font Size.

Bold

Where to find it
  • Format › Font and Borders
  • Toolbar
  • Pane › Cells
Ctrl+B

Draws the contents of the selected cells in a heavier weight. It is the usual way to mark a header row or a line of totals.

  1. Select the cell or range you want to emphasise.
  2. Click Bold.
  3. Click Bold again to take the weight off.

Tip The formatting belongs to the cell, so a value you type into it later comes out bold as well.

Italic

Where to find it
  • Format › Font and Borders
  • Toolbar
  • Pane › Cells
Ctrl+I

Slants the contents of the selected cells. It is a lighter form of emphasis than bold, often used for notes and units.

  1. Select the cell or range you want to emphasise.
  2. Click Italic.
  3. Click Italic again to remove the slant.

Tip Bold and Italic are independent, so a cell can carry both at once.

Underline

Where to find it
  • Format › Font and Borders
  • Pane › Cells
Ctrl+U

Rules a line under the contents of the selected cells. The arrow offers the other kinds of underline.

  1. Select the cell or range you want to underline.
  2. Click Underline.
  3. Click the arrow next to Underline to choose a different kind of line.
  4. Click Underline again to remove it.

Tip An underline sits under the text itself; to rule a line right across a cell, use Borders instead.

Font Color

Where to find it
  • Format › Font and Borders › Color and Fill
  • Pane › Cells

Changes the colour the contents of the selected cells are drawn in. A common use is marking negative figures or rows that need attention.

  1. Select the cell or range you want to change.
  2. Click Font Color to apply the colour shown on the button.
  3. Click the arrow next to Font Color to pick a different colour.
  4. For a colour that is not among the swatches, choose More Colors… in the same menu.

Tip Colour alone is easy to miss on a printed sheet, so pair it with bold or a border for anything important.

Fill Color

Where to find it
  • Format › Font and Borders › Color and Fill
  • Toolbar
  • Pane › Cells

Paints the background of the selected cells. Use it to set the cells people type into apart from the ones that calculate.

  1. Select the cell or range you want to colour.
  2. Click Fill Color to apply the colour shown on the button.
  3. Click the arrow next to Fill Color to pick a different colour.
  4. For a colour that is not among the swatches, choose More Colors… in the same menu.

Tip Keep the fill pale where cells hold text, so the values stay readable against it.

Borders

Where to find it
  • Format › Font and Borders
  • Toolbar
  • Pane › Cells

Draws lines on the edges of the selected cells. Borders are what turn a block of values into a table you can read at a glance.

  1. Select the cell or range you want to outline.
  2. Click Borders to apply the border shown on the button.
  3. Click the arrow next to Borders to choose which edges get a line — every entry shows a small picture of the border it draws.
  4. Choose More Borders at the end of the list to set the line style and colour edge by edge, including the lines between the cells.

Tip Borders belong to the cells rather than to the values, so they stay in place when you retype the contents. Outside Borders frames the whole selection, while All Borders also draws the lines between the cells.

Align Left

Where to find it
  • Format › Alignment › Horizontal
  • Toolbar
  • Pane › Cells

Lines the contents of the selected cells up against the left edge. It is the natural setting for labels and other text.

  1. Select the cell or range you want to align.
  2. Click Align Left.
  3. Click Center or Align Right to move the contents across instead.

Tip Figures usually read better against the right edge, where their digits line up down the column.

Center

Where to find it
  • Format › Alignment › Horizontal
  • Toolbar
  • Pane › Cells

Centres the contents between the left and right edges of the cell. Most often used on the header cells above a column of figures.

  1. Select the cell or range you want to centre.
  2. Click Center.
  3. Click Align Left or Align Right to move the contents to an edge instead.

Tip To centre one piece of text across several cells at once, use Merge & Center.

Align Right

Where to find it
  • Format › Alignment › Horizontal
  • Toolbar
  • Pane › Cells

Lines the contents of the selected cells up against the right edge. This is how columns of figures are normally set, so the digits line up.

  1. Select the cell or range you want to align.
  2. Click Align Right.
  3. Click Align Left or Center to move the contents across instead.

Tip The three horizontal alignments are one choice between three: turning one on turns the other two off.

Top Align

Where to find it
  • Format › Alignment › Vertical
  • Pane › Cells

Sits the contents against the top edge of the cell. It only shows once a row is taller than the text in it.

  1. Select the cell or range you want to align.
  2. Click Top Align.
  3. Click Middle Align or Bottom Align to move the contents down instead.

Tip Top, Middle and Bottom Align are one choice between three: turning one on turns the other two off.

Middle Align

Where to find it
  • Format › Alignment › Vertical
  • Pane › Cells

Centres the contents between the top and bottom edges of the cell. It is the tidiest setting for a header row that runs to more than one line.

  1. Select the cell or range you want to align.
  2. Click Middle Align.
  3. Click Top Align or Bottom Align to pin the contents to an edge instead.

Tip Vertical alignment only shows when the row is taller than its text, so it goes unnoticed on rows of a single line.

Bottom Align

Where to find it
  • Format › Alignment › Vertical
  • Pane › Cells

Sits the contents against the bottom edge of the cell. Useful when a tall row carries a label that should line up with the row beneath it.

  1. Select the cell or range you want to align.
  2. Click Bottom Align.
  3. Click Top Align or Middle Align to lift the contents instead.

Tip This sets the vertical position only; Align Left, Center and Align Right set the horizontal one.

Orientation

Where to find it
  • Format › Alignment
  • Pane › Cells

Sets whether the page prints upright or on its side. Turn it on its side when a table has more columns than fit across an upright page.

  1. Click Orientation.
  2. In the window that opens, choose between the upright and the sideways layout.
  3. Look at the sheet again to see how many columns now fit on a page.

Tip Orientation is a property of the printed page, not of the cells you happen to have selected.

Wrap Text

Where to find it
  • Format › Alignment
  • Toolbar
  • Pane › Cells

Lets long text in a cell run onto several lines instead of one. Use it for headings and notes that would otherwise spill over their neighbours.

  1. Select the cell or range holding the long text.
  2. Click Wrap Text.
  3. Adjust the column width until the text breaks where you want it.
  4. Click Wrap Text again to put the text back on one line.

Tip Text can only wrap within the column width, so a narrow column produces a great many short lines.

Decrease Indent

Where to find it
  • Format › Alignment
  • Pane › Cells

Pulls the contents of the selected cells back towards the edge of the cell, one step at a time. It walks back an indent you added.

  1. Select the cell or range you want to change.
  2. Click Decrease Indent.
  3. Click it again for each further step back.

Tip The contents stop once they reach the edge of the cell; further clicks then do nothing.

Increase Indent

Where to find it
  • Format › Alignment
  • Pane › Cells

Pushes the contents of the selected cells further from the edge of the cell, one step at a time. Use it to show sub-items under a heading in the same column.

  1. Select the cell or range you want to change.
  2. Click Increase Indent.
  3. Click it again for each further step in.

Tip Indenting moves where the contents are drawn, not the value itself, so calculations are untouched.

Merge & Center

Where to find it
  • Format › Alignment
  • Toolbar
  • Pane › Cells

Joins the selected cells into one and centres the text across the whole span. It is the usual way to put a title over a group of columns.

  1. Select the cells you want to join, starting with the one that holds the text.
  2. Click Merge & Center.
  3. Click the arrow next to Merge & Center for the other ways of merging, and to undo a merge.

Tip Once merged, the block behaves as a single cell: clicking anywhere in it selects the whole thing.

Format cells

Where to find it
  • Format › Rows, Columns and Sheets
  • Pane › Cells
  • Shortcut menu

Gathers the cell formatting settings, number and alignment and font and border, in one place. Reach for it when several of them need setting together rather than one button at a time.

  1. Select the cell or range you want to format.
  2. Click Format.
  3. In the menu, the other formatting choices follow the Format item.
  4. Set the options you need and confirm.

Tip For a single change, one border or one colour, the font and alignment buttons are quicker.

All themes

Where to find it
  • Format › Theme and Page › Theme

Opens the whole catalogue of themes in one panel, each drawn as a small page, with the theme the workbook uses marked. It is the quickest way to compare them.

  1. Click All themes.
  2. A panel opens under the button with all thirty themes; the one in use is outlined.
  3. Click a theme to apply it: the panel closes.
  4. Press Esc to close the panel without changing anything.

Tip Each tile shows the theme's page colour, the colour of its headings and four of its accent colours along the edges.

Themes

Where to find it
  • Format › Theme and Page › Theme

A theme is a matched set of colours, fonts and effects. Applying one restyles the workbook in a single step instead of changing each piece by hand.

  1. Choose All themes to look at the themes: each tile is a page in miniature, with the theme's page colour, heading colour and four accent colours along its edges.
  2. The tile of the theme the workbook uses is highlighted.
  3. If you already know the theme's name, pick it from the Themes submenu in the menu.
  4. Click a theme to apply it; Ctrl+Z undoes it in one step.

Tip The colours and fonts of the chosen theme can still be swapped afterwards with Colors and Fonts.

Theme colours

Where to find it
  • Format › Theme and Page › Theme

Swaps the palette the current theme uses, leaving its fonts alone. Reach for it when the layout is right but the colours are not.

  1. Click Colors.
  2. A list opens under the button: every colour set is a strip of eight swatches, and the set in use is outlined.
  3. Click a colour set to apply it to the theme.
  4. Pick another set at any time to change the palette again.

Tip If none of the ready-made sets fits, choose Customize Colors at the bottom of the same list to build one of your own.

Customize Colors

Use this when no ready-made set in the Colors list matches your house palette. It lets you define the colours the theme works from.

  1. Click Colors.
  2. At the bottom of the list, click Customize Colors.
  3. In the dialog that opens, choose the colours you want.
  4. Confirm to apply your set to the theme.

Tip The supplied sets stay in the Colors list, so you can always drop back to one.

Theme fonts

Where to find it
  • Format › Theme and Page › Theme

A theme carries a pair of fonts, one for headings and one for body text. This list swaps that pair without touching the colours the theme uses.

  1. Click Fonts.
  2. A list opens under the button with each pair once: the heading font in bold above the body font, and the pair in use outlined.
  3. Click a pair to apply it to the theme.
  4. Pick another pair at any time to change the typography again.

Tip To set a pair of your own instead, choose Customize Fonts at the bottom of the same list.

Customize Fonts

Use this when the pairs in the Fonts list do not include the typefaces you need. It lets you choose the fonts the theme works from.

  1. Click Fonts.
  2. At the bottom of the list, click Customize Fonts.
  3. In the dialog that opens, pick the heading and body fonts you want.
  4. Confirm to apply your pair to the theme.

Tip The supplied pairs remain in the Fonts list, so you can return to one at any time.

Effects

Where to find it
  • Format › Theme and Page › Theme

Picks the theme's effect set: how shadows, glows and reflections look on the shapes that follow the document theme. Every set carries three levels — subtle, moderate, intense — and each shape takes the one its style names.

  1. Click Effects.
  2. Scroll the list: every row shows the set's three levels drawn on a real shape.
  3. Pick a set and confirm with Apply.

Tip A shape with its own effects keeps them: the theme set applies to the shapes that follow the theme, not to the ones you have already decorated by hand.

Margins

Where to find it
  • Format › Theme and Page › Margins and Orientation

Margins are the blank border between the edge of the paper and the cells printed inside it. Widen them for binding, narrow them to fit more columns on a page.

  1. Click Margins.
  2. The list of margin choices opens.
  3. Pick the setting you want.
  4. Preview or print the sheet to check the new border.

Tip Margins are a printing setting: the grid on screen is not redrawn when you change them.

Orientation

Where to find it
  • Format › Theme and Page › Margins and Orientation

Decides whether the page prints upright or on its side. Turn it on its side when the sheet is wider than it is tall.

  1. Click Orientation.
  2. The list with both choices opens.
  3. Pick upright or on its side.
  4. Preview the sheet to confirm the columns now fit.

Tip If a few columns still spill over the edge, try Scale to Fit.

Paper size

Where to find it
  • Format › Theme and Page

Sets the sheet of paper the printout is laid out for. Choose it before fine-tuning margins or scaling, because those are measured against it.

  1. Click Size.
  2. The list of paper on offer opens.
  3. Pick the paper you will print on.
  4. Check the margins afterwards, since the printable width has changed.

Tip The wrong paper here is the usual reason a printout comes out cropped or shrunk.

Print Area

Where to find it
  • Format › Theme and Page

Limits printing to a chosen block of cells, so a working sheet full of scratch columns still prints as a tidy report.

  1. Select the cells you want to print.
  2. Click Print Area.
  3. The list of choices opens.
  4. Preview the sheet to confirm only that block comes out.

Tip With nothing selected there are no cells to set as the area, so make the selection first.

Breaks

Where to find it
  • Format › Theme and Page

Forces the printout to start a new page, column or section at a point you choose, instead of letting it split wherever the paper runs out.

  1. Select the cell where the break should fall.
  2. Click Breaks.
  3. The list opens: choose the break you want.
  4. Preview the sheet to see where the content now splits.

Tip A break changes only where the printout divides; the cells and their values are untouched.

Print Titles

Where to find it
  • Format › Theme and Page

Repeats chosen rows or columns on every printed page, so a long table stays readable past page one.

  1. Click Print Titles.
  2. A dialog opens where you set the rows or columns to repeat.
  3. Give the rows or columns you want repeated.
  4. Confirm, then preview the sheet to check they appear on each page.

Tip This affects the printout only; nothing is duplicated in the grid on screen.

Background

Where to find it
  • Format › Theme and Page

Puts a picture — or a plain colour — behind the cells of the sheet, tiled across the whole grid. It is a decoration of the screen: it is never printed.

  1. Click Background.
  2. Pick a colour from the palette, or click Picture… to choose an image file.
  3. Tick Apply to all sheets to use the same background throughout the workbook.
  4. Click OK. To remove it, open Background again and choose No background.

Tip The background never appears in a printout or a PDF, exactly as in Excel. Choose a light image if the cells must stay readable.

Width

Where to find it
  • Format › Theme and Page › Scale to Fit

Sets the width the content is scaled to. It works together with Height and Scale.

  1. Open the Width list.
  2. Choose the width you want from the list.
  3. Check Height if the vertical size also matters.
  4. Preview the sheet to see the result.

Tip Width is a list, so only the values it offers can be set here; for a free amount use Scale, which works in percentages.

Height

Where to find it
  • Format › Theme and Page › Scale to Fit

Sets the height the content is scaled to, the companion of Width.

  1. Open the Height list.
  2. Choose the height you want from the list.
  3. Check Width if the horizontal size also matters.
  4. Preview the sheet to see the result.

Tip Height offers a fixed list of values; Scale, beside it, resizes by a percentage instead.

Scale

Where to find it
  • Format › Theme and Page › Scale to Fit

Shrinks or enlarges the content by a percentage rather than to a set width or height. Use it to nudge a sheet down until it fits.

  1. Open the Scale list.
  2. Choose the percentage you want.
  3. A percentage below 100 shrinks the content, above 100 enlarges it.
  4. Preview the sheet to check the text is still readable.

Tip Scale, Width and Height act on the same content, so after changing one look at the other two.

Gridlines: Print

Where to find it
  • Format › Theme and Page
  • Pane › Sheet

Decides whether the lines between cells appear on the printout. Turn it on for a sheet people will fill in by hand.

  1. Tick Print to include the gridlines on the printout.
  2. Clear Print to leave them off.
  3. Preview the sheet to confirm.

Tip This is independent of View, so gridlines can print even while they are hidden on screen.

Headings: Print

Where to find it
  • Format › Theme and Page
  • Pane › Sheet

Adds the column letters and row numbers to the printout. Useful when you will discuss the sheet by cell address with someone holding the paper.

  1. Tick Print to include the headings on the printout.
  2. Clear Print to leave them off.
  3. Preview the sheet to confirm.

Tip It is separate from View, so the headings can print even when they are hidden on screen.

Back to the guide

Productivity, made in Italy.

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