How to Flip Data Order of Columns or Rows in Excel Office 365?
Tags: flipdataorderofcolum, kutoolsexceltutorial, kutools
Published: 2020-10-15 12:04:01

---
title: How to Flip Data Order of Columns or Rows in Excel Office 365?
published: true
date: 2020-10-15 11:35:21 UTC
tags: FlipDataOrderofColum,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-flip-data-order-of-columns-or-rows-in-excel-office-365/
---

In this tutorial, we will provide the step-by-step instructions to **Flip or Reverse Data Order of Columns or Rows in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

## Reverse Data Order of Multiple Columns Horizontally:

To reverse the data order of multiple columns in the worksheet, you can use the **Flip Horizontal Range** option of Kutools.

- You need to **select the range** of data that you want to reverse the order horizontally.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-21.png)<figcaption id="caption-attachment-15775">Example</figcaption>

- Go to the **Kutools**   **Tab, select** the **Range** option, **choose** the **Flip Horizontal Range** option, then **click** the **All** option.

![Select All option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-All-option.png)<figcaption id="caption-attachment-15776">Select All option</figcaption>

- Now, all data order in the range has been reversed **horizontally** as shown in the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Result-15.png)<figcaption id="caption-attachment-15777">Result</figcaption>

### Additional Information:

- You can flip only the cell values in the selected range.
- To do that, go to the **kutools Tab** > **Range** > **Flip Horizontal Range** > **Only flip values**.

![Select Only flip values](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/1-17.png)<figcaption id="caption-attachment-15778">Select Only flip values</figcaption>

- After selecting the Only flip values option, you will get the result as shown in the below screenshot.

![Only flip Values](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/5-7.png)<figcaption id="caption-attachment-15827">Only flip Values</figcaption>

## Steps to Reverse Data Order of Multiple Rows Vertically:

If you want to reverse the data order of multiple rows vertically, use the **Flip Vertical Range** option of Kutools.

- You need to **select the range** of data that you want to reverse the order vertically.

![select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/2-14.png)<figcaption id="caption-attachment-15779">select the range</figcaption>

- On the **Kutools**   **Tab, select** the **Range** option, **choose** the **Flip Vertical Range** option, then **click** the **All** option.

![Select Flip Vertical Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/3-12.png)<figcaption id="caption-attachment-15780">Select Flip Vertical Range</figcaption>

- Now, all data order in the range has been **reversed vertically** as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-30.png)<figcaption id="caption-attachment-15781">Output</figcaption>

### Note:

- You can flip only the cell values in the selected range.
- To do that, go to the **kutools Tab** > **Range** > **Flip Vertical Range** > **Only flip values**.

![Select Only flip values](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/4-6.png)<figcaption id="caption-attachment-15782">Select Only flip values</figcaption>

- After selecting the **Only flip values** option, you will get the result as shown in the below screenshot.

![Only flip Values](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/5-7.png)<figcaption id="caption-attachment-15827">Only flip Values</figcaption>

From the above image, you can see that the order of the cells has been flipped from the last value to the first value in the selected range.

In this way, you can flip data order in an Excel worksheet for both columns and rows.

## Summary:

In this tutorial, you can clearly grasp the instructions to **Flip or Reverse Data Order of Columns or Rows in Excel Office 365** using **Kutools.** Leave your **Queries/Suggestions** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [Merge Adjacent Cells in Columns with Same Data/Value](https://geekexcel.com/merge-adjacent-cells-in-columns-with-same-data-value-in-excel/)
- [Insert File Name and File Path into Cell, Header or Footer in Excel](https://geekexcel.com/insert-file-name-and-file-path-into-cell-header-or-footer-in-excel/)