Tabulys guide

Edit

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

Undo

Where to find it
  • Edit
  • Toolbar
Ctrl+Z

Takes back what you just did. Press the button itself to undo one step, exactly like Ctrl+Z; use the arrow beside it when you want to go further back and see the list of what you have done.

  1. Click Undo to take back the last action.
  2. Click it again for each further step you want to take back.
  3. To go back several steps at once, click the arrow beside the button.
  4. In the window, pick the action you want to return to: it and every more recent one are ticked, and the row tells you how many actions will be undone.
  5. Click Undo.

Tip The button turns itself off when there is nothing left to undo, so a grey Undo means you are already back at the beginning. Anything you undo can still be redone one step at a time with Ctrl+Y. After every undo, and every Ctrl+Y, the selection moves to the cells that changed, even when they are on another sheet, so you can see at once what went back to how it was.

Cut

Where to find it
  • Edit › Clipboard
  • Shortcut menu
Ctrl+X

Takes the selected cells out of the sheet and holds them on the clipboard, ready to be put somewhere else. Use it to move data rather than duplicate it.

  1. Select the cell or range you want to move.
  2. Click Cut.
  3. Select the cell where the data should end up.
  4. Click Paste to drop it there.

Tip Nothing leaves its old place until you paste, so a cut you never paste changes nothing. When you paste elsewhere, even on another sheet, the moved formulas still read the same cells, and the formulas that read the cut cells follow them to their new place.

Copy

Where to find it
  • Edit › Clipboard
  • Shortcut menu
Ctrl+C

Puts a duplicate of the selected cells on the clipboard and leaves the originals where they are. It is the first half of every copy and paste.

  1. Select the cell or range you want to duplicate.
  2. Click Copy.
  3. Select the cell where the copy should start.
  4. Click Paste.

Tip What you copied stays on the clipboard, so you can paste it into as many places as you like until you copy something else.

Paste

Where to find it
  • Edit › Clipboard
  • Shortcut menu
Ctrl+V

Puts whatever you last cut or copied into the sheet, starting at the selected cell. The Paste Special submenu offers the other ways of pasting the same clipboard contents.

  1. Cut or copy the cells you want to reuse.
  2. Select the cell where the pasted block should start.
  3. Click Paste.
  4. To paste a different way, choose from the Paste Special submenu.

Tip Pasting a range writes over whatever is already in the cells it covers, so leave room for it.

Format Painter

Where to find it
  • Edit › Clipboard
  • Pane › Cells
  • Shortcut menu

Copies the look of a cell rather than its contents, and applies it elsewhere. Use it to make a range match a cell you have already formatted.

  1. Select a cell that already carries the formatting you want.
  2. Click Format Painter.
  3. Drag across the cells that should take on that formatting.

Tip Only the formatting travels: the values and formulas in the cells you paint stay as they were.

Fill

Where to find it
  • Edit › Cells
Ctrl+D

Copies the contents of the first cell of a selection into the rest of it. Use it to carry a formula down a column, or a value across a row.

  1. Select the cell that holds what you want to repeat, together with the cells it should fill.
  2. Click Fill to fill down.
  3. In the menu, Fill opens a submenu: choose Down, Right, Up or Left, or Series to build a series of numbers or dates.
  4. In the Series window choose which way the series runs, its type, the step value and — from a single cell — the stop value: the Preview shows the values before you click OK.

Tip Filling writes over whatever is in the cells it covers, so select only as far as you mean to go. The Series window tells you how many cells already contain data before you confirm.

Clear

Where to find it
  • Edit › Cells
  • Shortcut menu

Empties the selected cells while leaving them in place. You can take out what they hold, how they look, or both.

  1. Select the cell or range you want to empty.
  2. Click Clear.
  3. In the menu, Clear opens a submenu: choose between removing the contents, the formats or both.

Tip To take the cells themselves out and close the gap behind them, use Delete Cells.

Delete Cells

Where to find it
  • Edit › Cells
  • Shortcut menu

Takes cells out of the sheet altogether and closes the gap with the cells around them. This is not the same as emptying them: the space itself goes.

  1. Select the cells you want to remove.
  2. Click Delete: the cells below move up, or the cells to the right move left if the selection is taller than it is wide.
  3. To choose the direction yourself, or to delete entire rows or columns, choose Delete Cells… from the Delete submenu, or press Ctrl+- or right-click and choose Delete….

Tip To empty cells while leaving them where they are, use Clear instead.

Find & Select

Where to find it
  • Edit › Find and Select

Looks through the sheet for what you type, and can select every cell that matches. Use it to track down a value in a large workbook, or to pick out the cells of a particular kind. When there is nothing to find it tells you: the Find window says, in a highlighted line, that there are no matches, quoting the text and where it looked, and the commands that select cells open a “No cells were found” notice.

  1. Click Find & Select.
  2. In the menu, the items that follow Find & Select let you choose between finding text and selecting cells by what they contain.
  3. Type what you are looking for in the dialog that opens.
  4. Step through the matches, or take them all at once.

Tip Once a set of cells is selected this way, you can format the lot in one go.

Back to the guide

Productivity, made in Italy.

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