# How to flip / reverse a column order vertically (upside down) in Excel

*Learn how with formulas to turn to MS EXCEL the column upside down (so that the data located in the last row, began to appear first).*

suppose you have a data column (Source column (column A)). In the first cell of the column (** A7**) contains the value 10, and the last (

**) - a value of 100.**

*A16*using the formula

=offset($A$16,(ROW($A$7)-ROW()),)

in the adjacent column will receive the inverted column (type this formula into a cell ** V7 **and pull downwards with the help of Token fill).

**note**: a Source column and the formula can be found in example file.

a Similar result can be achieved using the formula

=INDEX($A$7:$A$16,ROWS(A7:$A$16))

More information about used features can be read by clicking on the corresponding link at the bottom of the article in the tab *Used feature* (under the button *Download sample file*).

**note**: to rotate a column, i.e. to transpose it, see Transposing tables in MS EXCEL.