# FLIPCELLS

#### Syntax <a href="#syntax" id="syntax"></a>

**FLIPCELLS**(*range*; *direction*)

* *range* - the range which should be flipped - ***Value type**: range*
* *direction* - the direction in which the range should be flipped - ***Value type**: constant (optional, default: horizontal)*

  Possible values are

  * *horizontal* - flip the range horizontally (reverse order of columns)
  * *vertical* - flip the range vertically (reverse order of rows)
  * *both* - flip the range both horizontally and vertically

#### Remarks <a href="#remarks" id="remarks"></a>

* This function is particularly useful in combination with MOVECELLS to guarantee that leaf cells of a column-based hierarchy appear in the first column.
* Common use cases include easier retrieval of leaf elements from a column-based hierarchy and quick reversion of row order.