Flip data in Excel vertically or horizontally

Elegant way to reverse columns and rows

Whether you need to flip a block of numbers, names, or letters, Flip Range for Excel will do it for you. Instead of writing different VBA codes to flip your table upside down or from left to right, reverse data order of columns or rows with a mouse click.

Free download Ultimate Suite for:
2019 365 2016 2013 2010
Download this and 60+ other tools for Excel included in Ablebits Ultimate Suite

14-day fully functional version
Flip Range for Excel 2019, 2016 - 2010

With Flip Range you will

  • Reverse values vertically Choose to mirror rows in Excel upside down.
  • Flip data horizontally Flip columns in Excel left to right.
  • Transfer cell references correctly Keep them unchanged or adjusted, or paste values only.
  • Choose to preserve original formatting of cells Decide what to do with formatting if your tables have any.

Reverse the order of cells in Excel an easy way

Adjust flipping options as you need
Adjust flipping options as you need
See your flipped table in another worksheet
See your flipped table in another worksheet

License benefits

Our customers get

Unconditional 60-days money-back guarantee
Life-time license, no additional
fees ever
Free life-time support
Secure payment guarantee
Volume discounts: the more you buy, the less you pay

These companies choose Ablebits products

Frequently asked questions

What is Flip Range and what do I need it for?

The tool flips data in Excel vertically or horizontally. You can choose to reverse the order of rows and columns in the entire worksheet or select a part of it for modification. In addition, the add-in lets you transfer the references correctly, keeps the formatting of current cells and backs up your original table.

Can't I just sort the values in Excel?

To use the Sort option for this case you'll have to prepare your table: create a helper column/row, enumerate each cell according to a row/column number, select this additional range and the one you want to reverse, sort by helper range Largest to Smallest, and then delete the additional column/row. The task becomes more peculiar when you need to flip a part of a row or a column.

With Flip Range you just select the range of interest and click Flip.

How to flip data in Excel with the Flip Range add-in?

To reverse ranges in Excel, do the following:

  1. Run the add-in and choose to flip vertically or horizontally.
  2. Select your range.
  3. Decide what to do with cell references.
  4. See if you want to preserve formatting.
  5. Choose the option to create a backup copy.
  6. Click Flip.

See a more detailed description here.

How many rows or columns can I flip at a time?

The range to flip can contain as many rows and columns as you choose to reverse.

Supported versions

Microsoft Excel

  • Excel included in ​Microsoft 365 (formerly Office 365)
  • Excel 2019
  • Excel 2016
  • Excel 2013
  • Excel 2010
  • 32-bit and 64-bit
  • Note! Office Insider is not supported

Windows

  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7
  • 32-bit and 64-bit
  • Note! Windows insider is not supported
  • Note! Surface Pro X and Windows X are not supported

Any questions or comments?

Please contact us here

Our working hours:
12:00 am - 10:00 am PST; 3:00 am - 1:00 pm EST; 8:00 am - 6:00 pm CET.

Your message was successfully sent.

Thank you for contacting us!
We will get back to you shortly.

You will receive a delivery confirmation for your message within a few minutes. If you don't get it, please re-send your message and make sure you entered a valid e-mail address.

Close