Tabulys guide

Object

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

Bring Forward

Where to find it
  • Object › Arrange
  • Shortcut menu

Objects on a sheet sit in a stack. Bring Forward lifts the selected one a step up that stack, in front of what was covering it.

  1. Click the object you want to move up the stack.
  2. Click Bring Forward.
  3. Choose Bring Forward to move it up one place, or Bring to Front to put it in front of everything.
  4. Repeat until the object sits where you want it.

Tip Send Backward moves an object the other way down the stack.

Send Backward

Where to find it
  • Object › Arrange
  • Shortcut menu

Pushes the selected object a step down the stack, so objects that were underneath it now cover it.

  1. Click the object you want to move down the stack.
  2. Click Send Backward.
  3. Choose Send Backward to move it down one place, or Send to Back to put it behind everything.
  4. Repeat until the object sits behind the right things.

Tip If the object vanishes behind another, the Selection Pane lists every object on the sheet.

Align

Where to find it
  • Object › Arrange

Lines several objects up with each other - along their left edges, their centres, or spaced out evenly. The objects are picked in the window that opens, so you do not have to select them all on the sheet first.

  1. Click Align.
  2. Tick the objects you want to line up - at least two.
  3. Choose what to do across, down, or both.
  4. Watch the map show where they will land, then click Align.

Tip This is not the Align for pictures and shapes: that one moves a single object against a frame of the sheet, while this one arranges several objects relative to each other.

Group

Where to find it
  • Object › Arrange

Ties the selected object to the other objects you choose, so they move, align and are deleted as one. A group is a relationship and not a container: each object keeps its own settings. It is also how you group a chart, a SmartArt graphic or a 3D model.

  1. Click the object on the sheet you want to put in a group.
  2. Click Group.
  3. Tick the objects that go in — the map shows the frame the group will have, growing as you tick.
  4. Click Group.

Tip In the menu, the Group submenu also holds Ungroup and Regroup. The command is off when nothing is selected and when the sheet holds nothing else to group with: the tooltip says which.

Rotate

Where to find it
  • Object › Arrange
  • Shortcut menu

Turns the selected object round, or flips it over. Handy for reorienting a picture or a shape without redrawing it.

  1. Click the object you want to turn.
  2. Click Rotate.
  3. In the list that opens, choose between the 90° turns and the flips.
  4. Apply it again to carry on round.

Tip With nothing selected there is no object to turn, so select it first.

Selection Pane

Where to find it
  • Object › Arrange

Lists every object on the sheet in one place. It is how you reach something buried under other objects, or hidden from view.

  1. Click Selection Pane.
  2. Read the list of objects on the sheet.
  3. Use it to show or hide an object.
  4. Close the pane when you are done.

Tip Hiding an object here only takes it off the view; it stays in the sheet and can be shown again.

Chart Title

Where to find it
  • Object › Data and Charts › Chart

The title sits above the plot and says what the chart shows. Add one whenever the chart will be read away from the cells it came from.

  1. Click the chart to select it.
  2. Choose Chart Title: the title window opens.
  3. Type or edit the text and press OK: the title appears above the chart.
  4. To remove the title, leave the box empty and press OK.

Tip The command lights up only while a chart is selected: away from the chart it stays grey and, if you press it, says why.

Axis Titles

Where to find it
  • Object › Data and Charts › Chart

An axis title names what that axis measures, such as the months along the bottom or the amounts up the side. Without it the reader has to guess from the numbers.

  1. Click the chart to select it.
  2. Click Axes.
  3. In the window that opens, choose the horizontal or the vertical axis.
  4. Type the caption for that axis.

Tip Each axis carries its own caption, so repeat the steps for the second one.

Legend

Where to find it
  • Object › Data and Charts › Chart

The legend is the key that names each series, so the reader knows which colour stands for what.

  1. Click the chart to select it.
  2. Click Legend.
  3. In the menu, Legend opens a submenu with the further legend choices.

Tip A legend earns its place once a chart has more than one series; with a single series it only repeats the title.

Data Labels

Where to find it
  • Object › Data and Charts › Chart

Data labels print the value next to each point, so the reader takes the number straight off the chart instead of estimating it against the axis.

  1. Click the chart to select it.
  2. Click Labels.
  3. In the menu, Labels opens a submenu with the further label choices.
  4. Read the chart back to check it is still legible with the numbers in place.

Tip Labels on every point crowd a dense chart; they read best on a handful of large values.

Gridlines

Where to find it
  • Object › Data and Charts › Chart

Gridlines are the faint guide lines behind the plot that carry the eye from a point across to the axis.

  1. Click the chart to select it.
  2. Click Gridlines.
  3. In the menu, Gridlines opens a submenu with the further gridline choices.

Tip A chart that already carries data labels rarely needs gridlines as well.

Trendline

Where to find it
  • Object › Data and Charts › Chart

A trendline draws the direction the data is heading, past the noise of the individual points. Use it when the shape of the run matters more than any single value.

  1. Click the chart to select it.
  2. Click Trendline.
  3. In the menu, Trendline opens a submenu with the further trendline choices.
  4. Read the line against the points to check it follows them.

Tip The line is drawn from the data, so it is redrawn when the cells behind the chart change.

Error Bars

Where to find it
  • Object › Data and Charts › Chart
  • Pane › Chart

Error bars show the margin of error around each point, so the chart admits how precise its numbers actually are.

  1. Click the chart to select it.
  2. Click Error Bars.
  3. In the menu, Error Bars opens a submenu with the further choices.

Tip Use them only where the data carries a known tolerance; otherwise they suggest a precision it has not got.

Change Chart Type

Where to find it
  • Object › Data and Charts › Chart

Turns the chart into another kind of chart while keeping the same data. Reach for it when the shape you first picked does not tell the story.

  1. Click the chart to select it.
  2. Click Change Type.
  3. Pick the new kind of chart from the choices offered.
  4. Check the result: the data is unchanged, only the way it is drawn.

Tip The cells behind the chart are untouched, so you can try one kind and change it again.

Series Colors

Where to find it
  • Object › Data and Charts › Chart

Recolours the selected series alone, so one line or one set of columns stands apart from the rest.

  1. Click the chart, then click the series you want to recolour.
  2. Click Colors.
  3. Pick the colour for that series.
  4. In the menu, Colors opens a submenu with the further colour choices.

Tip To recolour every series at once, use Change Colors instead.

Change chart colors

Where to find it
  • Object › Data and Charts › Chart
  • Pane › Chart

Picks another colour set for the chart, so every series is recoloured together and stays in step.

  1. Click the chart to select it.
  2. Click Change Colors.
  3. Pick the colour set you want for the chart.
  4. In the menu, Change Colors opens a submenu with the further sets.

Tip Where Colors changes one series, this sets the colours of the whole chart in a single move.

Select Data

Where to find it
  • Object › Data and Charts › Chart
  • Pane › Chart

Chooses which cells the chart is drawn from. Reach for it when the chart was built on the wrong range, or when that range has since grown.

  1. Click the chart to select it.
  2. Click Select Data.
  3. A dialog opens where you set the cells the chart is drawn from.
  4. Confirm, and the chart is redrawn from the range you chose.

Tip When a chart looks wrong, check the range here before you start reformatting it: the cause is often the data, not the look.

Open the chart Format pane

Where to find it
  • Object › Data and Charts › Chart
  • Pane › Chart

Opens the panel where the chart is fine-tuned, for the details the other chart commands do not reach.

  1. Click the chart to select it.
  2. Click Format Pane.
  3. Fine-tune the chart from the panel that opens.

Tip The panel fine-tunes the selected chart: select the chart before you open it.

Table Name

Where to find it
  • Object › Data and Charts › Table
  • Pane › Table

A table carries a name, and formulas can refer to it by that name instead of a cell range. A name that says what the table holds is easier to read back months later.

  1. Click any cell inside the table.
  2. Click Table Name.
  3. Type the new name for the table.
  4. Confirm to apply it.

Tip Settle the name before you start writing formulas against the table, since the name is what those formulas will read.

Resize Table

Where to find it
  • Object › Data and Charts › Table
  • Pane › Table

Changes the range of cells the table covers, so rows or columns sitting just outside it are taken in.

  1. Click any cell inside the table.
  2. Click Resize.
  3. Set the new range of cells the table should cover.
  4. Confirm, and the table takes in the range you gave.

Tip Resizing changes only what the table covers; the values in those cells are left as they are.

Convert to Range

Where to find it
  • Object › Data and Charts › Table
  • Pane › Table
  • Shortcut menu

Turns the table back into ordinary cells. The values stay where they are; what goes is the table itself.

  1. Click any cell inside the table.
  2. Click Convert.
  3. Confirm that the table should become a normal range.
  4. Check the cells: the values are still there, the table is not.

Tip Undo brings the table back if you convert one by mistake.

Total Row

Where to find it
  • Object › Data and Charts › Table
  • Pane › Table
  • Shortcut menu

Adds a row at the foot of the table showing the totals of its columns, so the summary travels with the data.

  1. Click any cell inside the table.
  2. Tick Total Row.
  3. Read the totals in the new row at the foot of the table.
  4. Clear the tick to take the row away again.

Tip These ticks show the state of the table you are in, so they change as you move between tables.

Banded Rows

Where to find it
  • Object › Data and Charts › Table
  • Pane › Table

Shades every other row, so the eye stays on one row while reading across a wide table.

  1. Click any cell inside the table.
  2. Tick Banded Rows.
  3. Check how the shading reads against the table style you are using.
  4. Clear the tick to go back to plain rows.

Tip Banding rows and columns at once cancels out the help each gives; band the direction you actually read in.

First Column

Where to find it
  • Object › Data and Charts › Table
  • Pane › Table

Picks the first column out from the rest, so the labels that name each row read as headings rather than as data.

  1. Click any cell inside the table.
  2. Tick First Column.
  3. Check that the first column now stands apart from the others.
  4. Clear the tick to make it look like the rest again.

Tip It is worth ticking when the first column holds names or codes, and rarely when it holds numbers.

Last Column

Where to find it
  • Object › Data and Charts › Table
  • Pane › Table

Picks the last column out from the rest, which suits a table whose final column carries the total or the outcome.

  1. Click any cell inside the table.
  2. Tick Last Column.
  3. Check that the last column now stands apart.
  4. Clear the tick to make it look like the rest again.

Tip The emphasis follows the last column, so adding a column on the right moves it along.

Banded Columns

Where to find it
  • Object › Data and Charts › Table
  • Pane › Table

Shades every other column, which helps when the table is read down its columns rather than across its rows.

  1. Click any cell inside the table.
  2. Tick Banded Columns.
  3. Check that the shading reads clearly against the table style.
  4. Clear the tick to go back to plain columns.

Tip Leave Banded Rows clear while this is ticked, or the shading crosses itself and helps in neither direction.

Filter Button

Where to find it
  • Object › Data and Charts › Table
  • Pane › Table

Shows the filter arrows in the header row, so each column can be filtered from its own heading.

  1. Click any cell inside the table.
  2. Tick Filter Button.
  3. Click the arrow in a column heading to filter that column.
  4. Clear the tick to hide the arrows again.

Tip Hide the arrows on a table meant to be read or printed rather than sifted.

Table Styles

Where to find it
  • Object › Data and Charts › Table
  • Pane › Table

Applies a ready-made look to the whole table in one move, instead of formatting its cells by hand.

  1. Click any cell inside the table.
  2. Click Table Styles.
  3. Pick the look you want from the list of styles that opens.
  4. To change the style, click Table Styles again and pick another.

Tip The style options — Total Row, Banded Rows, First Column, Last Column, Banded Columns and Filter Button — keep working on top of the style you pick: set them first, then pick the style and look at the result on the table.

Expand Field

Where to find it
  • Object › Data and Charts › PivotTable
  • Pane › PivotTable
  • Shortcut menu

Opens every group of a PivotTable field in one go, so the levels beneath each one come back. It works on the field of the group label the active cell is on.

  1. Click the label of a group in the PivotTable, that is an item with levels beneath it.
  2. Click Expand Field.
  3. Every item of that field, on the rows or on the columns, opens and shows the items of the field beneath.
  4. To open a single group, click its + button or double-click its label.

Tip The whole command is a single Undo step. When the active cell is not a group label the button stays greyed out, and its tooltip says why.

Collapse Field

Where to find it
  • Object › Data and Charts › PivotTable
  • Pane › PivotTable
  • Shortcut menu

Closes every group of a field in one go: each group stays a single row with its own total, and the levels beneath drop out of view.

  1. Click the label of a group in the PivotTable.
  2. Click Collapse Field.
  3. Each group of that field shrinks to a single row, with a + button in front of it.
  4. To close a single group, click its − button or double-click its label.

Tip A closed group still shows its own total, even with subtotals turned off, and it stays closed when you save and reopen the file. Right-clicking also offers Collapse to "field", which closes the axis down to that level.

Refresh

Where to find it
  • Object › Data and Charts › PivotTable
  • Pane › PivotTable
  • Shortcut menu
Alt+F5

Recalculates the PivotTable from the current contents of its source data, after you have changed them.

  1. Change the PivotTable's source data.
  2. Click any cell inside the PivotTable.
  3. Click Refresh.
  4. The PivotTable rebuilds itself with the new values.

Tip The same command is on the PivotTable's right-click menu and on the Alt+F5 shortcut. A PivotTable on a table or a name reads its source as it is now; if the source no longer exists, an alert says so and the PivotTable stays as it was.

+/- Buttons

Where to find it
  • Object › Data and Charts › PivotTable
  • Pane › PivotTable

Shows or hides the + and − buttons in front of group labels, the ones you use to open and close levels right on the sheet.

  1. Click any cell inside the PivotTable.
  2. Click +/- Buttons: the command stays highlighted while the buttons are visible.
  3. With the buttons visible, click − in front of a group to close it and + to open it again.
  4. Click +/- Buttons again to hide them.

Tip The buttons appear only on rows or columns that hold at least two fields, and only on screen: they are not printed and do not reach the PDF.

Field Headers

Where to find it
  • Object › Data and Charts › PivotTable
  • Pane › PivotTable

Shows or hides the captions that name the fields above the rows and the columns, together with their filter arrows.

  1. Click any cell inside the PivotTable.
  2. Click Field Headers.
  3. The captions disappear from the sheet, and their filter arrows with them; click again to bring them back.
  4. With the captions visible, click the arrow next to the column-labels caption to filter the column items.

Tip Turn them off on a finished PivotTable that is meant to be read or printed; to filter again, turn them back on or use the Field List pane.

Subtotals

Where to find it
  • Object › Data and Charts › PivotTable
  • Pane › PivotTable

Decides whether each group of the PivotTable shows its own subtotal, and whether at the bottom of the group or at the top, on the group's own row.

  1. Click any cell inside the PivotTable.
  2. Click Subtotals.
  3. Choose Do Not Show Subtotals, Show All Subtotals at Bottom of Group or Show All Subtotals at Top of Group.
  4. The mark in the menu shows the choice in force.

Tip In tabular form the subtotal goes at the bottom anyway, because the group's row is also the row of its first item. A collapsed group shows its own total even with subtotals turned off.

Grand Totals

Where to find it
  • Object › Data and Charts › PivotTable
  • Pane › PivotTable

Decides whether the PivotTable ends with grand totals: the row at the bottom, the column on the right, both or neither.

  1. Click any cell inside the PivotTable.
  2. Click Grand Totals.
  3. Choose Off for Rows and Columns, On for Rows and Columns, On for Rows Only or On for Columns Only.
  4. Watch the total row or column appear or disappear.

Tip "Rows Only" totals each row, so it adds the total column on the right; "Columns Only" totals each column and adds the total row at the bottom. It is the same convention as Excel.

Report Layout

Where to find it
  • Object › Data and Charts › PivotTable
  • Pane › PivotTable

Chooses how the row fields are laid out: nested in a single column, or one column per field.

  1. Click any cell inside the PivotTable.
  2. Click Report Layout.
  3. Choose Show in Compact Form, Show in Outline Form or Show in Tabular Form.
  4. The PivotTable rearranges itself at once; Ctrl+Z goes back to the previous layout.

Tip Compact indents every level in the same column and is the narrowest; outline gives one column per field, with the group on its own row; tabular gives one column per field, with the group on the row of its first item.

Blank Rows

Where to find it
  • Object › Data and Charts › PivotTable
  • Pane › PivotTable

Inserts a blank row after each item of the outer fields, so the groups stand apart from one another, or removes it.

  1. Click any cell inside the PivotTable.
  2. Click Blank Rows.
  3. Choose Insert Blank Line after Each Item or Remove Blank Line after Each Item.

Tip Blank rows separate groups, so they matter when the rows hold at least two fields: with a single field there is nothing to separate.

Row Headers

Where to find it
  • Object › Data and Charts › PivotTable
  • Pane › PivotTable

Emphasizes the column of row labels with the heading treatment of the chosen style.

  1. Click any cell inside the PivotTable.
  2. Tick Row Headers.
  3. Clear the tick to give the row labels the look of the body.

Tip It is already ticked in a new PivotTable. These boxes always show the state of the PivotTable the active cell is in.

Column Headers

Where to find it
  • Object › Data and Charts › PivotTable
  • Pane › PivotTable

Emphasizes the header band above the values with the header treatment of the chosen style.

  1. Click any cell inside the PivotTable.
  2. Tick Column Headers.
  3. Clear the tick to give the header band the look of the body.

Tip This one too is already ticked in a new PivotTable. The effect depends on the style: Light styles give the header a soft tint, Medium and Dark ones a solid fill.

Banded Rows

Where to find it
  • Object › Data and Charts › PivotTable
  • Pane › PivotTable

Alternates the shading of the item rows, so a long row is easy to follow without losing your place.

  1. Click any cell inside the PivotTable.
  2. Tick Banded Rows.
  3. Clear the tick to go back to uniform rows.

Tip The bands apply to the item rows: the header, groups, subtotals and grand total keep the look the style gives them.

Banded Columns

Where to find it
  • Object › Data and Charts › PivotTable
  • Pane › PivotTable

Alternates the shading of the value columns, so a tall column is easy to follow without losing your place.

  1. Click any cell inside the PivotTable.
  2. Tick Banded Columns.
  3. Clear the tick to go back to uniform columns.

Tip Banded rows and banded columns together make a checkerboard and cancel the help each one gives: one of the two is usually enough.

PivotTable Styles

Where to find it
  • Object › Data and Charts › PivotTable
  • Pane › PivotTable

Applies a ready-made look to the whole PivotTable in one move: header, groups, subtotals, bands and grand total. There are 84 styles, in the Light, Medium and Dark families, plus None.

  1. Click any cell inside the PivotTable.
  2. Click Styles.
  3. Pick the style from the list that opens; in the Format pane the field shows the one in force.
  4. Choose None to drop colours and bands and keep only the bold on the header, groups and totals.

Tip The colours come from the accents of the workbook theme, so changing the theme recolours the PivotTable. The file stores only the style name, and in Excel the PivotTable shows with the matching style.

Clear Filter

Where to find it
  • Object › Data and Charts › Slicer
  • Pane › Slicer

Takes off the filter this slicer has applied, so the data behind it shows every row again.

  1. Click the slicer to select it.
  2. Click Clear Filter.
  3. Check that the data behind the slicer shows every row again.
  4. Click a slicer button when you want to filter afresh.

Tip This clears only what this slicer was filtering; other filters on the same data stay on.

Columns: 1

Where to find it
  • Object › Data and Charts › Slicer
  • Pane › Slicer

Lays the slicer buttons out in a single column, one under the other. It is the layout for a slicer standing in a narrow strip beside the data.

  1. Click the slicer to select it.
  2. Click 1.
  3. Check that the buttons now run in one column down the slicer.

Tip A single column keeps long value names readable, at the cost of a taller slicer.

Columns: 2

Where to find it
  • Object › Data and Charts › Slicer
  • Pane › Slicer

Lays the slicer buttons out in two columns, roughly halving the height of a slicer that has many values.

  1. Click the slicer to select it.
  2. Click 2.
  3. Check that the buttons now run in two columns.

Tip Two columns suit short values such as years or codes, where the names still fit in half the width.

Columns: 3

Where to find it
  • Object › Data and Charts › Slicer
  • Pane › Slicer

Lays the slicer buttons out in three columns, the most compact of the three layouts.

  1. Click the slicer to select it.
  2. Click 3.
  3. Check that the value names still read in the narrower buttons.

Tip The narrower the button, the less room a long name has; go back to 2 or 1 if the names stop reading.

Light

Where to find it
  • Object › Data and Charts › Slicer
  • Pane › Slicer

Applies the light style to the slicer, so it sits quietly beside the data it filters.

  1. Click the slicer to select it.
  2. Click Light.
  3. Check that the slicer reads clearly against the sheet behind it.

Tip Light is the one to use for a slicer standing among cells rather than on a coloured panel.

Dark

Where to find it
  • Object › Data and Charts › Slicer
  • Pane › Slicer

Applies the dark style to the slicer, which stands out on a pale sheet and suits a filter meant to be noticed.

  1. Click the slicer to select it.
  2. Click Dark.
  3. Check that the slicer reads clearly against the sheet behind it.

Tip The style is only a look: the values the slicer filters on are unaffected by it.

Accent 1

Where to find it
  • Object › Data and Charts › Slicer
  • Pane › Slicer

Applies the first accent colour to the slicer, tying it to the accent colours used elsewhere on the sheet.

  1. Click the slicer to select it.
  2. Click Accent 1.
  3. Check the slicer against the other filters on the sheet.

Tip Give the slicers that filter the same data the same accent, so the reader sees they work together.

Accent 2

Where to find it
  • Object › Data and Charts › Slicer
  • Pane › Slicer

Applies the second accent colour, to set this slicer apart from one already wearing the first.

  1. Click the slicer to select it.
  2. Click Accent 2.
  3. Check the slicer against the other filters on the sheet.

Tip Two slicers that filter different data read more clearly in two different accents.

Accent 3

Where to find it
  • Object › Data and Charts › Slicer
  • Pane › Slicer

Applies the third accent colour, the last of the three accents offered.

  1. Click the slicer to select it.
  2. Click Accent 3.
  3. Check the slicer against the other filters on the sheet.

Tip The accent carries no meaning of its own: pick the one that groups this slicer with the right neighbours.

Clear Filter

Where to find it
  • Object › Data and Charts › Timeline
  • Pane › Timeline

Takes off the filter this timeline has applied, so the data behind it shows every period again.

  1. Click the timeline to select it.
  2. Click Clear Filter.
  3. Check that the data behind the timeline shows every period again.

Tip This clears only what this timeline was filtering; filters set elsewhere on the same data stay on.

Years

Where to find it
  • Object › Data and Charts › Timeline
  • Pane › Timeline

Sets the timeline to step a year at a time. It is the level to use when the data spans several years and the detail inside them is noise.

  1. Click the timeline to select it.
  2. Click Years.
  3. Drag along the timeline to pick the years you want.
  4. Read the data behind it, now filtered to those years.

Tip Move down to Quarters or Months when a whole year proves too coarse to show what happened.

Quarters

Where to find it
  • Object › Data and Charts › Timeline
  • Pane › Timeline

Sets the timeline to step a quarter at a time, which suits data that is reported and compared by quarter.

  1. Click the timeline to select it.
  2. Click Quarters.
  3. Drag along the timeline to pick the quarters you want.
  4. Read the data behind it, now filtered to those quarters.

Tip Quarters sit between Years and Months: fine enough to show a season, coarse enough to keep a whole year on screen.

Months

Where to find it
  • Object › Data and Charts › Timeline
  • Pane › Timeline

Sets the timeline to step a month at a time, the usual level for a single year's worth of data.

  1. Click the timeline to select it.
  2. Click Months.
  3. Drag along the timeline to pick the months you want.
  4. Read the data behind it, now filtered to those months.

Tip If the run of months grows too long to work with, move up to Quarters.

Days

Where to find it
  • Object › Data and Charts › Timeline
  • Pane › Timeline

Sets the timeline to step a day at a time, for data where the exact date matters rather than the month it fell in.

  1. Click the timeline to select it.
  2. Click Days.
  3. Drag along the timeline to pick the days you want.
  4. Read the data behind it, now filtered to those days.

Tip Days is the finest level offered here; over a long period it makes a timeline too long to read at a glance.

Light

Where to find it
  • Object › Data and Charts › Timeline
  • Pane › Timeline

Applies the light style to the timeline, so it sits quietly beside the data it filters.

  1. Click the timeline to select it.
  2. Click Light.
  3. Check that the timeline reads clearly against the sheet behind it.

Tip Light is the one to use for a timeline standing among cells rather than on a coloured panel.

Dark

Where to find it
  • Object › Data and Charts › Timeline
  • Pane › Timeline

Applies the dark style to the timeline, which stands out on a pale sheet and suits a dashboard meant to be noticed.

  1. Click the timeline to select it.
  2. Click Dark.
  3. Check that the timeline reads clearly against the sheet behind it.

Tip The style is only a look: the periods the timeline filters on are unaffected by it.

Accent 1

Where to find it
  • Object › Data and Charts › Timeline
  • Pane › Timeline

Applies the first accent colour to the timeline, tying it to the accent colours used elsewhere on the sheet.

  1. Click the timeline to select it.
  2. Click Accent 1.
  3. Check the timeline against the other filters on the sheet.

Tip Give a timeline and the slicers that filter the same data the same accent, so the reader sees they belong together.

Accent 2

Where to find it
  • Object › Data and Charts › Timeline
  • Pane › Timeline

Applies the second accent colour, to set this timeline apart from one already wearing the first.

  1. Click the timeline to select it.
  2. Click Accent 2.
  3. Check the timeline against the other filters on the sheet.

Tip Two filters that work on different data read more clearly in two different accents.

Accent 3

Where to find it
  • Object › Data and Charts › Timeline
  • Pane › Timeline

Applies the third accent colour, the last of the three accents offered.

  1. Click the timeline to select it.
  2. Click Accent 3.
  3. Check the timeline against the other filters on the sheet.

Tip Pick an accent for what it groups the timeline with, not for its number: nothing else depends on the choice.

Edit Picture

Where to find it
  • Object › Illustrations › Picture
  • Pane › Picture

Opens the selected picture in the image editor, where you can draw on it, rub part of it out, crop it, straighten it or write on it. What you apply is written into the picture itself, not into the way the sheet shows it.

  1. Click the picture on the sheet.
  2. Click Edit Picture.
  3. Work on the image: draw, erase, fill, add a shape or some text, crop, rotate or flip.
  4. Click Apply to put the edited picture back on the sheet, or Cancel to leave it as it was.

Tip The picture keeps its box on the grid, and its crop, border and effects: only the stored image changes. Undo brings back the picture you started from.

Remove Background

Where to find it
  • Object › Illustrations › Picture
  • Pane › Picture

Finds the subject of a picture and makes everything around it transparent. The window proposes an outline as soon as it opens; you correct it by painting over what to keep and what to remove, and the outline follows.

  1. Click the picture on the sheet.
  2. Click Remove Background. The window opens and proposes an outline: everything under the magenta veil will be removed.
  3. If part of the subject is missing, choose Mark areas to keep and paint over it; if part of the background survives, choose Mark areas to remove and paint over that. The outline updates after every stroke.
  4. Use Adjust the area to keep when the subject was cut off by the initial frame, and the brush sizes for fine detail.
  5. Click the eye button to see the real transparency instead of the veil, then click Apply.

Tip The result is always saved as a PNG, because transparency needs one. The picture keeps its box on the grid, and its crop, border and effects: only the stored image changes. Undo brings back the picture you started from.

Erase

Where to find it
  • Object › Illustrations › Picture
  • Pane › Picture

Removes parts of the picture instead of covering them: whatever you erase becomes transparent, so what is behind shows through. It is the way to take a face, a number plate or a background out of a photo — covering it with a white rectangle only works while the background is white. Unlike the border, the effects and the crop, this changes the stored picture itself, not the way the sheet shows it.

  1. Click the picture on the sheet.
  2. Click Erase.
  3. Drag over the picture with the eraser: whatever you go over becomes transparent.
  4. Or choose the wand and click a background: every neighbouring pixel of a similar colour goes at once. The tolerance steps widen or narrow what it takes.
  5. Use the restore brush to bring back anything you removed by mistake, then click Apply to put the erased picture back on the sheet, or Cancel to leave it as it was.

Tip An erased picture is saved as PNG even when it arrived as a JPEG, because JPEG cannot hold transparency. The picture keeps its box on the grid, and with it its crop, border and effects: only the stored image changes. The command stays greyed out for a picture whose format the editor cannot open, and Undo brings the previous picture back.

Corrections

Where to find it
  • Object › Illustrations › Picture
  • Pane › Picture

Fine-tunes the sharpness, brightness and contrast of a picture. It is the first thing to try on a photo that looks flat, soft or too dark.

  1. Click the picture on the sheet.
  2. Click Corrections.
  3. A window opens with a large preview, a thumbnail of your picture for every preset and three sliders: drag one until the preview looks right, then click Apply. Reset puts all three back to normal.
  4. For a quick preset, click the arrow next to Corrections instead: pick one of the five sharpness amounts, or a cell of the brightness and contrast grid.
  5. Picture Corrections Options, at the bottom of that menu, opens the same window.

Tip Corrections change how the picture is shown, not the file behind it: to clear them, open the window again and click Reset. On a picture whose sharpness Office has already applied to the pixels, the Sharpen/Soften section shows a note instead of its thumbnails; Brightness/Contrast still works.

Color

Where to find it
  • Object › Illustrations › Picture
  • Pane › Picture

Changes a picture's colour: how strong the colours are, how warm or cool the light looks, and whether the whole picture is retinted in a single hue. Each choice is shown on the picture itself, so you choose what you can already see.

  1. Click the picture on the sheet.
  2. Click Color: the Picture Color window opens, with a live preview of your picture beside the settings.
  3. Pick a thumbnail under Color Saturation, Color Tone or Recolor — the three settings are independent, so choosing one keeps the other two — or drag the Saturation and Temperature sliders for an exact value. The preview follows every change.
  4. For a colour the bands do not offer, click More Variations: pick your colour and the window comes back with it applied, so you can still see it before you commit.

Tip Apply stays off until something changes, and Reset takes Saturation, Temperature and Recolor back to the original in one click. Each thumbnail shows your picture under that preset combined with what the other settings already are, so it shows where you would land — not the preset on its own. On a picture whose colour saturation and tone Office has already applied to the pixels, the Color Saturation and Color Tone bands show a note instead of their thumbnails; Recolor still works, and a picture replaced with Change Picture can be adjusted again. The saturation and tone you choose here — like sharpness and artistic effects — also show in Excel: the file carries the adjusted picture together with its original, and when you reopen it they are still editable (not for a GIF, BMP or WebP picture).

Artistic Effects

Where to find it
  • Object › Illustrations › Picture
  • Pane › Picture

Makes a picture look hand-made — a pencil sketch, a mosaic of bubbles, chalk on paper, canvas. The effect changes how the picture is drawn, never the picture file itself, so removing it gives you the original photograph back.

  1. Click the picture on the sheet.
  2. Click Artistic Effects: a window opens with a live preview of your picture beside the twenty-three effects.
  3. Click an effect — the preview shows it on your own photograph straight away.
  4. Fine-tune it with the two sliders under the gallery: the first is named after the effect you chose (Size, Pressure, Number of Shades…), the second is Transparency, which fades the effect back towards the original picture.
  5. Click Apply. To go back to the untouched photograph, click Remove effect.

Tip Every thumbnail shows the effect on your own picture, so you can compare them instead of trying them one by one. The sliders appear only once you have chosen an effect — with None there is nothing to adjust. Apply stays off until something changes, and the whole thing is a single undo step. On a picture whose effects Office has already applied to the pixels, Artistic Effects is greyed out: press it and a window explains why and what to do.

Transparency

Where to find it
  • Object › Illustrations › Picture
  • Pane › Picture

Makes a picture see-through, so whatever sits behind it — the sheet, the cells, another object — shows through. Use it to turn a photo into a watermark, or to soften a background image so the words on top stay readable.

  1. Click the picture on the sheet.
  2. Click Transparency: the Picture Transparency window opens, with a live preview of your picture beside the settings.
  3. Pick one of the seven presets, or drag the Transparency slider for an exact value: 0% is the full picture, 100% is invisible. The preview follows every change.
  4. Click Apply. To make the picture solid again, open the window and click Reset.

Tip The preview shows the picture over the document background.

Compress Picture

Where to find it
  • Object › Illustrations › Picture
  • Pane › Picture

Makes a picture lighter by storing fewer pixels for it. A photo taken by a phone often carries several times more pixels than the sheet can show, and those pixels travel inside the document forever: compressing throws away the ones nobody sees. The window shows both sides of the trade at once — how many bytes you save, and how the picture looks once it has been reduced.

  1. Click the picture on the sheet.
  2. Click Compress Picture.
  3. Pick a resolution: each row shows the pixels it leaves and the bytes it costs for this picture.
  4. Drag the handle across the preview to compare: the original is on the left, the compressed picture on the right.
  5. Click Apply.

Tip The byte size in each row is measured by encoding the picture for real, not estimated. Targets finer than the picture already is are not listed, because they would only make the file bigger. Compressing never moves the picture on the sheet: it changes how many pixels it stores, not how big it is shown.

Change Picture

Where to find it
  • Object › Illustrations › Picture
  • Pane › Picture

Replaces the selected picture with a different one, keeping its position and formatting. You choose the new picture from your device, Aerarys or your Photos library, and then decide how it goes into the frame the old one occupied — seeing the result before you confirm it.

  1. Click the picture on the sheet.
  2. Click Change Picture: the picture chooser opens on the source you used last. The arrow next to it goes straight to This Device, From Aerarys or From Photos.
  3. Choose the new picture: the Change Picture window opens and shows the frame your picture occupies with the new picture inside it.
  4. Choose how it fits. Fill the frame keeps the frame exactly as it is and crops what is left over; Fit in the frame shows the whole picture and shrinks the frame around it; Original size gives the picture its own size. Each option shows the size it produces.
  5. With Fill the frame you can drag the picture to move it inside the frame and scroll to zoom in; Recentre puts the framing back where it started.
  6. Click Replace: the new picture takes the place of the old one.

Tip Border, effects, alt text and position stay as they are — only the picture changes. Fill the frame is the only choice that leaves your layout exactly where it is, which is why it is the one you start on. Ctrl+Z brings the old picture back in a single step.

Reset Picture

Where to find it
  • Object › Illustrations › Picture
  • Pane › Picture

Puts a picture back the way it came in, dropping every change you have made to it. Use it when a run of adjustments has gone the wrong way.

  1. Click the picture on the sheet.
  2. Click Reset Picture: the Reset Picture window opens.
  3. Compare the two previews — Now and After restoring — and read the list of adjustments the picture carries.
  4. Every adjustment starts ticked: clear the tick of anything you want to keep.
  5. Click Restore. Everything left ticked goes back at once, in a single undo step.

Tip The command stays greyed out on a picture that carries no adjustment: there would be nothing to restore.

Picture Styles

Where to find it
  • Object › Illustrations › Picture
  • Pane › Picture

Puts the picture inside a ready-made frame: a white border with a soft shadow, rounded corners with a reflection underneath, an oval with soft edges. You choose by looking at twenty-two frames on your own photo, then move away from any of them with the controls underneath.

  1. Click the picture you want to frame.
  2. Click Picture Styles: the window opens with a live preview of your picture and twenty-two frames applied to it.
  3. Click a frame to apply it whole, then adjust it with the controls below: Shape, Border colour and width, Shadow, Reflection and Soft edges.
  4. Click Apply. To go back to the bare picture, open the window and click Remove frame.

Tip The preview shows the frame at the size the picture really has on the sheet: the same frame is imposing on a small photo and discreet on one that spans a dozen columns.

Picture Border

Where to find it
  • Object › Illustrations › Picture
  • Pane › Picture
  • Shortcut menu

Draws a frame around a picture on the sheet. The Picture Border window shows the border on your own picture, at the size it will have on the sheet, and lets you choose its colour, weight, dash pattern and compound type independently of one another.

  1. Click the picture you want to frame.
  2. Click Picture Border. The window opens with your picture on the left.
  3. Choose a colour, a weight, a dash pattern and a compound type. Each one changes only its own axis, so you can combine them freely.
  4. Watch the preview, then click Apply. Remove border takes the border away.

Tip On a sheet the border also marks where the picture ends and the grid begins, which matters when the image has a white background.

Picture Effects

Where to find it
  • Object › Illustrations › Picture
  • Pane › Picture
  • Shortcut menu

Adds a shadow, a reflection or a glow to a picture, so it reads as an object placed on the sheet rather than as part of the grid.

  1. Right-click the picture you want to change — the context menu opens.
  2. Choose Shadow, Glow or Reflection: the effect is applied straight away.
  3. Choose Effects: None from the same menu to take the effect away.
  4. Every choice is a single undo step, and travels in the .xlsx file.

Tip One effect at a time reads best on a sheet: a shadow lifts the picture off the grid, a glow tends to fight the cell borders.

Picture Layout

Where to find it
  • Object › Illustrations › Picture
  • Pane › Picture

Turns the picture into a diagram with a caption: the photo keeps its size and gains a text band below, above, beside or over it. You choose the arrangement by seeing it on your own picture, and type the caption in the same window.

  1. Click the picture you want to arrange.
  2. Click Picture Layout.
  3. The window opens with a live preview of your picture and four arrangements: caption below, caption above, caption beside and caption over the picture.
  4. Click an arrangement — the preview updates, showing the shape the figure will really have on the sheet.
  5. Type the caption in the box underneath, then click Apply.
  6. To change the arrangement or the caption later, select the figure and click Picture Layout again: the window reopens on the current arrangement, and Remove layout turns it back into a plain picture.

Tip The picture keeps the size it had: the diagram grows by the height of the caption band instead of shrinking the photo. It stays anchored where it was, and converting is a single undo step. Picture Layout stays available on the figure to change the arrangement or remove it.

Alt Text

Where to find it
  • Object › Illustrations › Picture
  • Pane › Picture

Stores a short written description of a picture for people who cannot see it. Worth doing on every image that carries information rather than decoration.

  1. Click the picture you want to describe.
  2. Click Alt Text.
  3. Type a description in the large box: the object is shown next to it, and a line underneath points out anything worth fixing.
  4. Confirm to store the description with the picture.

Tip On a sheet, say what the picture tells you about the data — a screen reader reads the description in place of the image, not alongside it.

Bring Forward

Where to find it
  • Object › Illustrations › Picture
  • Pane › Picture

Moves a picture up the stack, so it covers the objects it used to sit under. Pictures on a sheet overlap in the order they were added.

  1. Click the picture that is being covered.
  2. Click Bring Forward.
  3. To send it straight to the top of the stack, click the arrow next to Bring Forward and choose Bring to Front.
  4. Repeat until the picture sits where you want in the pile.

Tip The stacking order is a property of the sheet, not of the cells: moving a picture across the grid does not change it. To see the whole stack at once, choose Reorder Objects from the arrow: it lists every object from front to back and shows which one covers which.

Send Backward

Where to find it
  • Object › Illustrations › Picture
  • Pane › Picture

Moves a picture down the stack, so the objects around it show through. The counterpart of Bring Forward.

  1. Click the picture you want to move back.
  2. Click Send Backward.
  3. To send it straight to the bottom of the stack, click the arrow next to Send Backward and choose Send to Back.
  4. Repeat until the pictures overlap the way you want.

Tip A picture sent to the bottom still sits above the cells: the grid is not part of the stack. To see the whole stack at once, choose Reorder Objects from the arrow: it lists every object from front to back and shows which one covers which.

Selection Pane

Where to find it
  • Object › Illustrations › Picture
  • Pane › Picture

Lists every object on the sheet in one place. It is how you reach something buried under other objects, or hidden from view.

  1. Click Selection Pane.
  2. Read the list of objects on the sheet.
  3. Use it to show or hide an object.
  4. Close the pane when you are done.

Tip Hiding an object here only takes it off the view; it stays in the sheet and can be shown again.

Align

Where to find it
  • Object › Illustrations › Picture
  • Pane › Picture

Puts the selected picture against an edge of a rectangle on the sheet, or centres it there. Choosing the rectangle is half the command: a sheet has no page and no margin, so what you align to is what the sheet shows — the data, the cells you have selected, or the band of cells that prints on one page. The window names the rectangle and draws it, so you see where the picture will land before it moves.

  1. Click the picture you want to move.
  2. Click Align. The window opens and nothing has moved yet.
  3. Under Relative to, pick Data area, Selected range or Printed page; the sentence underneath says which cells each one covers.
  4. Pick a Horizontal alignment, a Vertical one, or both — each axis can be left Unchanged.
  5. Look at the preview, then click Align: both axes move the picture in a single undo step.

Tip The arrow next to Align keeps six quick alignments, one axis at a time and always relative to the data area. Aligning moves the picture without changing how it is anchored: one that keeps its size when a column widens goes on keeping it.

Group

Where to find it
  • Object › Illustrations › Picture
  • Pane › Picture

Ties a picture together with the other objects on the sheet, so they move, align and are deleted as one. Tabulys selects one object at a time, so the window is where you say which objects belong together — and the frame drawn on the map shows the shape the group will have before you make it.

  1. Click the picture you want to group.
  2. Click Group. The window opens on the objects of that sheet; the picture you started from is already in the group and has no check box.
  3. Tick every object that belongs with it, in the list or straight on the map. The frame grows to show what the group will cover.
  4. Read the sentence above the buttons: it says how many objects the group will hold.
  5. Click Group. From now on, moving, aligning or deleting any member moves, aligns or deletes them all, in a single undo.
  6. Use the arrow next to Group for Ungroup, or for Regroup to bring back the last group you took apart.

Tip Every object in a group keeps its own commands: you can still crop, recolour or rotate a single member without leaving the group. What the group governs is where the objects sit and how long they live — not the stacking order, which stays a property of the sheet.

Rotate

Where to find it
  • Object › Illustrations › Picture
  • Pane › Picture

Opens a window where you turn the picture by dragging a dial and read the angle in degrees as you go — any angle, not only quarter turns — and where you can flip it to its mirror image. The arrow next to the button keeps the four quick ways.

  1. Click the picture you want to turn.
  2. Click Rotate.
  3. Drag the dial to the angle you want, or use − and + to step one degree at a time.
  4. Use the quarter-turn buttons for an exact 90° or 180°, and Flip to mirror the picture.
  5. Click Rotate to apply, or Straighten to bring it back upright.

Tip Straighten clears the angle and both flips in one go. To straighten a scan that came in slightly askew, drag the dial a little and fine-tune with − and +: the dial does not snap.

Crop

Where to find it
  • Object › Illustrations › Picture
  • Pane › Picture
  • Shortcut menu

Cuts away the edges of a picture on the sheet so only the part you want is left. Crop opens a window showing the whole picture, with the part you are cutting away dimmed rather than hidden — so putting a piece back is as easy as taking it off. The picture is never squashed: the box on the grid follows the crop, so what stays keeps the size it had on the sheet.

  1. Click the picture on the sheet.
  2. Click Crop.
  3. Drag inside the crop window to move it, or drag a corner or edge handle to resize it.
  4. To cut to a set shape, pick one under Proportions — Square, 4:3, 16:9 and the others apply straight away.
  5. Click Crop to apply. Remove crop, in the window, puts the whole picture back.

Tip In the menu, the quicker ways follow the Crop item: Crop on the sheet drags handles directly on the picture, Crop values… takes exact percentages, and Remove crop clears the crop without moving the box.

Height

Where to find it
  • Object › Illustrations › Picture
  • Pane › Picture

Sets how tall the picture is on the sheet. The Picture Size window shows width and height together with the scale of the original picture, so you can also ask for half the size or go back to the original.

  1. Click the picture you want to resize.
  2. Click Height: the Picture Size window opens with the cursor in the Height box.
  3. Type the value you want and press Tab: with Lock aspect ratio on, the other side follows and the picture is not squashed.
  4. To resize by proportion instead, type a percentage in Scale height: 50 makes the picture half the size of the original.
  5. Click Apply.

Tip A sheet has no page and no margin, so nothing is too wide here: the preview draws no frame around the picture, and the note under the fields speaks only when you enlarge the picture well beyond its own pixels, where it starts to look blurry.

Width

Where to find it
  • Object › Illustrations › Picture
  • Pane › Picture

Sets how wide the picture is on the sheet. The Picture Size window shows width and height together with the scale of the original picture, so you can also ask for half the size or go back to the original.

  1. Click the picture you want to resize.
  2. Click Width: the Picture Size window opens with the cursor in the Width box.
  3. Type the value you want and press Tab: with Lock aspect ratio on, the other side follows and the picture is not squashed.
  4. To resize by proportion instead, type a percentage in Scale width: 50 makes the picture half the size of the original.
  5. Click Apply.

Tip A sheet has no page and no margin, so nothing is too wide here: the preview draws no frame around the picture, and the note under the fields speaks only when you enlarge the picture well beyond its own pixels, where it starts to look blurry.

Edit Shape

Where to find it
  • Object › Illustrations › Shape
  • Pane › Shape

Changes the outline of the selected shape. You can replace it with another shape from the catalogue — seeing how each one looks at the size your shape actually has — or edit its points one by one.

  1. Click the shape you want to change.
  2. Click Edit Shape: the window opens on Replace Shape.
  3. Pick a shape from the catalogue on the right: the stage shows what you will get, and the shape you started from stays visible underneath.
  4. To work on the outline instead, click Edit Points at the top of the window: drag a point to move it, drag its handles to bend the curves, and use the list on the right to add or remove points.
  5. Click Apply.

Tip Replacing a shape keeps its size, fill and outline — only the silhouette changes. Editing points is different: the shape stops being a preset shape and keeps the outline you drew.

Edit Text

Where to find it
  • Object › Illustrations › Shape
  • Pane › Shape

Writes or corrects the text inside the selected shape. You type in a comfortable box and see the result on the shape itself, at the proportions it really has.

  1. Click the shape you want to write in.
  2. Click Edit Text.
  3. Type in the box on the right: the preview on the left shows the text on the shape itself, as it will look.
  4. Press Enter for a new paragraph. If a line appears under the preview, the text does not fit in the shape.
  5. Click Apply, or press Ctrl+Enter.

Tip Paragraphs you do not change keep their formatting: correcting one word does not make the whole shape bold. Apply stays off until you have typed something.

Merge Shapes

Where to find it
  • Object › Illustrations › Shape
  • Pane › Shape

Builds one new shape out of two or more on the sheet: joining them, keeping only what they share, cutting one out of another, or splitting them along their overlaps. A window shows the result before you commit to it, because what a boolean operation produces is not something you can guess from its name.

  1. Click a shape on the sheet.
  2. Click Merge Shapes.
  3. Tick the other shapes you want to combine with it: the map on the left draws them as they really look.
  4. Choose an operation — Union, Combine, Fragment, Intersect or Subtract — and watch the preview change on the map.
  5. Click Combine.

Tip The shape you clicked is the first one: it is what Subtract removes the others from, and the result keeps its fill and outline. If the shapes do not overlap, Intersect produces nothing and the window says so instead of letting you commit.

Shape Styles

Where to find it
  • Object › Illustrations › Shape
  • Pane › Shape

Applies a coordinated fill and outline to the selected shape in one gesture, using the colours of the workbook theme so the shape matches the rest of the sheet.

  1. Click the shape you want to restyle.
  2. Click Shape Styles: the window opens on your own shape.
  3. Pick a style: every tile shows it on the shape you selected, so an arrow looks like an arrow and a star like a star.
  4. If one detail is not right, adjust the fill, the outline colour, its weight or its dashes without leaving the window.
  5. Click Apply.

Tip The six colours in the gallery are the ones of this workbook’s theme, not fixed colours: pick a style from the gallery and the shape follows when you change the theme. A colour picked by hand from the palette below stays exactly that colour.

Shape Fill

Where to find it
  • Object › Illustrations › Shape
  • Pane › Shape

Fills the selected shape with a solid colour, a gradient or a texture, and lets you make that fill see-through. You compose it in a window that draws the fill on your own shape, so what you pick is what the sheet will show.

  1. Click the shape you want to fill.
  2. Click the body of Shape Fill: the window opens on your own shape.
  3. Pick a kind on the right — Solid, Gradient or Texture. Each kind keeps its own settings, so switching between them never throws away what you built.
  4. Set that kind: a colour for a solid, a direction and the gradient stops for a gradient, a pattern and its two colours for a texture.
  5. Drag Transparency if you want the cells underneath to show through.
  6. Click Apply. To remove the fill instead, click No Fill at the bottom left — what you composed is kept, so you can bring it back.

Tip The arrow next to the button is the short way: No Fill, the same fifteen swatches the window offers, and More Fill Colors… — and picking a swatch there keeps the transparency you had already set. One thing worth knowing about themes: a colour you pick yourself stays exactly that colour, but if you only move the Transparency slider the shape keeps its theme colour and still follows the workbook theme.

Shape Outline

Where to find it
  • Object › Illustrations › Shape
  • Pane › Shape

Sets the line around the shape on the sheet: its colour, how thick it is, whether it is dashed, and what its ends look like.

  1. Click the shape whose outline you want to change.
  2. Click Shape Outline: a window opens showing the outline on your own shape, at the size it has on the sheet.
  3. Choose the colour, the weight and the dash pattern; on a line you can also choose the arrowhead at each end, separately for the start and the finish.
  4. Click Apply to write them all as a single change, or No Outline to remove the outline.
  5. Press Ctrl+Z to undo: the whole outline goes back in one step.

Tip Shape Styles and Shape Outline answer different questions: a style sets fill and outline together from a ready-made pair, this sets the line on its own. A style follows the workbook theme; a colour picked here by hand stays exactly that colour.

Shape Effects

Where to find it
  • Object › Illustrations › Shape
  • Pane › Shape

Adds a shadow, a reflection, a glow, soft edges, a bevel or depth to a shape on the sheet. The six are independent: a shape can carry a shadow and soft edges at the same time, and switching one off leaves the others alone.

  1. Click the shape you want to add effects to.
  2. Click Shape Effects: a window opens showing the effects on your own shape, at the size it has on the sheet.
  3. For the shadow, click the square that shows the direction you want it to fall in; the centre square means no shadow. Then set how transparent, how blurred and how far it is.
  4. Do the same for the other axes: pick a tint for the glow, and drag the sliders for reflection, soft edges, bevel and depth.
  5. Click Apply to write them all as a single change, or Remove all effects to clear them. One Ctrl+Z undoes all six together.
  6. Check the shape still reads at the size it is used: a large glow or a wide bevel eats into the shape itself.

Tip The glow tints are the six accents of this workbook’s theme, so the shape keeps matching the sheet when you change the theme. If the button is greyed out on a shape that came from Excel, that shape carries an effect Tabulys cannot rewrite — an inner shadow, a 3-D scene, or a colour tied to the theme — and it is left exactly as it is rather than being silently changed.

WordArt Styles

Where to find it
  • Object › Illustrations › Shape
  • Pane › Shape

Dresses the text inside the shape: the fill and the outline of the letters, plus the shadow, the reflection and the glow around them. The five are independent, so a text can carry a fill and a glow at the same time.

  1. Click the shape whose text you want to dress. The command stays greyed out until the shape holds text, and also when that text carries a decoration the window cannot rewrite — there, confirming would drop it in silence.
  2. Click WordArt Styles: a window opens showing your own text over the shape's own fill.
  3. Pick a tile: each row is one look — fill, fill and shadow, outline, reflection, glow — and each column is one accent of the workbook's theme.
  4. Adjust a single axis below if you want, then click Apply. The whole text of the shape changes in one step, and one undo puts it back.

Tip A tile is written as a theme colour, so changing the workbook's theme carries the styled text along with the rest of the sheet; a colour picked by hand stays that colour. Watch the preview before you apply: a light fill on a light shape is text that disappears.

Text Fill

Where to find it
  • Object › Illustrations › Shape
  • Pane › Shape

Sets the colour of the text inside a shape on the sheet. It is a different axis from the shape's own fill: the text is what falls on top of it, and the window shows the two together, so you can tell whether the letters stand out.

  1. Click the shape whose text you want to colour.
  2. Click Text Fill: a window opens showing your text on your own shape, at its real proportions.
  3. Pick a colour from the palette, or click More Colors… to choose any colour at all.
  4. If the window remarks that the text barely stands out, pick a colour further from the shape's fill.
  5. Click Apply. To leave the letters unpainted, click No Fill instead: the colour you picked is kept, so you can bring it back.

Tip The command is available only when the shape already has text: without letters there is nothing to colour. Write into the shape first, with Edit Text, and colour it afterwards. Unlike Verbys, the sheet offers no Transparency slider here: it cannot paint see-through letters, and a control that would change nothing is not offered at all. A transparency already stored in the file is left as it is.

Text Outline

Where to find it
  • Object › Illustrations › Shape
  • Pane › Shape

Sets the line drawn along the letters of the text inside the shape: its colour, how thick it is, and whether it is dashed.

  1. Click the shape whose text you want to outline.
  2. Click Text Outline: a window opens showing the outline on the shape's own text, in its own font and size.
  3. Choose the colour, the weight and the dash pattern. The preview follows every choice, and a note appears when the weight starts to close up the smallest text in the shape.
  4. Click Apply to write all three as a single change, or No Outline to remove the outline.
  5. Press Ctrl+Z to undo: the whole outline goes back in one step.

Tip Text Outline and Shape Outline are two different lines: one runs along the letters, the other around the shape itself. The right weight depends on the size of the text — 1 pt on 11 pt text closes up the counters of the letters, while on a 48 pt heading it is a hairline; that is why the window shows it on the real text. On a shape with no text the command stays greyed out: there is nothing to outline — write something first with Edit Text.

Text Effects

Where to find it
  • Object › Illustrations › Shape
  • Pane › Shape

Adds a shadow, a reflection or a glow to the text inside a shape on the sheet. The three are independent: text can carry a shadow and a glow at the same time, and switching one off leaves the others alone. The glow tints come from the workbook theme, so the halo follows a change of theme along with the rest of the sheet.

  1. Click the shape whose text you want to decorate. On a shape with no text the command stays greyed out — write inside it first with Edit Text.
  2. Click Text Effects: a window opens showing the shape's own text, inside the shape, on the shape's own fill.
  3. For the shadow, click the square that shows the direction you want it to fall in; the centre square means no shadow. Then set how transparent, how blurred and how far it is.
  4. For the reflection, choose how much of the mirrored copy stays visible, then set its transparency, blur and distance. For the glow, pick a tint from the workbook theme and a radius.
  5. Click Apply to write all three as a single change, or Remove all effects to clear them. Text fill and text outline are left exactly as they are — they have their own commands — and so is any effect you did not touch.
  6. Watch the line under the preview: it appears when an effect grows past the size of the smallest text in the shape. Press Ctrl+Z to undo: all three go back in one step.

Tip Effects are measured in points against the size of the letters, not against the shape: the same 3 pt shadow is a soft edge under a 60 pt heading and a second copy of the word under 9 pt text. That is why the note reads the smallest text in the shape, which a single preview cannot show. On a shape that came from Excel the command can stay greyed out even though the shape has text: it means the sheet cannot re-read the glyph style in full — a gradient text fill or an inner shadow, for instance — or that the runs carry different effects, so there is no single set to start from.

Alt Text

Where to find it
  • Object › Illustrations › Shape
  • Pane › Shape

Stores a short written description of the shape for people who cannot see it. The window draws the shape next to the box you describe it in, over the colour it sits on in the sheet, so you describe what you are looking at instead of what you remember.

  1. Click the shape you want to describe.
  2. Click Alt Text.
  3. Look at the drawing on the left: it is the shape as it stands on the sheet, with its fill, its outline, its effects and the way it is turned.
  4. Type a description in the large box. A line underneath points out anything worth fixing, and the counter shows how far you are from the recommended length.
  5. Choose OK to store the description with the shape.

Tip Say what the shape tells you about the data, not what it looks like: an arrow pointing at a total is not “an arrow”, it is “this is the figure that matters”. On a sheet a shape cannot be marked as decorative, so give even a divider or a frame a few plain words — otherwise the Accessibility Checker keeps reporting it.

Bring Forward

Where to find it
  • Object › Illustrations › Shape
  • Pane › Shape

Moves the shape up through the stack of overlapping objects, one step at a time or all the way to the front.

  1. Click the shape you want to move up.
  2. Click Bring Forward.
  3. Click the arrow next to Bring Forward to open the list instead: Bring Forward, Bring to Front and Reorder Objects. Nothing moves until you choose an entry.
  4. Check what is now covered by the shape.
  5. An entry that could not move the shape is switched off: at either end of the stack only Reorder Objects stays available, and a greyed-out button means the sheet holds a single object, with no stack to reorder.

Tip When several objects overlap, moving one forward always moves it *relative to the others*: the result depends on where they were, not only on where this one was. To see the whole stack at once, choose Reorder Objects from the arrow: it lists every object from front to back and shows which one covers which.

Send Backward

Where to find it
  • Object › Illustrations › Shape
  • Pane › Shape

Moves the shape down through the stack of overlapping objects, one step at a time or all the way to the back.

  1. Click the shape you want to move down.
  2. Click Send Backward.
  3. Click the arrow next to Send Backward to open the list instead: Send Backward, Send to Back and Reorder Objects. Nothing moves until you choose an entry.
  4. Check the shape is still findable — an object sent behind an opaque one can no longer be clicked.
  5. An entry that could not move the shape is switched off: at either end of the stack only Reorder Objects stays available, and a greyed-out button means the sheet holds a single object, with no stack to reorder.

Tip A shape sent to the back of an opaque object is still there: use the selection order, not the pointer, to get it back. To see the whole stack at once, choose Reorder Objects from the arrow: it lists every object from front to back and shows which one covers which.

Selection Pane

Where to find it
  • Object › Illustrations › Shape
  • Pane › Shape

Lists every object on the sheet in one place. It is how you reach something buried under other objects, or hidden from view.

  1. Click Selection Pane.
  2. Read the list of objects on the sheet.
  3. Click the eye at the end of a row to hide or show that object.
  4. Use Show all or Hide all at the foot of the pane to act on every object at once.
  5. Close the pane when you are done.

Tip Hiding an object here only takes it off the view; it stays in the sheet and can be shown again. To see the whole stack at once, choose Reorder Objects… from the Bring Forward or Send Backward submenu, or from their arrow in the Format pane: it lists every object from front to back and shows which one covers which.

Align

Where to find it
  • Object › Illustrations › Shape
  • Pane › Shape

Puts the selected shape against an edge of a rectangle on the sheet, or centres it there. Choosing the rectangle is half the command: a sheet has no page and no margin, so what you align to is what the sheet shows — the data, the cells you have selected, or the band of cells that prints on one page. The window names the rectangle and draws it, so you see where the shape will land before it moves.

  1. Click the shape you want to move.
  2. Click Align. The window opens and nothing has moved yet.
  3. Under Relative to, pick Data area, Selected range or Printed page; the sentence underneath says which cells each one covers.
  4. Pick a Horizontal alignment, a Vertical one, or both — each axis can be left Unchanged.
  5. Look at the preview, then click Align: both axes move the shape in a single undo step.

Tip A shape that belongs to a group is aligned by the group's frame, not by its own — the window says so before you apply. The arrow next to Align keeps six quick alignments, one axis at a time and always relative to the data area.

Group

Where to find it
  • Object › Illustrations › Shape
  • Pane › Shape

Ties a shape together with the other objects on the sheet, so they move, align and are deleted as one. Tabulys selects one object at a time, so the window is where you say which objects belong together — and the frame drawn on the map shows what the group will cover before you make it. The same list holds the pictures and charts anchored to that sheet, so a shape and a picture can end up in one group.

  1. Click the shape you want to group.
  2. Click Group. The window opens on the objects of that sheet; the shape you started from is already in the group and has no check box.
  3. Tick every object that belongs with it, in the list or straight on the map. The frame grows to show what the group will cover, and each row says which cells the object covers.
  4. Read the sentence above the buttons: it says how many objects the group will hold.
  5. Click Group. From now on, moving, aligning or deleting any member moves, aligns or deletes them all, in a single undo.
  6. Use the arrow next to Group for Ungroup, or for Regroup, which brings back the last group you took apart.

Tip It is the same group you compose starting from a picture: whichever object you start from, the window lists every object anchored to that sheet. Each member keeps its own commands, so you can still restyle, fill or turn a single shape without leaving the group.

Rotate

Where to find it
  • Object › Illustrations › Shape
  • Pane › Shape

Opens a window where you turn the shape by dragging a dial and read the angle in degrees as you go — any angle, not only quarter turns — and where you can flip it to its mirror image. The arrow next to the button keeps the four quick ways.

  1. Click the shape you want to turn.
  2. Click Rotate.
  3. Drag the dial to the angle you want, or use − and + to step one degree at a time.
  4. Use the quarter-turn buttons for an exact 90° or 180°, and Flip to mirror the shape.
  5. Click Rotate to apply, or Straighten to bring it back upright.

Tip Flipping an arrow is not the same as rotating it twice: a flip mirrors the shape, and any text inside it stays the right way round.

Crop Shape

Where to find it
  • Object › Illustrations › Shape
  • Pane › Shape

Trims the selected shape down to a rectangle you draw over it. Whatever falls outside the rectangle is removed, and the shape's frame shrinks to the rectangle — so what is left keeps the same size on the sheet.

  1. Click the shape on the sheet you want to crop.
  2. Click Crop.
  3. Drag a corner or edge handle to set the rectangle, or drag inside it to move it.
  4. If you like, pick a proportion on the right to keep the rectangle square, 4:3, 16:9 and so on.
  5. Click Crop to apply, or Whole shape to start over.

Tip Cropping a shape is not the same as cropping a picture: a picture only hides the part you cut away, a shape loses it. The window shows the shape whole, with the part you are removing under a veil, because that is the only chance to change your mind — afterwards only Ctrl+Z brings it back. If Crop stays greyed out, the selected shape has no area to cut: a line has nothing for the rectangle to intersect.

Height

Where to find it
  • Object › Illustrations › Shape
  • Pane › Shape

Sets how tall the selected shape is on the sheet. The Shape Size window shows the width and the height together and draws the shape at the size you are choosing, so you can see what a measurement costs before you apply it.

  1. Click the shape you want to resize.
  2. Click Height: the Shape Size window opens with the cursor in the Height box.
  3. Type the value you want and press Tab: the drawing on the left redraws at the new size.
  4. Tick Lock aspect ratio if you want the other side to follow, so the shape keeps its proportion.
  5. Click Apply.

Tip Watch the drawing, not only the numbers: the outline of a shape depends on its frame, so a star squeezed into a narrow box stops looking like a star. There are no scale boxes here as there are for a picture, because a shape has no original size for a percentage to refer to.

Width

Where to find it
  • Object › Illustrations › Shape
  • Pane › Shape

Sets how wide the selected shape is on the sheet. It opens the same Shape Size window as Height, with the cursor in the Width box: a width on its own is not a choice, because whether the height follows depends on Lock aspect ratio — which sits right next to the two numbers.

  1. Click the shape you want to resize.
  2. Click Width: the Shape Size window opens with the cursor in the Width box.
  3. Type the value you want and press Tab: the drawing on the left redraws at the new size.
  4. Tick Lock aspect ratio if you want the height to follow.
  5. Click Apply.

Tip A sheet has no page and no margin, so nothing is too wide here: the preview draws no frame around the shape. Lock aspect ratio starts off for a shape — stretching a rectangle into a banner is an ordinary thing to do, unlike squashing a photograph. Resizing does not change how the shape behaves when a column widens: it goes on doing what it did before.

Edit Icon

Where to find it
  • Object › Illustrations › Icon
  • Pane › Icon

Puts a different icon in place of the one you selected, keeping the frame it occupies. The window shows the icon that is there now next to the one you are choosing, and draws both in the proportions of the frame they occupy on the sheet — so what you see in the window is what you get on the page. Icons are grouped by category, the same categories as the Insert gallery they come from.

  1. Click the icon on the sheet you want to change.
  2. Click Edit Icon.
  3. Type part of an icon's name in the search box at the top of the catalogue to narrow it down, or scroll the catalogue on the right. Hovering a tile shows its name.
  4. Click the icon you want: it appears beside the current one, in the frame it will occupy.
  5. Click Apply.

Tip The frame does not move: the new icon takes exactly the space the old one had, so nothing around it shifts. To change how big it is, use Height and Width.

Edit Text

Where to find it
  • Object › Illustrations › Icon
  • Pane › Icon

Writes the label that goes beside the icon on the sheet — the word the icon stands for — and chooses on which of its four sides it sits. The window draws the icon with the label as it will look on the sheet, at the real proportions and on the sheet's background, so you can see straight away whether the word is too long for the picture or breaks in an awkward place. The label belongs to the drawing: it moves, is deleted and is resized with it, and it is not a text box you can drag somewhere else.

  1. Click the icon on the sheet.
  2. Click Edit Text.
  3. Type the label. The preview redraws as you type.
  4. Choose where it sits: below, above, left or right.
  5. Click Apply.

Tip The icon keeps its size: the frame grows to make room for the label, so nothing you had sized changes. Clear the text and apply to remove the label — the drawing goes back exactly to the icon it was. The label is not the alternative text: that one is read aloud to people who cannot see the icon, and you write it with Alt Text.

Combine Icons

Where to find it
  • Object › Illustrations › Icon
  • Pane › Icon

Turns this icon and one or more icons from the catalogue into a single icon. You arrange them inside the frame the icon already occupies on the sheet - drag one to move it, drag its corners to resize it - and choose how they combine: Union keeps everything they cover, Combine turns the overlaps into holes, Intersect keeps only what all of them cover, and Subtract removes the others from the one you started from. The window draws the result while you compose it, so you never have to apply it to find out what it looks like.

  1. Click the icon on the sheet you want to combine.
  2. Click Combine Icons.
  3. Scroll the catalogue on the right and click an icon to add it: it lands on the stage, smaller and centred, over the one you started from.
  4. Drag it to move it, or drag a corner handle to resize it, until the two overlap the way you want.
  5. Pick one of the four operations below the stage and watch the preview change.
  6. Click Combine.

Tip The frame does not move: the combined icon takes exactly the space the old one had, so nothing on the sheet shifts. If the preview goes empty, the icons do not overlap enough for the operation you picked - the line above the buttons says so, and Combine stays off until there is something to produce. You can combine up to six icons at a time, and a single undo brings back the icon you started from. If the icon carries a label, the composition uses the icon's own frame and not the one grown to fit the word.

Quick Styles

Where to find it
  • Object › Illustrations › Icon
  • Pane › Icon

Recolours the icon on your sheet: the fill of its strokes and the outline around them, chosen together from a gallery that draws every tile on your own icon. Thirty-six tiles - six families down, six accents across - and the two families at the top have no fill at all, which does not merely change the colour of the pictogram: it turns it into line art. The accents are the ones from your workbook theme, the same that colour the shapes and charts on the sheet. Below the gallery the same two axes are there on their own, so you can step away from a tile by one notch and watch the icon while you do it.

  1. Click the icon on your sheet.
  2. Click Quick Styles.
  3. Look at the preview on the left: it is your icon, at the size it currently has, on the colour it sits on.
  4. Click a tile to apply it. The row picks the look, the column picks the theme accent.
  5. To step away from the tile, pick another fill or outline colour, or drag the Weight slider.
  6. Click Apply.

Tip The outline scales with the icon: it is kept as a share of the icon's own size, so the same icon looks the same at any size, and enlarging it does not leave a hairline behind. If the icon carries a label beside it, recolouring touches the pictogram only: the word stays as it was and the frame does not move. Reset puts the icon back to the look it had before it was first recoloured - black without an outline for an icon from the catalogue, its own colour for one that came from another file, even after the file has been saved and reopened - and not to nothing: if you take away both the fill and the outline yourself, a line under the preview warns you the icon will not be visible. Quick Styles stays greyed out on a drawing this window cannot rewrite in full, such as one that already carries several colours.

Icon Fill

Where to find it
  • Object › Illustrations › Icon
  • Pane › Icon

Sets the colour of the inside of the icon — the pictogram itself, not a frame around it. The window shows the icon at the size it has on your sheet and, above all, on the colour it actually sits on, because a colour for a pictogram has no quality of its own: it has one relative to what is behind it. The palette is the same as the Quick Styles gallery, and the accents are the ones from your workbook theme, the same that colour the shapes and charts on the sheet: a colour you can reach through one door you can reach through the other. The first cell means no fill at all — the hollow icon, which stays a drawing for as long as an outline traces it. The outline is left exactly as it is: it has its own command. And if the icon carries a label beside it, filling touches the pictogram only: the word stays as it was and the frame does not move.

  1. Click the icon on your sheet.
  2. Click Icon Fill.
  3. Pick a colour, or the first cell to leave the icon hollow.
  4. The arrow keys move the choice by one cell, and vertically by a whole row.
  5. Read the line under the preview: it tells you whether the colour you picked will actually show.
  6. Click Apply.

Tip The line under the preview is a measurement, not an opinion: it compares the colour you picked with the sheet background behind the icon and reports the contrast ratio. Below 3:1 an icon is hard to make out — it is the minimum the accessibility standard asks for a graphical object (WCAG 2.1, Non-text Contrast). It is a note and never a ban: you can apply any colour. A second line appears when the fill comes too close to the outline the icon carries, because at that point the outline you chose elsewhere stops being visible. And if you take the fill away from an icon that has no outline, there is nothing left to draw — the window says so. Icon Fill stays greyed out on a drawing this window cannot rewrite in full, such as one that already carries several colours.

Icon Outline

Where to find it
  • Object › Illustrations › Icon
  • Pane › Icon

Sets the colour and the thickness of the line that runs around the icon's paths. The window shows the icon itself, at the size it has on your sheet and on the colour it sits on, because an outline is only worth what is behind it: a pale line on a pale sheet is a line you cannot see. The palette is the same one as the Quick Styles gallery — and the six accents are your workbook theme's own, the same ones that colour the shapes and charts on the sheet — so a colour you can reach through one door you can reach through the other, and the first swatch means no outline at all. The fill stays exactly as it is — it has its own command — but you can see it, because it is half of what you are judging.

  1. Click the icon on your sheet.
  2. Click Icon Outline.
  3. Pick a colour, or the first swatch if you want no outline.
  4. Drag the Thickness slider; the arrow keys move it one step at a time.
  5. Watch the small mark on the slider: past it, this icon's strokes start to touch.
  6. Click Apply.

Tip The small mark on the thickness slider is measured on your own icon, not estimated: it is the width at which that drawing closes up — where an inner gap fills in, or two separate parts weld into one. A solid, compact drawing never closes, and then there is no mark at all. You can go past it: the slider does not stop, a line under the preview simply tells you, with the number. The outline scales with the icon, so the same icon looks the same at any size and enlarging it does not leave a hairline; if the icon carries a label beside it, the thickness is measured against the icon and not against the frame that also holds the word. Icon Outline stays greyed out on a drawing the window cannot rewrite as a whole, for example one that already carries several colours — the same drawing on which the Quick Styles gallery stays greyed out too.

Icon Effects

Where to find it
  • Object › Illustrations › Icon
  • Pane › Icon

Puts a shadow, a glow or a reflection on the icon. All three fall on the pictogram itself, not on the rectangle of empty space around it: a shadow follows the drawing's own outline, and a glow surrounds its strokes. The three are independent, so an icon can carry a shadow and a glow at the same time, and switching one off leaves the others alone. The window draws your own icon, at the size it has on the sheet and on the colour the sheet gives it — which matters more here than anywhere else, because a shadow is dark and a glow is light, and on a coloured sheet they are worth something different. If the icon carries a label beside it, the effects are measured against the icon and not against the frame that also holds the word.

  1. Click the icon on your sheet.
  2. Click Icon Effects.
  3. For the shadow, click the square that shows the direction you want it to fall in; the centre square means no shadow. Then set how transparent, how blurred and how far away it is.
  4. For the glow, pick a tint, then set its size and how transparent it is. The first swatch, the one crossed through, removes the glow.
  5. For the reflection, choose Reflected, then set how transparent, how blurred and how far below the icon it sits.
  6. Watch the preview on the left while you drag: it is your icon with the real effects on it.
  7. Click Apply to write all three as a single change, or Remove all effects to clear them.

Tip Effects are measured in points, and an icon is mostly empty space: what you are really covering is the thickness of its strokes, which on a normal icon is only a few points. That is why the sliders start smaller here than for a photograph, and why a line under the preview warns you when a glow is wide enough to close the gaps in the drawing, or a shadow far enough to read as a second copy of it. The warning never stops you — it is a note, not a rule. Icon Effects does not change the drawing itself: removing them puts the icon back exactly as it was, and the same icon file stays in the workbook. It is also the one icon style command that stays available on an icon drawn in several colours — a logo, say — where Quick Styles, Icon Fill and Icon Outline all grey out: those three rewrite the drawing, this one only reads its shape. In a PDF the shadow and the glow are printed with the pictogram's own outline, though with a hard edge rather than a soft one; the reflection is not printed.

Reset Icon

Where to find it
  • Object › Illustrations › Icon
  • Pane › Icon

Puts the icon back the way it was. The window shows the icon twice, side by side and at the same scale — as it is now, and as it would be after restoring — with one line for each thing that has actually changed: its size, the way it has been turned, the colour of the pictogram itself, and any border or frame it carries. Every line starts ticked, so restoring everything is a single click; untick the ones you want to keep. The size it goes back to is the icon's own natural size, the one it had when it was first inserted: it is not remembered but worked out from the icon itself, so it is right even after you have swapped the icon or combined it with another. The colour goes back to the one the icon had before it was recoloured — a recoloured icon carries its original with it, even after saving and reopening, so an icon from the catalogue goes back to black and one that arrived blue from another file goes back to blue — and that is the same place the Reset button inside Quick Styles takes it, so the two can never disagree. An icon that was never recoloured here, or one drawn in several colours, has no colour to go back to, and that line is simply not there.

  1. Click the icon on your sheet.
  2. Click Reset Icon.
  3. Compare the two previews: Now on the left, After restoring on the right.
  4. Untick any line you want to keep — Size, for example, if you resized the icon on purpose.
  5. Check the preview on the right: if you had recoloured the icon, the pictogram is shown back in black.
  6. Click Restore.

Tip The command stays greyed out while the icon has nothing to restore, so a greyed Reset Icon means the icon is already the way it came in. An icon with a label beside it can still be restored to its natural size: the frame is scaled back and the label scales with it, exactly as it does when you drag a handle. Nothing you have written is touched: the label and the alt text are content, not formatting, and Reset Icon never removes them. A single undo brings everything back at once, however many lines you ticked — including the colour, which lives in the icon's own drawing rather than in the workbook.

WordArt Styles

Where to find it
  • Object › Illustrations › Icon
  • Pane › Icon

Chooses how the letters of the icon's **label** look — the word beside it on the sheet, not the pictogram. The pictogram has its own commands (Quick Styles, Icon Fill, Icon Outline, Reset Icon); this one dresses the word. The dialog shows thirty ready-made styles — five families across six colours — and below them the five axes for stepping away from one: text fill, outline and its weight, shadow direction, reflection extent, glow tint and radius. The six colours are the accents of the **workbook theme**, the same ones that colour the shapes and charts of the sheet, so a tile you pick follows the workbook when its theme changes. The preview is not a lookalike drawing: it is the real icon with its real label, in the position it has on the sheet and on the sheet's own background colour, drawn by the same engine that draws them in the grid. Applying writes the style as a single history entry, so one Ctrl+Z removes all of it. The drawing does not change size, because a style does not move where the letters wrap.

  1. Click the icon on the sheet.
  2. If the icon has no label yet, write one first with Edit Text. Without a label the WordArt Styles command stays greyed out, because there are no letters to dress.
  3. Click WordArt Styles.
  4. Pick one of the thirty styles: each row is a look, each column a colour.
  5. Adjust the axes below the gallery to step away from the style you picked.
  6. Watch the preview on the left: it shows the label as it will sit beside the icon.
  7. Click Apply. Remove style returns the label to plain letters.

Tip The preview background is the sheet's own background colour, and that matters: half of the ready-made styles have a light fill, which on a light sheet is nearly invisible text. Seeing the style against the real background before you commit is exactly what the dialog is for. The letters follow the drawing: enlarge the icon by dragging a handle and the label grows with it, and so do the shadow, the outline and the glow — a style chosen on a small icon does not stay the same size on a large one. Changing the label text later with Edit Text does not remove the style — fixing a typo does not strip the word. Removing the label entirely does remove the style, because nothing is left to dress.

Text Fill (icon)

Where to find it
  • Object › Illustrations › Icon
  • Pane › Icon

Sets the colour of the icon's label: the word beside it on the sheet, the one written with Edit Text. It does not colour the pictogram — that has its own commands — and it does not colour letters inside the icon, because an icon has no text inside it. The dialog shows the icon with its label at true proportions and on the sheet's own background colour, because a colour for a word has no quality of its own: it has one relative to what the word falls on. The palette is the same one used to colour the text of a shape, because a label is text. Next to the colours there is Automatic, which is not black: it means the colour the sheet gives its own text, and it changes with it.

  1. Click the icon on the sheet.
  2. If the icon has no label yet, write it first with Edit Text. Without a label the Text Fill command stays greyed out, because there are no letters to colour.
  3. Click Text Fill.
  4. Pick a colour, or More Colours to compose one.
  5. The arrow keys move the selection by one cell, and vertically by a whole row.
  6. Read the line under the preview: it says whether the label will actually be readable.
  7. Click Apply.

Tip The line under the preview is a measurement, not an opinion: it compares the chosen colour with the sheet background the label falls on and reports the contrast ratio. Below 4.5:1 text of that size is hard to read — it is the minimum the accessibility standard asks for small text (WCAG 2.1, Contrast Minimum). It is a note and never a ban. The threshold is higher than Icon Fill's 3:1: that is not an inconsistency, they are two different criteria — there a drawing is measured, here letters. Changing the word later with Edit Text does not change its colour, and dressing it with WordArt Styles does not clear it: the three commands differ by what they leave alone. For a translucent label or hollow letters, those are chosen from WordArt Styles, which is the command that governs them.

Text Outline (icon)

Where to find it
  • Object › Illustrations › Icon
  • Pane › Icon

Draws an outline around the letters of the icon's label - the word beside it on the sheet, the one written with Edit Text - and sets its colour, width and dash. It does not outline the pictogram's paths: those have Icon Outline. It is the same window used to outline the text of a shape, opened on the label: the three axes compose, so choosing a dash does not mean giving up the colour. The preview shows two things at once, at two distances: on top the word enlarged, where you see how the stroke runs on the letters; below the icon with its label on the sheet background, at the size it will really have.

  1. Click the icon on the sheet.
  2. Click Text Outline.
  3. Choose a colour, or More Colours to compose one.
  4. Choose a width from the row, or drag the slider for a value in between.
  5. Choose a dash, if needed.
  6. Look at the two preview panes and read the line below.
  7. Click Apply; No Outline removes the outline.

Tip The stroke is centred on the letters' profile, so half of it grows inwards: past a certain width the counters - the holes in a, e, o, g - close up and the word becomes a blot. The line under the preview says so when it happens; it is a note and never a ban. A label's size is always 11 points, so a few tenths of a point are enough: on a large heading the same width would be a hairline. The lower pane exists for exactly this - it shows the word at its real size, which the enlarged one cannot. Text Outline stays grey on an icon without a label: write the label first with Edit Text. And do not confuse it with Icon Outline, which draws the pictogram's border. Changing the word later does not change its outline, and dressing it with WordArt Styles does not clear it: the commands differ by what they leave alone.

Text Effects (icon)

Where to find it
  • Object › Illustrations › Icon
  • Pane › Icon

Sets a shadow, a reflection and a glow on the letters of the icon's label - the word beside it on the sheet, the one written with Edit Text. It does not decorate the strokes of the pictogram: those have Icon Effects. It is the same window used to decorate the letters of a shape, opened on the label: the three effects combine, so switching on a glow does not switch off the shadow. The six glow colours are the accents of the workbook theme, so the label follows a theme change like everything else on the sheet. The preview shows two things at once, for two different questions: above, the word magnified, where you see what the effect looks like; below, the icon with its own label on the sheet background, at its true size, where you see where the effect lands.

  1. Click the icon on the sheet.
  2. Click Text Effects.
  3. For the shadow, pick a direction in the grid; the middle cell removes it.
  4. For the reflection, pick how far it extends; None removes it.
  5. For the glow, pick a colour; the first swatch removes it.
  6. Adjust transparency, blur, distance and radius with the sliders.
  7. Look at both preview panes and read the line below them.
  8. Click Apply; Remove All Effects clears all three.

Tip An effect reaches outside the word, and an icon's label has a neighbour: the pictogram, a sixteenth of an inch away. The default glow already reaches it, and a reflection touches it when the label sits above the icon. That is not a mistake - sometimes it is exactly the effect you want - but you cannot see it in the magnified word, which shows only the word: the lower pane is what tells you, and that is why it shrinks as the glow grows, so it can show it whole. A label is always 11 points, so a shadow offset by a few points already reads as a second copy of the word; the line below the preview says so when it happens, and it is a note and never a ban. Text Effects leaves the colour and the outline of the letters alone: those have their own commands. It stays greyed out on an icon without a label: write the label first with Edit Text. And do not confuse it with Icon Effects, which decorates the pictogram itself, measured against its ink instead of against the size of the letters.

Alt text

Where to find it
  • Object › Illustrations › Icon
  • Pane › Icon

Writes the sentence that reaches anyone who cannot see the icon: a screen reader reads it in place of the symbol. An icon almost always stands in for a word, so what goes here is what it means, not what it looks like.

  1. Click the icon on the sheet you want to describe.
  2. Click Alt text.
  3. Type one or two sentences saying what the icon tells the reader.
  4. Click OK.

Tip Describe the meaning, not the drawing: a padlock beside a price is “secure payment”, not “a padlock”.

Bring forward

Where to find it
  • Object › Illustrations › Icon
  • Pane › Icon

Moves the icon one step up the stack of overlapping objects, or straight to the top. The arrow beside the button opens the list with both, plus the window that shows the whole stack at once.

  1. Click the icon on the sheet you want to move up.
  2. Click the arrow beside Bring forward.
  3. Choose Bring forward for one step, or Bring to front to put it above everything.
  4. Choose Reorder objects… to see the whole stack and drag the icon into place.

Tip When the icon is already on top there is nothing to raise it above, and the two entries that would do it are switched off rather than doing nothing.

Send backward

Where to find it
  • Object › Illustrations › Icon
  • Pane › Icon

Moves the icon one step down the stack of overlapping objects, or all the way to the back. The arrow beside the button opens the list with both, plus the window that shows the whole stack at once.

  1. Click the icon on the sheet you want to move down.
  2. Click the arrow beside Send backward.
  3. Choose Send backward for one step, or Send to back to put it under everything.
  4. Choose Reorder objects… to see the whole stack and drag the icon into place.

Tip Sending an icon behind a filled shape hides it completely: reach it again from the Selection pane, which lists what the pointer can no longer find.

Selection pane

Where to find it
  • Object › Illustrations › Icon
  • Pane › Icon

Opens the side panel that lists every object on the sheet, so you can reach one the pointer cannot — an icon buried behind a picture, or one that has been sent to the back.

  1. Click Selection pane.
  2. Click a name in the list to select that object.
  3. Double-click a name to rename it.
  4. Click the eye beside a name to hide that object without deleting it.

Tip Renaming is what makes the list usable: “Icon 7” tells you nothing next month, “download icon” does.

Align

Where to find it
  • Object › Illustrations › Icon
  • Pane › Icon

Lines the icon up against a reference — a margin, the sheet, or the other objects you have selected — instead of nudging it by eye.

  1. Click the icon on the sheet you want to line up.
  2. Click Align.
  3. Choose what to align to, then the edge or the centre you want.
  4. Click Align.

Tip Aligning a row of icons to their centres makes them read as one band, which nudging never quite achieves.

Group

Where to find it
  • Object › Illustrations › Icon
  • Pane › Icon

Ties the icon to the other objects you choose, so they move, align and are deleted as one. A group is a relationship and not a container: each icon keeps its own commands and its own settings.

  1. Click the icon on the sheet you want to put in a group.
  2. Click Group.
  3. Tick the objects that go in — the map shows the frame the group will have, growing as you tick.
  4. Click Group.

Tip Taking a group apart remembers it: Regroup brings back the last one you undid, so you can try a layout without losing it.

Rotate

Where to find it
  • Object › Illustrations › Icon
  • Pane › Icon

Opens a window where you turn the icon by dragging a dial and read the angle in degrees as you go — any angle, not only quarter turns — and where you can flip it to its mirror image.

  1. Click the icon on the sheet you want to turn.
  2. Click Rotate.
  3. Drag the dial to the angle you want, or use − and + to step one degree at a time.
  4. Use the quarter-turn buttons for an exact 90° or 180°, and Flip to mirror the icon.
  5. Click Rotate to apply, or Straighten to bring it back upright.

Tip Flipping an arrow icon is not the same as rotating it twice: a flip mirrors the symbol, so a left arrow becomes a right one.

Crop

Where to find it
  • Object › Illustrations › Icon
  • Pane › Icon

Keeps only the part of the icon inside a rectangle you choose. Crop opens a window showing the whole icon, with the part you are cutting away dimmed rather than hidden — so putting a piece back is as easy as taking it off. The icon is never squashed: the frame follows the crop, so what stays keeps the size it had on the sheet. Nothing is thrown away — Remove crop, in the same window, brings the whole icon back.

  1. Click the icon on the sheet.
  2. Click Crop.
  3. Drag inside the crop window to move it, or drag a corner or edge handle to resize it.
  4. To cut to a set shape, pick one under Proportions — Square, 4:3, 16:9 and the others apply straight away.
  5. Click Crop to apply. Remove crop puts the whole icon back, frame and all.

Tip Cropping does not redraw the icon: it chooses which part of it you are looking at, and you can change your mind at any time. That is what makes it different from Combine icons, which really does cut the drawing. You can also crop straight on the sheet — right-click the icon and choose Crop to drag the brackets — but only the window shows you what you are throwing away before you commit. And whatever you keep stays sharp at any size, which is why the window shows only the icon’s name where a photograph would show a pixel count. An icon has no pixels to count.

Height

Where to find it
  • Object › Illustrations › Icon
  • Pane › Icon

Opens the size window with the keyboard already on the height box. An icon is drawn from its outline, so it stays sharp at whatever size you give it — there is no resolution to lose.

  1. Click the icon on the sheet you want to resize.
  2. Click Height.
  3. Type the height you want.
  4. Leave the aspect-ratio lock on to keep the symbol's proportions, or turn it off to stretch it.
  5. Click OK.

Tip Unlike a photograph, an icon never goes soft when you enlarge it: it is redrawn at the new size, not scaled up.

Width

Where to find it
  • Object › Illustrations › Icon
  • Pane › Icon

Opens the size window with the keyboard already on the width box — the same window that Height opens, because a width chosen without knowing whether the proportions are locked is not yet a choice.

  1. Click the icon on the sheet you want to resize.
  2. Click Width.
  3. Type the width you want.
  4. Leave the aspect-ratio lock on to keep the symbol's proportions, or turn it off to stretch it.
  5. Click OK.

Tip Turning the lock off squashes the symbol: a stretched icon reads as a mistake far sooner than a stretched photograph does.

3D Model Views

Where to find it
  • Object › Illustrations › 3D Model
  • Pane › 3D Model

Chooses which of fourteen directions the model is seen from — six faces and eight corners.

  1. Select the model.
  2. Click 3D Model Views: the gallery opens with fourteen tiles.
  3. Each tile draws your model seen from that direction, so you choose by looking and not by name.
  4. The tile of the current view is highlighted; a model turned freely elsewhere highlights none.
  5. Click a tile to apply that view, in a single undo step.

Reset 3D Model

Where to find it
  • Object › Illustrations › 3D Model
  • Pane › 3D Model

Brings the model back to the view it came in with.

  1. Select the model.
  2. Click Reset 3D Model.
  3. The view goes back to the one the model was inserted with; size and position stay as you left them.

Alt Text

Where to find it
  • Object › Illustrations › 3D Model
  • Pane › 3D Model

Writes the description that reaches whoever cannot see the model.

  1. Select the model.
  2. Click Alt Text.
  3. Type one or two sentences saying what the object shows.
  4. The window flags a description that is too short or that opens with a filler phrase; the advice never blocks you.
  5. Click OK: the description travels with the file.

Text Pane

Where to find it
  • Object › Illustrations › SmartArt
  • Pane › SmartArt

Opens the pane where the diagram's entries are written. Each line is one shape in the graphic and its indent is its level, so the whole diagram is edited as an outline instead of shape by shape.

  1. Click the diagram.
  2. Click Text Pane.
  3. Type one entry per line; press Enter for a new line and Tab to make it a sub-entry.
  4. Use Promote and Demote to change a line's level, Move Up and Move Down to reorder.
  5. Pick another layout from the gallery at the top if you want a different kind of diagram.
  6. Click OK — the diagram is redrawn with the new text.

Tip The colours stay as you set them: correcting a word does not undo a Change Colors.

Change Layout

Where to find it
  • Object › Illustrations › SmartArt
  • Pane › SmartArt

Lays the same entries out as a different kind of diagram — a list becomes a process, a process becomes a cycle — without retyping anything. The text and the colours are kept.

  1. Click the diagram you want to lay out differently.
  2. Click Change Layout.
  3. Choose a layout from the list — the diagram is redrawn straight away.
  4. If it is not what you wanted, press Ctrl+Z or pick another one.

Tip The frame keeps the size you gave it: the diagram is laid out again inside it.

Change Colors

Where to find it
  • Object › Illustrations › SmartArt
  • Pane › SmartArt

Recolours the diagram with the colours of the workbook theme: either the whole run of accents, or a single accent for a quieter, one-colour graphic.

  1. Click the diagram you want to recolour.
  2. Click Change Colors.
  3. Choose Colorful to cycle through all six accents, or a single accent swatch for a one-colour diagram.
  4. The diagram is recoloured straight away.

Tip The swatches show the accents of this workbook's theme, so what you see in the list is what the diagram will look like.

Reset Graphic

Where to find it
  • Object › Illustrations › SmartArt
  • Pane › SmartArt

Puts the diagram's colours back to the default of the workbook theme, leaving its text, its structure and its layout untouched.

  1. Click the diagram you want to reset.
  2. Click Reset Graphic.
  3. The diagram goes back to the default colours.

Tip Only the colours are reset. What you typed and the layout you chose stay as they are — press Ctrl+Z if you want to undo more than that.

Back to the guide

Productivity, made in Italy.

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