Cells & content

Clear Cell All .xlsx

Removes a cell entirely — both its content and its formatting.

When to use it: to wipe a cell completely, leaving it as if it had never been touched.

Important behavior: deletes the whole cell. If the cell does not exist there is nothing to remove, so the instruction does nothing.

Clear Cell Content .xlsx

Removes a cell’s value (and any formula) but keeps its formatting.

When to use it: to empty a cell while preserving its colors, borders, and number format.

Important behavior: clears the value and formula; the cell’s style is left untouched. Does nothing if the cell does not exist.

Clear Cell Format .xlsx

Removes a cell’s formatting but keeps its value.

When to use it: to strip styling from a cell while keeping what it says.

Important behavior: removes the cell’s style, keeping its content. Does nothing if the cell does not exist.

Copy Cell .xlsx

Copies one cell’s value and formatting to another cell.

When to use it: to duplicate a cell elsewhere without retyping it.

Important behavior: copies the value, type, and style from source to target, creating the target cell if needed. Does nothing if the source cell does not exist or the target address is invalid.

Copy Range .xlsx

Copies a rectangular block of cells to a new location.

When to use it: to duplicate a table or block of cells elsewhere on the sheet.

Important behavior: copies each cell’s value, type, and style, keeping the block’s shape, and places its top-left at the target start. Empty cells in the source are skipped. Does nothing if any of the addresses is invalid.

Define Named Range .xlsx

Gives a friendly name to a cell or range so formulas can refer to it by name.

When to use it: to make formulas readable — for example =SUM(Sales) instead of =SUM(B2:B10).

Important behavior: creates the named range; if a range with that name already exists, it is replaced. If the start and end cells are the same, the name points to a single cell. Does nothing if Range name is empty, or if Sheet name does not match an existing tab (which would otherwise create a broken name).

Delete Cell Comment .xlsx

Removes the note attached to a cell.

When to use it: to clear a comment you no longer need.

Important behavior: removes the comment and its on-sheet marker. Does nothing if the cell has no comment.

Delete Hyperlink .xlsx

Removes the link from a cell but keeps the text shown in it.

When to use it: to turn a clickable cell back into plain text.

Important behavior: removes the hyperlink; the displayed text stays in the cell. Does nothing if the cell has no link.

Delete Named Range .xlsx

Removes a previously defined named range.

When to use it: to clean up a name you no longer use.

Important behavior: removes the named range. Does nothing if Range name is empty or no range has that name.

Find Text In Sheet .xlsx

Lists every cell in a sheet whose content contains a piece of text.

When to use it: to locate where a word or value appears, or to count how many cells contain it, and feed that into later instructions.

Important behavior: scans the sheet and collects the addresses (like B4) of cells that contain the search text, then optionally saves the list of addresses and the count. Does nothing if Search text is empty. With Case-sensitive off, upper- and lowercase are treated as the same.

Insert Hyperlink .xlsx

Turns a cell into a clickable web link.

When to use it: to add a link to a website in a cell.

Important behavior: sets the cell’s text to the display text — or to the URL itself when display text is empty — and links it to the address. Any existing link on that cell is replaced. The URL must be a full web address (including https://); if it is empty or not a full address, nothing happens (the cell is left untouched). Does nothing either if the cell address is invalid.

Iterate Rows .xlsx

Publishes the rows of a sheet into a variable, so a For Each can walk them one by one.

When to use it: to go through a sheet row by row — totalling, checking, or copying each row somewhere else.

Only the rows the file has: a gap between row 3 and row 7 is not four empty turns. A row that skips a column does not shift the ones after it, because every cell carries its own address.

Important behavior: the turns are a copy taken when the instruction runs: what the loop walks does not change if the body edits the document. To leave a result back in the row, write it by position — but this format is the one exception: Write Cell Value takes a cell address, not a row number, so there is no “(from variable)” field for the Index to feed. Build the address first with Set Text Variable — text D{row} with the Index of the For Each saved as row — and pass the saved variable to Cell address as @cellAddress.

The turn is not the row of the sheet. The Index counts turns: 1 for the first row walked. With a header row and no gaps that means the sheet row is Index + 1, which is what the address above assumes. If the sheet has empty rows in between, that sum is wrong — and nothing reports it, the value simply lands on the wrong row.

Merge Cells .xlsx

Joins a rectangular range of cells into a single larger cell.

When to use it: to make a heading span several columns, for example.

Important behavior: merges the range into one cell. If that exact range is already merged, nothing changes (no duplicate merge is created).

Move Cell .xlsx

Moves a cell’s value and formatting to another cell, emptying the original.

When to use it: to relocate a cell’s content in a single step.

Important behavior: copies the value, type, and style to the target, then removes the source cell. Does nothing if the source cell does not exist or the target address is invalid.

Read Cell Value .xlsx

Reads what is in a cell and saves it into a named value for later instructions.

When to use it: to pick up a value from the sheet and reuse it elsewhere in the workflow.

Important behavior: reads the cell’s displayed value (resolving shared text automatically) and stores it under the Save value to name. If the cell is empty or does not exist, an empty value is saved. If Save value to is empty, nothing is saved.

A cell holding a formula reads as empty, and the run says so. A formula written by the workflow —=SUM(D2:D11)— is not worked out by the engine but by the spreadsheet program when someone opens the file, so there is no value to read yet. To have that number in the workflow, walk the rows with Iterate rows and add them up with Aggregate list.

Replace Text In Sheet .xlsx

Finds and replaces text across all cells of a sheet.

When to use it: to fix a recurring word or value everywhere it appears in a sheet.

Important behavior: replaces occurrences of the search text with the replacement in every cell, and optionally saves how many cells were changed. With Match whole cell only on, only cells whose entire content equals the search text are replaced (and the whole cell is replaced); with it off, the text is replaced wherever it appears inside a cell. Does nothing if Search text is empty.

Set Cell Comment .xlsx

Attaches a note (comment) to a cell, with an author name.

When to use it: to leave an explanation or reminder on a cell.

Important behavior: adds the note to the cell and shows the usual comment marker. If the cell already has a comment, it is replaced.

Unmerge Cells .xlsx

Splits a previously merged range back into individual cells.

When to use it: to undo a merge.

Important behavior: removes the merge for that exact range. Does nothing if that range is not currently merged.

Write Cell Value .xlsx

Writes a value into a single cell.

When to use it: to fill in a cell with text, a number, or a date.

Important behavior: writes the value into the cell, creating the cell if needed. The value is stored as a number if it looks like one, otherwise as text; turn on Treat value as a date to store it as a date when the text can be read as one. Does nothing if the cell address is invalid.

Write Range Values .xlsx

Fills a block of cells from a single delimited list of values.

When to use it: to load a small table into the sheet in one instruction.

Important behavior: splits Values into rows (by the row separator) and cells (by the column separator) and writes them starting at the start cell. With Fill by row on, values fill left-to-right then down; with it off, they fill top-to-bottom then across (the block is transposed). Each value is typed automatically (number or text). Does nothing if Values is empty or either separator is empty.